CloverETL is now CloverDX - Learn Why

Search found 87 matches

by bartonv
Fri Oct 19, 2018 2:30 pm
Forum: CloverDX Server
Topic: create schedules dynamically
Replies: 1
Views: 14

Re: create schedules dynamically

Hi Ramiro, CloverDX Server is currently not designed in a way that would allow for creating new schedules via an API very elegantly. In theory, you would be able to do that by taking advantage of our Simple HTTP API , namely the 'import_server_config' operation: ⋅ At first, you would want ...
by bartonv
Fri Oct 19, 2018 8:53 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Connection Reset Error in HTTPConnector Help!!
Replies: 2
Views: 24

Re: Connection Reset Error in HTTPConnector Help!!

Hello Ricardo, it seems that the API site you intend to connect to has stopped supporting TLS protocols older than version 1.2. Unfortunately, due to the obsolescence of Java which you are using on your server (1.7.0_80) which does not support TLS 1.2 by default, the SSL handshake could not be estab...
by bartonv
Tue Oct 09, 2018 8:16 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Parsing dates
Replies: 7
Views: 137

Re: Parsing dates

Hi Hesske,
thank you for the heads up! I am glad a working solution was found.
by bartonv
Mon Oct 08, 2018 1:20 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Parsing dates
Replies: 7
Views: 137

Re: Parsing dates

Hello Hesske, unfortunately, I am unable to download the attached image. Nevertheless, I believe there is a more straightforward option of how to achieve the desired result. If I understood your request correctly, what you are trying to obtain would be the following: Let's say this is the initial se...
by bartonv
Mon Oct 08, 2018 7:45 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Error after upgrading to DX
Replies: 1
Views: 27

Re: Error after upgrading to DX

Hello Michael, thank you for the detailed description of the issue you are facing. Let me explain the reason for the reported behavior in a wider context and then suggest a solution to it. As of October 2018, CloverETL is newly called CloverDX so all our products released after this change carry the...
by bartonv
Wed Oct 03, 2018 11:28 am
Forum: Dev News: Latest Releases
Topic: CloverDX launched
Replies: 1
Views: 143

Re: CloverDX launched

Hello J.V., as you rightly indicated, CloverDX is our new brand name that replaces "CloverETL" as of October 2018. However, neither there is any impact on you directly, nor any action is needed from your side (which applies to licensing as well). I would suggest reviewing our knowledgebase...
by bartonv
Thu Sep 27, 2018 2:49 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Parsing dates
Replies: 7
Views: 137

Re: Parsing dates

Hi Hesske, attached is an example of how this task can be approached. Worth noting is the following: ⋅ I am generating a random set of dates where 'date2' is always after 'date1' (to simplify the example) ⋅ each pair of dates is assigned with an id (sequenced) ⋅ in the ...
by bartonv
Wed Sep 05, 2018 6:52 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Installing CloverETL Integrator on Windows
Replies: 2
Views: 3876

Re: Installing CloverETL Integrator on Windows

Hello Harrisnunna,
as this issue relates to Endeca Data Integrator please do contact Oracle Endeca support in this matter directly. They need to be informed about this issue and will work with us directly if needed. Thank you for your cooperation!
Best regards,
by bartonv
Thu Aug 02, 2018 1:42 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: write to a particular row in output
Replies: 1
Views: 254

Re: write to a particular row in output

Hello Nagaraj K P, if I understand it correctly what you are trying to achieve is basically to update a record that has already been output by the Reformat component if a certain condition is met. However, I am afraid that from the description of your use case, I am unable to address your question o...
by bartonv
Thu Jul 26, 2018 3:37 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Open tab button does nothing
Replies: 1
Views: 258

Re: Open tab button does nothing

Hello Ogalimov, this feature has been present in the older versions of CloverETL and I can confirm that it is available in the most recent 4.9.0 production version as well. As per our documentation, the way this feature is supposed to work is that if you click on the ‘Open tab’ button a new tab with...
by bartonv
Fri Jul 20, 2018 2:40 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Time Zone always ignored
Replies: 3
Views: 420

Re: Time Zone always ignored

Hi Dflkid, additionally, let me back up a little bit here. I would be curious as to where exactly you can see the improper time zone. Is it in the Data Inspector in CloverETL Designer or in an output of the graph? What I covered in my previous update concerns just the transformation string format an...
by bartonv
Mon Jul 16, 2018 12:21 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Time Zone always ignored
Replies: 3
Views: 420

Re: Time Zone always ignored

Hi Dflkid, it appears that your date2str() function definition is missing the locale parameter which makes the timeZone parameter ignored. According to our documentation , the date2str() function accept these 3 definition formats: ⋅ string date2str(date input, string pattern); ⋅ ...
by bartonv
Mon Jul 16, 2018 11:48 am
Forum: CloverDX Server
Topic: Tool to “Data Load” or “ETL” — from SQL Server into Amazon Redshift
Replies: 1
Views: 3636

Re: Tool to “Data Load” or “ETL” — from SQL Server into Amazon Redshift

Hello Sailaja, designing a process flow like this in our CloverETL Designer (which is a visual tool for designing data transformations) is quite straight-forward and is only a matter of adding and linking 2 components and configuring the connections to both AWS and SQL Server. Furthermore, our Clove...
by bartonv
Fri Jul 13, 2018 1:40 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Having trouble with Streaming vs. In Memory
Replies: 1
Views: 362

Re: Having trouble with Streaming vs. In Memory

Hi Mike, there is an essential difference in the SpreadsheerDataReader read modes in the way how data is stored in the memory. The In-memory mode stores the whole input file in the memory which allows for faster reading and makes it a good candidate for smaller files. In the Streaming mode, the file...
by bartonv
Fri Jul 13, 2018 10:06 am
Forum: CloverDX (formerly CloverETL) Support
Topic: function for returning day of week in CTL
Replies: 1
Views: 302

Re: function for returning day of week in CTL

Hello Pinwizard, extracting the day of the week can be achieved by using the appropriate date format, typically: ⋅ “EEE” – this will return a 3 letter weekday name (‘Mon’, ‘Tue’, etc.) ⋅ “EEEE” – this will return the full weekday name (‘Monday’, ‘Tuesday’, etc.) So basically, the...

cron