Search found 111 matches

by cholastal
Tue Jun 19, 2018 1:57 pm
Forum: CloverETL Support
Topic: How add new records to a dataset
Replies: 1
Views: 81

Re: How add new records to a dataset

Hi, This kind of task can be done fairly easily using a component called Simple Gather . You can connect both data sources to its input ports and it will append the data from one source to the other creating a single dataset. Attached is an example graph with some example data. If this is not what y...
by cholastal
Tue May 22, 2018 12:29 pm
Forum: CloverETL Support
Topic: Best practices for health checks against Clover Server / Execution History filters question
Replies: 4
Views: 194

Re: Best practices for health checks against Clover Server / Execution History filters question

Hi, You can check whether the CloverETL Server is up on the following URL: http://<host>:<port>/clover/accessibilityTest .jsp. This page does not require any form of authentication and can return 3 states: OK/200, 500 or 503. It is not a documented page as it is usually used only for our internal te...
by cholastal
Mon Apr 09, 2018 8:46 am
Forum: CloverETL Support
Topic: How to deduplicate information?
Replies: 1
Views: 150

Re: How to deduplicate information?

Hi Nicolás, There is a component called Dedup in CloverETL software which is able to remove duplicates from the input data based on a key - specific column/field within the input data. If this is not what you are looking for, please provide me with more detailed example with some sample input data. ...
by cholastal
Mon Jan 08, 2018 4:46 pm
Forum: Cookbook
Topic: Substring of Email Address
Replies: 7
Views: 779

Re: Substring of Email Address

Hi hesske,

You can accomplish this multiple ways. The most convenient seems to be to use split function. Please take this an example.

Code: Select all

string[] out = split($in.0.address, "@");


Attached is an example graph.

Best regards,
by cholastal
Mon Sep 04, 2017 9:13 am
Forum: CloverETL Support
Topic: Running Clover Graph with Java7 has become really slow
Replies: 3
Views: 962

Re: Running Clover Graph with Java7 has become really slow

Hi François, Unfortunately, this is very old version of CloverETL software which is no longer supported. Version 2.5.x wasn't tested with Java 7 as it wasn't released at that time, therefore, we cannot guarantee full compatibility. I would suggest to upgrade to one of the recent versions of CloverET...
by cholastal
Fri Aug 18, 2017 9:27 am
Forum: CloverETL Support
Topic: Replace a string containing a DOT to New Line.
Replies: 1
Views: 611

Re: Replace a string containing a DOT to New Line.

Hi,

Here is a simple usage example of the function:

Code: Select all

$out.0.field1 = replace($in.0.field1, "\\.", "\n");


Hope this helps,
by cholastal
Tue Aug 15, 2017 1:38 pm
Forum: CloverETL Support
Topic: Running Clover Graph with Java7 has become really slow
Replies: 3
Views: 962

Re: Running Clover Graph with Java7 has become really slow

Hi François, That is quite strange behavior, however, I would like to kindly ask you to provide me with a bit more detailed information, so that I can better understand your setup, please. 1. What version of CloverETL software are you using? 2. Do you use CloverETL Server to run your graphs? 3. Do y...
by cholastal
Thu Jul 20, 2017 7:40 am
Forum: CloverETL Support
Topic: How to enable TLS 1.2 in Clover ETL Community version 3.5
Replies: 1
Views: 697

Re: How to enable TLS 1.2 in Clover ETL Community version 3.5

Hi Jagan, As the CloverETL Designer is basically an Eclipse plugin, the TLS should be enabled in a similar manner. Please try to add the following VM argument to the run configuration of your graph(s). -Dhttps.protocols=TLSv1,TLSv1.1,TLSv1.2 You can add the VM argument via the Designer's top menu ->...
by cholastal
Mon Jun 26, 2017 3:03 pm
Forum: CloverETL Support
Topic: AWS Instance Type Recommendations
Replies: 1
Views: 705

Re: AWS Instance Type Recommendations

Hi, Currently, we have no official recommendations for EC2 instances. Regarding the instance type, I would recommend either the General Purpose or the Compute Optimized. But this is just based on their description . The minimal requirements are the same as for a regular physical machine and you can ...
by cholastal
Thu Jun 22, 2017 3:16 pm
Forum: CloverETL Support
Topic: How does the System Execute Command work related to connections?
Replies: 3
Views: 1066

Re: How does the System Execute Command work related to connections?

Hi pintail, I've got two ideas on how to avoid this behavior. 1. Set the timeout property on the SystemExecute component. The command is executed as a separate process and if it keeps waiting for a response for example, this should kill the process after the selected time. 2. Try using Execute Scrip...
by cholastal
Mon Jun 05, 2017 2:45 pm
Forum: CloverETL Server
Topic: Tomcat user running CloverETL
Replies: 1
Views: 772

Re: Tomcat user running CloverETL

Hi hewills, Unfortunately, there is no universally recommendable user configuration. I assume you mean that the tomcat user doesn't have access to the Linux shell. In this case the options really are to run the scripts under another user who can do it (as you do now) or to allow the tomcat user to l...
by cholastal
Tue May 23, 2017 12:46 pm
Forum: CloverETL Support
Topic: How does the System Execute Command work related to connections?
Replies: 3
Views: 1066

Re: How does the System Execute Command work related to connections?

Hi pintail, I've seen that you have started two very similar threads. Therefore, I will use only this one to, hopefully help you with this issue. The script is indeed saved into a file in a temp folder. The exact path can be seen in run log of the graph when you switch the logging level to DEBUG. Th...
by cholastal
Fri Apr 21, 2017 3:35 pm
Forum: CloverETL Support
Topic: WebServiceClient SOAP response multipart
Replies: 2
Views: 792

Re: WebServiceClient SOAP response multipart

Hi Axe, Unfortunately, neither WebServiceClient or HTTPClient has the ability to parse multipart responses. Your current solution with HTTPConnector and Reformat is the most convenient. However, you're right, sometimes it really may be useful to have such feature implemented. Therefore I've created ...
by cholastal
Tue Feb 28, 2017 2:27 pm
Forum: CloverETL Support
Topic: A Palette is not available
Replies: 3
Views: 988

Re: A Palette is not available

Hi daves,

This issue seems to be related to the IBM Integrator and not to the CloverETL Designer, therefore, please contact IBM directly again.

Thank you for your understanding.

Best regards,
by cholastal
Mon Feb 13, 2017 4:22 pm
Forum: CloverETL Support
Topic: How to set a parameter on subgraph?
Replies: 4
Views: 1495

Re: How to set a parameter on subgraph?

Hi, You cannot pass a parameter value to a subgraph from an input port exactly due to the fact that there might be more than one records flowing through that edge. Subgraphs are designed for a different purpose than run as many times as how many records are on the input. It will be started only once...

cron