CloverETL is now CloverDX - Learn Why

Search found 87 matches

by bartonv
Tue Feb 20, 2018 10:36 am
Forum: CloverDX (formerly CloverETL) Support
Topic: How to replace back slash in CTL2
Replies: 1
Views: 674

Re: How to replace back slash in CTL2

Hi Mukunku, try changing your code to the following: replace(myString, "\\\\", "/"); The reason why 4 backslashes are needed to reference one is that there are 2 levels of interpretation: ⋅ At first, CloverETL interprets the “\\\\” string as 2 backslashes (each one esca...
by bartonv
Mon Feb 12, 2018 3:04 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: EmailSender ignore send fail
Replies: 3
Views: 763

Re: EmailSender ignore send fail

Hi Hewills, if the ‘Ignore send fail’ property of the EmailSender component is set to ‘false’ (by default), the whole graph execution will fail in case an email sending fails. If it is set to ‘true’, the graph execution will continue despite a failed email sending. For instance, let’s assume that a ...
by bartonv
Mon Feb 12, 2018 10:18 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Fuzzy Match Join
Replies: 2
Views: 643

Re: Fuzzy Match Join

Hi Mike, as the_goat already mentioned, the Aspell Lookup feature looks like a good candidate for your case (in consideration of the memory consumption as stated above). Let me provide you with an example project where the usage of the Aspell Lookup is demonstrated. ⋅ The idea is to first ...
by bartonv
Fri Jan 26, 2018 3:32 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: https over UniversalFileWriter
Replies: 2
Views: 773

Re: https over UniversalFileWriter

Hello Ramiro, a recommended way of reading data from Amazon S3 in CloverETL is by using the “s3://” prefix in the particular reader component URL. By modifying your submitted URL as an example, it would look like this: gzip:(s3://${S3_ACCESS_KEY}:${S3_SECRET_KEY}@s3.amazonaws.com/${S3_BUCKET}/${S3_F...
by bartonv
Fri Jan 19, 2018 1:46 pm
Forum: IBM InfoSphere MDM
Topic: Error: AggregationException: Invalid mapping
Replies: 6
Views: 5098

Re: Error: AggregationException: Invalid mapping

Hi Listsos, based on the submitted details, this engine behavior can have multiple reasons: ⋅ the obsolete version of CloverETL ⋅ the OEM partner (IBM in this case) is allowed to change many things in CloverETL during bundling some of which might affect the way CloverETL engine w...
by bartonv
Wed Jan 17, 2018 1:41 pm
Forum: IBM InfoSphere MDM
Topic: Error: AggregationException: Invalid mapping
Replies: 6
Views: 5098

Re: Error: AggregationException: Invalid mapping

Hello Listsos, I have tried to replicate the reported issue on my end by using the snippet of your graph source code but I could not manufacture a situation when the same graph would run fine in the GUI but failed when running via command line. Having said that, I would like to ask you for additiona...
by bartonv
Thu Dec 21, 2017 2:28 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: 2 x replace functions in one entry?
Replies: 2
Views: 586

Re: 2 x replace functions in one entry?

Hi all, thank you for the question as well as the answer. Using the ‘switch’ statement is indeed one of the possible options how to deal with such replacement. If you want to stick to the ‘replace’ statement that you demonstrated in your issue description, you could also use the following piece of C...
by bartonv
Mon Dec 18, 2017 10:20 am
Forum: IBM InfoSphere MDM
Topic: Write SUCCESS flag to Database After Successful DB Output
Replies: 4
Views: 1024

Re: Write SUCCESS flag to Database After Successful DB Output

Hello Listsos, the DBOutputTable is capable of returning records that were successfully inserted into a database, as well as returning those that failed. You could take advantage of one of these features to achieve the desired result. Attached is an example solution of how this can be approached. Th...
by bartonv
Thu Nov 30, 2017 4:58 pm
Forum: CloverDX for Java Programmers
Topic: Problem in extracting the XML extract
Replies: 3
Views: 1250

Re: Problem in extracting the XML extract

Hello Girish, from the snippet of your XML, I would suggest using the XMLExtract component to generate the XSD schema and take advantage of its visual mapping feature. Moreover, I would recommend using the ‘Populate parent record’ functionality as the fundamental concept of your data extraction as i...
by bartonv
Thu Nov 30, 2017 3:26 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Stopping a graph midway
Replies: 5
Views: 1864

Re: Stopping a graph midway

Hi Mukunku, the fail component is designed in a way that it can abort the parent jobflow or graph with a user-specified error message and at the same time return some results through the dictionary. Having said that, you could use the Fail component for both purposes. Let me present you with an exam...
by bartonv
Mon Nov 13, 2017 1:03 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Don't Save Run Record When Triggering Graph from Simple HTTP API
Replies: 1
Views: 629

Re: Don't Save Run Record When Triggering Graph from Simple HTTP API

Hi Sal, there are a couple of options that you can take advantage of when trying to achieve a lower amount of log data: ⋅ As you rightly indicated, it can be achieved by adding a log level parameter directly to the URL when calling a ‘graph_run’ operation. By default, the logging level is ...
by bartonv
Mon Nov 13, 2017 1:01 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: UniversalDataReader SFTP issue
Replies: 8
Views: 1831

Re: UniversalDataReader SFTP issue

Hello gch, in order to troubleshoot this issue, I would suggest focusing on the following items first before we dig any deeper: ⋅ Try adding the proper port number to the URL: sftp://[username]:***@[servername]:[port]/home/oraclesftp/StatusLink.csv ⋅ Try checking the URL for any ...
by bartonv
Fri Nov 10, 2017 1:27 pm
Forum: Cookbook
Topic: Send data to an HTML table
Replies: 1
Views: 846

Re: Send data to an HTML table

Hi Paul,
thank you for the useful solution. I trust CloverETL users will appreciate your work.
Kind regards,
by bartonv
Wed Nov 01, 2017 1:47 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Join two FlatFileReader/UniversalDataReader
Replies: 5
Views: 1046

Re: Join two FlatFileReader/UniversalDataReader

Hello Ricardo, thank you for the feedback. Moving your data transformation to a jobflow is certainly a more elegant and straightforward way to go. Having said that, let me provide 2 additional recommendations that might be worth implementing as they are considered to be a best practice with potentia...
by bartonv
Tue Oct 31, 2017 4:20 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Connection Keep-Alive for SQL Temp Table
Replies: 2
Views: 1002

Re: Connection Keep-Alive for SQL Temp Table

Hi Jesse, in CloverETL, there is indeed a way how to achieve what you described in your update. By default, each thread gets its own connection instance, thus avoiding issues when multiple components read/write from/to a DB using the same connection definition. However, this behavior can be changed ...