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
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.
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.