Can I make Clover.ETL as a java task and run automatically?

CloverDX Platform
1

Hi, my friends,

Under help of Clover.GUI and Clover.ETL,I can extract data from one table to another one in an easy way. But now I must do this manually, can I trig it as a task in my java program? Or any other ways to do this?

Thanks in advance.

Alex

2

Hi,
Clover engine is an embeddable Java library, so you can call it from your Java code. Please download the source code of Clover engine and look in the runGraph class (note the lowercase r in the classname).

Jaro

3

There is also the option to just call the runGraph script (par of bin/ subdir of CloverEngine) which can be called from any shell script or scheduler (cron, etc).

Other option is to purchase CloverServer which has its own scheduler for executing graphs periodically or at pre-set time. :wink:

4

Thanks for your help,my friends.
I now can trig Clover.ETL task from java using Quartz.
For a further step, can I start runGraph in Groovy? and how can I do that?
Where can I get an example?

Alex

5

Hi,
I believe that Groovy can call Java API’s directly, so you should be able to use Clover from Groovy the same way as from Java. We did not try Groovy yet, so I can’t give you an example.

Jaro