Search found 134 matches

by cholastal
Mon May 23, 2016 3:34 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Apache Kafka reader component.
Replies: 7
Views: 5376

Re: Apache Kafka reader component.

Hi, Unfortunately, there are no official read/write components for Apache Kafka and the current readers cannot read the Kafka topics either. However, it is possible to write your own custom component based on the CustomJavaComponent . Documentation of the Apache Kafka API can be found here . Alterna...
by cholastal
Fri May 06, 2016 8:30 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Open Excel File in Data-In folder to edit in clover ETL server project
Replies: 3
Views: 7665

Re: Open Excel File in Data-In folder to edit in clover ETL server project

Hi, Thank you for reporting this issue. There is already a ticket in our tracking system and the issue will be fixed in version 4.2.0. For the time being you can open the file in external editor by right-clicking on the file you want to open -> Open With -> Other ... -> External programs -> OpenDocu...
by cholastal
Wed Apr 20, 2016 11:48 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Http Connector throwing an error, peer not authenticated.
Replies: 3
Views: 2567

Re: Http Connector throwing an error, peer not authenticated.

Hi Raj, It seems that the server you are trying to send the request to, requires some form of authentication. I'm unable to help you better because of the insufficient information you have provided. I would like you to provide me with the following, so I can effectively help you. 1. Your graph file ...
by cholastal
Mon Apr 11, 2016 1:14 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Disable CloverETL Server Simple HTTP API endpoint.
Replies: 1
Views: 1957

Re: Disable CloverETL Server Simple HTTP API endpoint.

Hi, Unfortunately, this is currently not possible. However, maybe you can utilize the following workaround. You can create new user-group and forbid the execution permission for it. This way every user assigned to this group cannot execute graphs (in a specified sandbox) via the HTTP API as well as ...
by cholastal
Thu Mar 31, 2016 3:18 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Custom Propagation??
Replies: 2
Views: 2555

Re: Custom Propagation??

Hi Darren, CustomJavaComponent currently cannot auto-propagate metadata, neither you can set its output metadata dynamically (by code). There is already a new feature proposal in our system, so it might be available in some future version. However, you may find useful the option to select metadata f...
by cholastal
Thu Mar 31, 2016 10:50 am
Forum: CloverDX (formerly CloverETL) Support
Topic: Simple lookup in subgraph input mapping not working
Replies: 1
Views: 1993

Re: Simple lookup in subgraph input mapping not working

Hi, In order to resolve your issue please provide me with the following. 1. Your graph with its externalized dependencies (metadata, etc.). Please feel free to remove any sensitive information. 2. Version of your CloverETL Designer. 3. Whole run log containing the error. I need to see the whole stac...
by cholastal
Wed Mar 30, 2016 2:40 pm
Forum: CloverDX for Java Programmers
Topic: Using arithmetic ( addition) in a graph
Replies: 1
Views: 2595

Re: Using arithmetic ( addition) in a graph

Hi, The structure of the file prevents direct addition of the SrcAmount values. Each column contains too much information. You need to separate the Src from the SrcAmount. This can be done in a Reformat component using string functions like replace() and split(). I attached an example graph, where y...
by cholastal
Wed Mar 30, 2016 12:09 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: Unknown component
Replies: 3
Views: 2609

Re: Unknown component

Hi, You can have multiple versions (instances) of Java running simultaneously on a single machine. So if you install Java 1.7 ( or 1.8 ), you will be able to upgrade to version 4.x.x. However, these versions are using scripting language CTL2, so it is possible that you may need to rewrite your graph...
by cholastal
Tue Mar 29, 2016 12:18 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: How to use Json Extractor when records don't have all the same attributes
Replies: 3
Views: 2973

Re: How to use Json Extractor when records don't have all the same attributes

Hi, I'm afraid that I don't fully understand what you want to achieve. I understand that the JSON files may have different structure. If the files contain some arrays that may have different number of fields, the solution will be quite easy. You just need to set the corresponding metadata container ...
by cholastal
Wed Mar 23, 2016 5:43 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: How to copy all tables from one Oracle database to another without specifying metadata for each individual table
Replies: 1
Views: 2615

Re: How to copy all tables from one Oracle database to another without specifying metadata for each individual table

Hi, Probably the most appropriate way is to use the Oracle Data Pump utility. It is able to export/import all Oracle datatypes (metadata) and the content of the tables itself. You can use the SystemExecute (or ExecuteScript) component to execute the Data Pump directly from CloverETL graph (or jobflo...
by cholastal
Mon Mar 21, 2016 5:55 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: ExecuteScript evaluating expressions in Bash script.
Replies: 1
Views: 2187

Re: ExecuteScript evaluating expressions in Bash script.

Hi, I'm not able to reproduce such behavior. The component doesn't execute the script itself, instead, it executes the interpreter (bash in your case) and passes the script to it. So the script should behave the very same way as if executed directly in the shell. In order to resolve your issue provi...
by cholastal
Mon Mar 14, 2016 4:09 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: CloverETL EmailSender component incompatible with AWS Simple Email Service (SES).
Replies: 7
Views: 5429

Re: CloverETL EmailSender component incompatible with AWS Simple Email Service (SES).

Hi, According to our developers, there is no SMTP connection validation on the start of a job. However, the issue you are describing may be caused by the fact, that the connection for EmailSender is created at the beginning of the phase in which is this EmailSender located. So if the whole job has o...
by cholastal
Tue Mar 08, 2016 3:51 pm
Forum: CloverDX Server
Topic: Groovy On Event Listener
Replies: 1
Views: 2554

Re: Groovy On Event Listener

Hi

Basically, you can obtain Run ID via the RunRecord object on which you can call getID() method. You can find an intuitive example in our documentation (Execute Groovy Code part). There are also other variables/objects described there.

Best regards
by cholastal
Wed Mar 02, 2016 3:06 pm
Forum: CloverDX for Java Programmers
Topic: Plugin for Custom CTL
Replies: 3
Views: 4259

Re: Plugin for Custom CTL

Hi I'm afraid I'm not able to help you without the information I asked for in the previous post and the additional, following ones. 1. Which exact 'plugin' directory do you mean? (relates to the question 4 in the previous post) 2. Are you able to successfully run the plugin? 3. Am I right that the o...
by cholastal
Wed Mar 02, 2016 2:14 pm
Forum: CloverDX (formerly CloverETL) Support
Topic: [DBOutputTable] Problem with date format (ORA-01847)
Replies: 2
Views: 3304

Re: [DBOutputTable] Problem with date format (ORA-01847)

Hi I'm not able to reproduce the issue. When the Designer is provided with an invalid date, it would be able to catch such date before it gets into the database. Some NLS parameters can be configured in the metadata editor (advanced properties). However, if you change the NLS in CloverETL, it won't ...