Search found 133 matches

by vazquezrosariop
Tue Aug 14, 2018 2:51 pm
Forum: CloverETL Support
Topic: Executing against multiple databases (outside Clover Server if possible)
Replies: 3
Views: 50

Re: Executing against multiple databases (outside Clover Server if possible)

Hi vinny, Unfortunately, for the specific use case you are describing a CloverETL Server is the only way possible. The DbInputTable is designed to only accept one database names/hosts/username/password in the connection per graph execution. The only way to accomplish your use case would be to build ...
by vazquezrosariop
Mon Aug 06, 2018 3:00 pm
Forum: CloverETL Support
Topic: Flat file size allowed in CloverETL
Replies: 1
Views: 22

Re: Flat file size allowed in CloverETL

Hi chanduBI, FlatFileReader should be capable of reading upwards of millions of records, now we are talking about performance it depends of the structure of the data (ex. number of columns), but it should process the records in a reasonable amount of time. The second part of your question, FlatFileR...
by vazquezrosariop
Thu Apr 12, 2018 3:32 pm
Forum: CloverETL Support
Topic: How do we pass the password type as "Password Text"
Replies: 7
Views: 533

Re: How do we pass the password type as "Password Text"

Hi Girish,

Unfortunately, WebServiceClient component is not available in Community version of Designer if you wish to use the component you will a need a commercial license of Designer.
by vazquezrosariop
Thu Apr 12, 2018 1:05 pm
Forum: CloverETL Support
Topic: MongodbWriter create ObjectId
Replies: 1
Views: 199

Re: MongodbWriter create ObjectId

Unfortunately, that function will not work in the MongoDBWriter component since we require Strict JSON mode. I would recommend using the builtin "_id" field. All new object IDs in this field will be automatically generated when a new object is inserted.
by vazquezrosariop
Mon Apr 02, 2018 6:09 pm
Forum: CloverETL Support
Topic: How do we pass the password type as "Password Text"
Replies: 7
Views: 533

Re: How do we pass the password type as "Password Text"

Hi Girish,

It should regardless of the version you are currently running, but I will attach the example created in CloverETL version 4.3.0.

Regards,

wdslExampleUpdated.grf
(2.07 KiB) Downloaded 23 times
by vazquezrosariop
Mon Apr 02, 2018 1:46 pm
Forum: CloverETL Support
Topic: Read Specified file .zip file - no error raised if file does not exist in zip?
Replies: 3
Views: 728

Re: Read Specified file .zip file - no error raised if file does not exist in zip?

Hi Heather,

Just wanted to let you know a fix you your zip file issue was added in CloverETL Designer 4.7.0

Regards,
Pedro
by vazquezrosariop
Thu Mar 29, 2018 2:16 pm
Forum: CloverETL Support
Topic: How do we pass the password type as "Password Text"
Replies: 7
Views: 533

Re: How do we pass the password type as "Password Text"

Hi,

If you want to add the Password Text you will need to do so in the Request Header structure of the WebServiceClient component. I have attached and example graph were you can see the wsse Password Type = PasswordText.

WsdlExample.grf
(2.07 KiB) Downloaded 27 times
by vazquezrosariop
Wed Mar 28, 2018 5:25 pm
Forum: CloverETL Support
Topic: Unable to Extract the fields from the XML String
Replies: 7
Views: 457

Re: Unable to Extract the fields from the XML String

Hi, It appears that you still had some difficulties with the mapping, in cases like this its important to use the Populate parent record. A good tip is using the root element of the data you need to extract for example in your case it would be Worker and then use Populate parent record for all the o...
by vazquezrosariop
Wed Mar 28, 2018 3:07 pm
Forum: CloverETL Support
Topic: How do we pass the password type as "Password Text"
Replies: 7
Views: 533

Re: How do we pass the password type as "Password Text"

Hi, Could elaborate more on what you are trying to accomplish: ⋅ What web service are you using? ⋅ What component are you using?(ex. WebServiceClient) ⋅ What do you mean by password text? ⋅ What type of error message do you receive when you try to run the grap...
by vazquezrosariop
Wed Mar 28, 2018 3:02 pm
Forum: CloverETL Support
Topic: Getting RUN_ID
Replies: 2
Views: 218

Re: Getting RUN_ID

Hi sshrestha,

Of course, RUN_ID and ROOT_RUN_ID are both parameter values that can be access using CTL. You use getParmValue("") to extract the current RUN_ID and ROOT_RUN_ID of the job you are running.
by vazquezrosariop
Wed Mar 28, 2018 1:58 pm
Forum: CloverETL Support
Topic: Unable to Extract the fields from the XML String
Replies: 7
Views: 457

Re: Unable to Extract the fields from the XML String

Hi,

It would be helpful if you could please post the structure of the XML you are trying to extract, without any sensitive data of course.

Thank You,
by vazquezrosariop
Tue Mar 27, 2018 2:15 pm
Forum: CloverETL Support
Topic: Unable to Extract the fields from the XML String
Replies: 7
Views: 457

Re: Unable to Extract the fields from the XML String

Like I mentioned prior you can use the XMLExtract to extract the fields you mentioned. You can follow the same steps as described in the following forum post:

https://forum.cloveretl.com/viewtopic.php?f=5&t=7541&p=13089#p13095
by vazquezrosariop
Mon Mar 26, 2018 7:22 pm
Forum: CloverETL Support
Topic: Unable to Extract the fields from the XML String
Replies: 7
Views: 457

Re: Unable to Extract the fields from the XML String

Hello Girish, Could you please elaborate more on what exactly you are trying to accomplish? Based on the payload sent you are using the XMLExtract to process information from a Salesforce SOAP API, and everything looks in order. Are you getting an error of sorts when extracting the data? Also is the...
by vazquezrosariop
Fri Mar 23, 2018 2:10 pm
Forum: Cookbook
Topic: Devops on CloverETL
Replies: 1
Views: 225

Re: Devops on CloverETL

Hi Rajat,

At this moment CloverETL does not have the capability to perform continuous integrations and continuous deployments out of the box. However, it is possible to use CI tools (ex. Jenkins) to run & monitor.
by vazquezrosariop
Wed Feb 07, 2018 6:14 pm
Forum: CloverETL Support
Topic: Unable to load data in to Database table
Replies: 1
Views: 344

Re: Unable to load data in to Database table

Hi girish_526 After closer inspection of the graph that you sent me, it appears that the metadata datatypes that was being used from the CSV file were inconsistent from the database tables you are inserting to. For example, you are using RAW datatype on one of your columns in this case the metadata ...