Search found 151 matches

by vazquezrosariop
Mon Mar 26, 2018 7:22 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Unable to Extract the fields from the XML String
Replies: 7
Views: 2699

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

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: CloverDX (formerly CloverETL) Support
Topic: Unable to load data in to Database table
Replies: 1
Views: 1528

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: CloverDX (formerly CloverETL) Support
Topic: UniversalDataWriter and data encryption for AWS s3 services
Replies: 2
Views: 2149

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: CloverDX (formerly CloverETL) Support
Topic: Working With Multiple Files
Replies: 3
Views: 3160

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.
by vazquezrosariop
Wed Jan 17, 2018 4:26 pm
Forum: CloverDX Server
Topic: Can I get multiple returned files from Launch Services?
Replies: 7
Views: 5868

Re: Can I get multiple returned files from Launch Services?

Hi Paul, You will need to read the zip folder using FlatFileReader and write the values to the writable.channel using FlatFileWriter. Since the zip folder contains multiple files with different metadata, the simplest solution is to use metadata consisting of a single field of a byte type with the fi...
by vazquezrosariop
Wed Jan 17, 2018 2:51 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Error while executing the graph on the Server
Replies: 4
Views: 2853

Re: Error while executing the graph on the Server

Hi Girish,

Sorry for the delay, could you please share your graph. I would like to see how it's configured, based on the information of the all.log it's difficult to pinpoint which component is the cause.

Thanks,
by vazquezrosariop
Thu Dec 21, 2017 5:24 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Error while executing the graph on the Server
Replies: 4
Views: 2853

Re: Error while executing the graph on the Server

Hi girish_526 Based on the stack trace it's a bit difficult to pinpoint whats causing the issue, thus could you please answer the following questions: 1. CloverETL version, Application Server vendor, version, Java version 2. Component original name, e.g. FlatFileWriter 3. all.log file located in [TO...
by vazquezrosariop
Mon Dec 18, 2017 5:48 pm
Forum: CloverDX Server
Topic: Can I get multiple returned files from Launch Services?
Replies: 7
Views: 5868

Re: Can I get multiple returned files from Launch Services?

Hi Paul,

Launch Services are based on HTTP calls, which does not support more than one file downloaded at once.

A solution to this would be zipping the files and sending that through the Launch Service.

Regards,
by vazquezrosariop
Fri Dec 15, 2017 6:14 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: CTL function example
Replies: 2
Views: 2161

Re: CTL function example

Hi hewills, Creating a .ctl file and importing into transforms/reformats is still possible in newer versions of CloverETL Designer. That being said I have created a simple .ctl function that takes parameters and returns a value: //#CTL2 function string handle_null(string data) { return data==null ? ...
by vazquezrosariop
Thu Dec 07, 2017 6:17 pm
Forum: IBM InfoSphere MDM
Topic: Write SUCCESS flag to Database After Successful DB Output
Replies: 4
Views: 4004

Re: Write SUCCESS flag to Database After Successful DB Output

Hi listsos, The output port you are utilizing to set the flag is only returns rejected records, which works well for the Failure Flag. Now to set the Success flag, I would recommend using the second output port and set a returning statement to output a record inserted. It's also imported to note tha...
by vazquezrosariop
Thu Dec 07, 2017 4:49 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Using dictionary variable in the query
Replies: 5
Views: 5165

Re: Using dictionary variable in the query

Hi Paul, This is still true in the current version of CloverETL, unfortunately, dictionaries are not supported in DBInputTable. On a side note, if you are using CloverETL 4.7 we introduced an improved version of Launch Services called Data Services. If you would like to know more I have added a few ...
by vazquezrosariop
Mon Dec 04, 2017 7:53 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Removing random "|" characters from DBInputTable
Replies: 2
Views: 2055

Re: Removing random "|" characters from DBInputTable

Hi Jesse,

I replied to a similar question on how to replace on all fields without having to go one by one. I used the reformat and a code I created to accomplish this:

http://forum.cloveretl.com/viewtopic.php?f=4&t=7306&hilit=replace#p12426
by vazquezrosariop
Fri Dec 01, 2017 2:27 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: UniversalDataReader SFTP issue
Replies: 8
Views: 4623

Re: UniversalDataReader SFTP issue

I'm attaching a graph with CustomJavaComponent, which will print out the supported key exchange schemes of the SFTP. When the graph runs, it will enable verbose SFTP logging at DEBUG log level on the Server, until restarted. Afterwards, you should execute your graph that reads from SFTP with DEBUG l...
by vazquezrosariop
Thu Nov 16, 2017 9:02 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: UniversalDataReader SFTP issue
Replies: 8
Views: 4623

Re: UniversalDataReader SFTP issue

Hi gch,

I spoke with our developers and they strongly feel they can find a solution to this problem, but they need more details first. Could you please answer the following questions:

  • Java version
  • CloverETL version