Search found 80 matches

by bartonv
Wed Sep 05, 2018 6:52 am
Forum: CloverETL Support
Topic: Installing CloverETL Integrator on Windows
Replies: 2
Views: 3818

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: CloverETL Support
Topic: write to a particular row in output
Replies: 1
Views: 198

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: CloverETL Support
Topic: Open tab button does nothing
Replies: 1
Views: 210

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: CloverETL Support
Topic: Time Zone always ignored
Replies: 3
Views: 350

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: CloverETL Support
Topic: Time Zone always ignored
Replies: 3
Views: 350

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: CloverETL Server
Topic: Tool to “Data Load” or “ETL” — from SQL Server into Amazon Redshift
Replies: 1
Views: 3456

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: CloverETL Support
Topic: Having trouble with Streaming vs. In Memory
Replies: 1
Views: 289

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: CloverETL Support
Topic: function for returning day of week in CTL
Replies: 1
Views: 249

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...
by bartonv
Thu Jul 12, 2018 3:34 pm
Forum: CloverETL Server
Topic: How to Duplicate SandBox
Replies: 1
Views: 240

Re: How to Duplicate SandBox

Hello EBS-discovery, creating a new sandbox and uploading a zip file of the sandbox you need to copy is certainly one of the options. Below are 2 other examples of how the sandbox duplication can be accomplished. Worth noting though is that none of the available options is as easy as clicking a sing...
by bartonv
Mon Jul 02, 2018 3:21 pm
Forum: CloverETL Support
Topic: way to extract metadata from clover files?
Replies: 1
Views: 252

Re: way to extract metadata from clover files?

Hello Pintail, if by ‘a clover file’ you mean our internal binary Clover data format file then the metadata will be contained within the file itself. You can check that by reviewing the content of the file in a text editor (the metadata will be visible in a plain text while the rest of the data is b...
by bartonv
Mon Jul 02, 2018 2:34 pm
Forum: CloverETL Support
Topic: Where do I find the XSD for executions_history? I am using 4.1.0.018
Replies: 1
Views: 245

Re: Where do I find the XSD for executions_history? I am using 4.1.0.018

Hi Paul, as you rightly said, the mentioned URL points to a different location which is, in fact, the following (as per the executions.xsd content): http://[host]:[port]/clover/schemas/cs.xsd However, even using the following URL mentioned by the documentation should work properly in CloverETL: http...
by bartonv
Wed Jun 20, 2018 9:43 am
Forum: CloverETL Support
Topic: Error executing Job Flow
Replies: 1
Views: 254

Re: Error executing Job Flow

Hello Kullboys, the error message indicates that you attempted to execute a jobflow from a local project in CloverETL Designer while jobflow execution, in fact, requires CloverETL Server environment (in other words, it needs to be launched from a server project). CloverETL Server is a server applica...
by bartonv
Wed Jun 20, 2018 8:14 am
Forum: CloverETL for Java Programmers
Topic: JsonExtract could not read elements having SPACE
Replies: 3
Views: 3705

Re: JsonExtract could not read elements having SPACE

Hello Madan_clover3, yes, replacing the space symbol with an underscore in the mapping is enough for your graph to work properly. In other words, no changes need to take place in the input file. As you rightly said, the space symbol is indeed a valid character in JSON. However, due to the way how Cl...
by bartonv
Tue Jun 19, 2018 3:13 pm
Forum: CloverETL Support
Topic: Dynamic Metadata
Replies: 1
Views: 324

Re: Dynamic Metadata

Hello Fyrezx, in theory, you can apply dynamic metadata to an edge inside of a loop in the same way as you normally would in the rest of the graph. To do that, you would have to switch to the ‘Source’ tab in the CloverETL Designer view and add a code that resembles what you mentioned in your post. T...
by bartonv
Tue Jun 12, 2018 7:27 am
Forum: CloverETL for Java Programmers
Topic: JsonExtract could not read elements having SPACE
Replies: 3
Views: 3705

Re: JsonExtract could not read elements having SPACE

Hello Madan_clover3, in order to resolve the issue, please replace “phone numbers” in your mapping with “phone_numbers”. The reason why the underscore needs to replace the space symbol in the mapping is that Clover internally converts JSON into XML and the space symbol is not a valid character in XM...

cron