CloverETL is now CloverDX - Learn Why

Search found 116 matches

by cholastal
Wed Nov 28, 2018 10:18 am
Forum: CloverDX Server
Topic: Embeded Derby Database failures after run-away graph overloaded execution history
Replies: 3
Views: 124

Re: Embeded Derby Database failures after run-away graph overloaded execution history

Hi, It is rather unusual location but it is possible. I'm sorry for my mistake, the location of the database is not bound to the java.io.tmpdir variable but it is located in working directory by default and can be changed by a property. More information can be found in our documentation . I would su...
by cholastal
Mon Nov 26, 2018 2:14 pm
Forum: CloverDX Server
Topic: Embeded Derby Database failures after run-away graph overloaded execution history
Replies: 3
Views: 124

Re: Embeded Derby Database failures after run-away graph overloaded execution history

Hi, First I would like to clarify that the embedded Derby database is not a fully fledged database and should serve for basic testing purposes only, never for any kind of production. Even for advanced testing and/or development environments we recommend using a 3rd party, fully fledged SQL database....
by cholastal
Wed Oct 10, 2018 11:34 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Apache Kafka reader component.
Replies: 7
Views: 3446

Re: Apache Kafka reader component.

Hi Lukasz,

This was caused by our recent rebranding activities. It is available for download now. I'm sorry for the inconvenience.

If you want to know more about the rebranding, please visit: https://www.cloverdx.com/cloveretl

Best regards,
by cholastal
Tue Sep 18, 2018 3:33 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: problem with merge
Replies: 1
Views: 182

Re: problem with merge

Hi, Unfortunately, I don't have enough information to pinpoint the exact root cause of this issue. I will need more information in order to find out. Although, memory issues usually manifest themselves by an error or an exception, it's definitely worth taking a look at it. Depending on whether you'r...
by cholastal
Fri Sep 07, 2018 1:28 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: how to externalize a db connection with environmental variables?
Replies: 2
Views: 758

Re: how to externalize a db connection with environmental variables?

Hi Ramiro, It is possible to use environment variables even in externalized connections. However, under certain circumstances, these variables may not be visible to CloverETL, mainly on Linux where these variables may exist in isolated shells. So, the most reliable way to tell whether the CloverETL ...
by cholastal
Tue Jun 19, 2018 1:57 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: How add new records to a dataset
Replies: 1
Views: 451

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: CloverDX (formerly CloverETL) Support
Topic: Best practices for health checks against Clover Server / Execution History filters question
Replies: 4
Views: 786

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: CloverDX (formerly CloverETL) Support
Topic: How to deduplicate information?
Replies: 1
Views: 462

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

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: CloverDX (formerly CloverETL) Support
Topic: Running Clover Graph with Java7 has become really slow
Replies: 3
Views: 1626

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: CloverDX (formerly CloverETL) Support
Topic: Replace a string containing a DOT to New Line.
Replies: 1
Views: 1077

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: CloverDX (formerly CloverETL) Support
Topic: Running Clover Graph with Java7 has become really slow
Replies: 3
Views: 1626

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: CloverDX (formerly CloverETL) Support
Topic: How to enable TLS 1.2 in Clover ETL Community version 3.5
Replies: 1
Views: 1237

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: CloverDX (formerly CloverETL) Support
Topic: AWS Instance Type Recommendations
Replies: 1
Views: 1151

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: CloverDX (formerly CloverETL) Support
Topic: How does the System Execute Command work related to connections?
Replies: 3
Views: 1638

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...