Search found 372 matches

by kubosj
Thu Jun 18, 2015 8:54 am
Forum: CloverETL Support
Topic: CloverETL integration with JBOSS DataGrid
Replies: 4
Views: 920

Re: CloverETL integration with JBOSS DataGrid

Hm, we do not have specialized connector for Hot Rod. What you can do is to create custom Java code in CustomJavaComponent utilizing Java Hot Rod client.
by kubosj
Wed Jun 17, 2015 3:27 pm
Forum: CloverETL Support
Topic: CloverETL integration with JBOSS DataGrid
Replies: 4
Views: 920

Re: CloverETL integration with JBOSS DataGrid

Hi, It seems that JBOSS DataGrid supports REST API - see https://access.redhat.com/documentation/en-US/Red_Hat_JBoss_Data_Grid/6.3/html/Administration_and_Configuration_Guide/sect-Using_the_REST_Interface.html For calling REST API method may be used HTTPConnector . Or do you mean another API? I hope...
by kubosj
Mon May 04, 2015 10:35 am
Forum: CloverETL for Java Programmers
Topic: Running SpreadsheetDataReader from Java program
Replies: 1
Views: 1103

Re: Running SpreadsheetDataReader from Java program

Hi alarned, CloverETL Designer (both trial and commercial) contains 2 kinds of components. Part are open source components and part are commercial components. So you can design graphs containing both types. But if you instantiate open source CloverETL Engine you have access only to open source compo...
by kubosj
Fri Apr 24, 2015 1:17 pm
Forum: CloverETL Support
Topic: Tableau Extract API
Replies: 1
Views: 776

Re: Tableau Extract API

Hi Nate, I guess by documentation you mean TableauWriter , right? In short: ⋅  Install binaries from address http://www.tableau.com/data-extract-api (C/C++/Java - select OS and 32/64 according to your system) ⋅  Unzip files (directories bin, include, lib64, share) to arbitrary di...
by kubosj
Thu Apr 23, 2015 12:09 pm
Forum: Cookbook
Topic: Converting JD Edwards dates to standard dates
Replies: 0
Views: 1255

Converting JD Edwards dates to standard dates

Oracle's JD Edwards ERP system stores dates in a custom variant of a Julian date format as described at https://docs.oracle.com/cd/E26228_01/doc.93/e21961/julian_date_conv.htm#WEAWX259. While Clover does not have a built-in function to convert a JD Edwards date to a standard date , one can easily be...
by kubosj
Mon Apr 13, 2015 12:39 pm
Forum: CloverETL Support
Topic: Incremental data replication job from DB Views to DB Tables
Replies: 2
Views: 1407

Re: Incremental data replication job from DB Views to DB Tables

Hi Sabelm_m, CloverETL seem like great tool for what you want: 1) Incremental replication. If your views contains increasing fields (like ID, timestamp, ...) then you can use Incremental reading . If you combine this with limitation of number of records read from database you can easily control numb...
by kubosj
Wed Apr 08, 2015 10:22 am
Forum: CloverETL Support
Topic: HTTPConnector handling of error status codes
Replies: 3
Views: 770

Re: HTTPConnector handling of error status codes

Hi Joe, Thank you for the email. HTTPConnector does have two output port. The first one is for all type of responses you can basically get - so including 401 etc. Basically anytime the Clover receives a valid response with appropriate code it is sent to the first output port (Output mapping must be ...
by kubosj
Fri Mar 27, 2015 10:04 am
Forum: CloverETL Server
Topic: Command line graph execution on Linux
Replies: 3
Views: 1278

Re: Command line graph execution on Linux

Hi, Unfortunately Server can execute scripts only under Tomcat account. What you can do: ⋅  Use commandline like su - user2 -c "/path/myscript.sh" but that would need password. You can omit password by http://unix.stackexchange.com/questions/113754/allow-user1-to-su-user2-without...
by kubosj
Thu Mar 26, 2015 9:01 am
Forum: CloverETL Server
Topic: Command line graph execution on Linux
Replies: 3
Views: 1278

Re: Command line graph execution on Linux

Hi Andrew, You can utilize Simple HTTP API , namely operation "graph_run". You can invoke such URL using curl, wget, or similar tool from your Cron script. You probably know that, but just for sure - Server contains Cron-like scheduler internally - Scheduling . So I guess you have some spe...
by kubosj
Wed Mar 25, 2015 8:00 am
Forum: CloverETL Support
Topic: Trouble writing XLSX
Replies: 1
Views: 535

Re: Trouble writing XLSX

Hi,

Since CloverETL Designer 4.0 are graphs executed by CloverETL Runtime which starts when Designer starts and graphs are executed on it. You can configure runtime in Runtime Configuration
by kubosj
Mon Mar 23, 2015 11:42 am
Forum: CloverETL Server
Topic: Unable to add parameters for JobFlow via "Launch Services"
Replies: 1
Views: 669

Re: Unable to add parameters for JobFlow via "Launch Services"

Dear Anita, Launch Services are primarily using dictionary for passing parameters. So the message "Launch configuration has no graph dictionary properties." you see means that you should add some dictionary entries defining parameters. Please take a look into directory of your existing gra...
by kubosj
Wed Mar 11, 2015 11:14 am
Forum: CloverETL Support
Topic: RecordOrderedKey.java Bug
Replies: 1
Views: 527

Re: RecordOrderedKey.java Bug

Hi Chris,

Thank you for bug report, developers were able to confirm it. We have created https://bug.javlin.eu/browse/CLO-5867 where you can check its status.

It will be fixed in next fix release but unfortunately release date was not yet decided.
by kubosj
Wed Feb 25, 2015 3:45 pm
Forum: CloverETL Server
Topic: Groovy Task: set status or log more?
Replies: 1
Views: 811

Re: Groovy Task: set status or log more?

Hi henjo, Regarding status: It is not possible to create own status as it is internal filed of Server. Regarding extended status: You may return string from Groovy script and that value is then visible in Task History - but you probably know that. Other possibility is to open file in Groovy and log ...
by kubosj
Wed Feb 25, 2015 3:17 pm
Forum: CloverETL Support
Topic: Move file via FTP
Replies: 1
Views: 698

Re: Move file via FTP

Hi Andrew, Yes, JobFlow component MoveFiles would be easiest solution. You may also try to download file by UniversalDataReader and upload by UniversalDataWriter. Both component supports various protocols, including FTP - see Supported File URL Formats for Readers , resp. Supported File URL Formats ...
by kubosj
Wed Feb 25, 2015 3:05 pm
Forum: CloverETL Support
Topic: SSL Truststore and Keystore
Replies: 1
Views: 691

Re: SSL Truststore and Keystore

Hi Jaz, One source of problem may be that your stores does not contain valid certificate - so they are loaded but no valid certificate is present. Second is related to Designer 4.0 which you probably use. Since 4.0 is Designer using Runtime for graphs execution. Runtime is started with Designer and ...

cron