Generic graph to replicate data

shanepresley

• August 14, 2008 00:00

• Answered

Follow

How easy would it be to create a generic graph that received a set of source/target parameters and based on those parameters, executed specific SQL files using specific record layout and transformation files?

I have done this in another ETL tool but it's quite a costly proposition. Has anyone done this in Clover? What are some of the constraints? Source is Oracle, target is Teradata.

Thanks,
Shane

• 

  dpavlis

  • August 22, 2008 09:22

  0

  Comment actions Permalink

  You would need to create/provide the metadata for the input/output (both probably the same).
  One option is to use the dbAnalyze utility which comes with Clover engine.
  
  Clover also supports dynamic metadata based on SQL query, but this is not supported by the GUI. You would need to create template transformation and use parameter for the SQL query based on which the metadata would be generated at runtime.
• 

  avackova

  • August 22, 2008 09:37

  0

  Comment actions Permalink

  Hi,
  there is example in Examples (graphDBUnloadUniversal.grf), which illustrates usage of dynamic metadata. You can install this example to eclipse by New -> CloverETL -> Clover.ETL Examples Project.

Please sign in to leave a comment.