Search found 131 matches

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: 243

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: 91

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: 243

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 9 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: 497

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: 243

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 10 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: 217

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: 243

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: 87

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: 217

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: 217

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: 217

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: 122

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: 219

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 ...
by vazquezrosariop
Fri Jan 26, 2018 4:05 pm
Forum: CloverETL Support
Topic: UniversalDataWriter and data encryption for AWS s3 services
Replies: 2
Views: 268

Re: UniversalDataWriter and data encryption for AWS s3 services

Hi ramiro, At the moment there is only one way to enable SSE (server-side encryption) and when activated will encrypt all newly created files to S3. Since CloverETL uses JetS3t library to communicate with Amazon S3, you can use the attached jar files to encrypt freshly created files. If you use Clov...
by vazquezrosariop
Tue Jan 23, 2018 6:16 pm
Forum: CloverETL Support
Topic: Working With Multiple Files
Replies: 3
Views: 327

Re: Working With Multiple Files

I created an example of how you can achieve your use case. I used a combination of Jobflows and Graphs to generate the metadata, and the database tables dynamically based on the data in each file and then inserted the data based on the table name.

cron