# Generic graph to replicate data

**URL:** <https://forum.cloverdx.com/t/generic-graph-to-replicate-data/372>\
**Category:** CloverDX Platform\
**Created:** [August 14, 2008, 12:00am UTC](https://forum.cloverdx.com/t/generic-graph-to-replicate-data/372 "2008-08-14T00:00:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![shanepresley](https://avatars.discourse-cdn.com/v4/letter/s/b9bd4f/32.png) [@shanepresley](https://forum.cloverdx.com/u/shanepresley)\
**Post date:** [August 14, 2008, 12:00am UTC](https://forum.cloverdx.com/t/generic-graph-to-replicate-data/372/1 "2008-08-14T00:00:00Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![dpavlis](https://avatars.discourse-cdn.com/v4/letter/d/90ced4/32.png) [@dpavlis](https://forum.cloverdx.com/u/dpavlis)\
**Post date:** [August 22, 2008, 9:22am UTC](https://forum.cloverdx.com/t/generic-graph-to-replicate-data/372/2 "2008-08-22T09:22:54Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [August 22, 2008, 9:37am UTC](https://forum.cloverdx.com/t/generic-graph-to-replicate-data/372/3 "2008-08-22T09:37:30Z")

</div>

Hi,  
there is example in [Examples](http://wiki.clovergui.net/doku.php?id=examples%5Findex) (graphDBUnloadUniversal.grf), which illustrates usage of dynamic metadata. You can install this example to eclipse by New → CloverETL → Clover.ETL Examples Project.