Extracting data from one DB and inserting in other DB

CloverDX Platform
1

Hi,
I have one question i have one data source as DB2 where i have multiple tables from where i have to extract the data and then update all that data into destination MS SQL DB tables.
Note : In destination data goes in multiple tables.

i have created simple graph consisting of DBInput , reformat , DBOutput components.

I have created metadata for both the DB sources.
So i would like to know whether Clover will insert data in Destination DB as per the relationships exists between tables ?

Thanks!
Tushar

2

Hi Tushar,

I am not sure whether I correctly understood your question. If you are asking whether DBOutputTable will reconstruct database structure flattened in DBInputTable by SQL join, then answer is no, it don’t. If you need to store data into more tables you need to use more DBOutputTable components. Also you need to ensure correct insertion order to ensure database integrity.

If my interpretation of you question is wrong, please rephrase.