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

alex_chew

• August 19, 2008 00:00

• Answered

Follow

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

• 

  jurban

  • August 19, 2008 13:03

  0

  Comment actions Permalink

  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
• 

  dpavlis

  • August 19, 2008 20:16

  0

  Comment actions Permalink

  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:
• 

  alex_chew

  • August 20, 2008 13:26

  0

  Comment actions Permalink

  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
• 

  jurban

  • August 20, 2008 13:33

  0

  Comment actions Permalink

  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

Please sign in to leave a comment.