Search found 151 matches

by vazquezrosariop
Fri Sep 14, 2018 3:19 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: CloverETL Data Validation
Replies: 1
Views: 945

Re: CloverETL Data Validation

Hi jaipal, I would highly recommend the following validation tools we offer. Data Reader policy —All our data readers work with selectable data policy which affects how errors in the input data are treated. Different policies allow different reactions to data errors from strict reject over to contro...
by vazquezrosariop
Tue Aug 21, 2018 1:51 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: SFTP Connection Failing
Replies: 2
Views: 1060

Re: SFTP Connection Failing

Hi dfkid, There might be another caused to why CloverETL is refusing to connect with the sFTP, but first I would need a execution with better login. Please follow the instructions below: - Download the file (graph) attached - Copy the graph into your CloverETL Server sandbox. - Run it. The graph ena...
by vazquezrosariop
Thu Aug 16, 2018 1:32 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Executing against multiple databases (outside Clover Server if possible)
Replies: 4
Views: 1769

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

Hi Vinny, That is exactly how I would recommend setting up such a use case. I would create Parameters (ex. Username, Password, Host) in the main graph that contains the DBInputTable and map them using the ExecuteGraph Component. You will also need to use Dynamic Metadata to account for the changes i...
by vazquezrosariop
Tue Aug 14, 2018 2:51 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Executing against multiple databases (outside Clover Server if possible)
Replies: 4
Views: 1769

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: CloverDX (formerly CloverETL) Support
Topic: Flat file size allowed in CloverETL
Replies: 1
Views: 770

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: CloverDX (formerly CloverETL) Support
Topic: How do we pass the password type as "Password Text"
Replies: 7
Views: 2598

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: CloverDX (formerly CloverETL) Support
Topic: MongodbWriter create ObjectId
Replies: 1
Views: 1186

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: CloverDX (formerly CloverETL) Support
Topic: How do we pass the password type as "Password Text"
Replies: 7
Views: 2598

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 207 times
by vazquezrosariop
Mon Apr 02, 2018 1:46 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Read Specified file .zip file - no error raised if file does not exist in zip?
Replies: 3
Views: 2386

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: CloverDX (formerly CloverETL) Support
Topic: How do we pass the password type as "Password Text"
Replies: 7
Views: 2598

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 152 times
by vazquezrosariop
Wed Mar 28, 2018 5:25 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Unable to Extract the fields from the XML String
Replies: 7
Views: 2024

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: CloverDX (formerly CloverETL) Support
Topic: How do we pass the password type as "Password Text"
Replies: 7
Views: 2598

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: CloverDX (formerly CloverETL) Support
Topic: Getting RUN_ID
Replies: 2
Views: 1200

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: CloverDX (formerly CloverETL) Support
Topic: Unable to Extract the fields from the XML String
Replies: 7
Views: 2024

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: CloverDX (formerly CloverETL) Support
Topic: Unable to Extract the fields from the XML String
Replies: 7
Views: 2024

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