Migrate data onto Oracle DB on MS Azure using TOS

[Anonymous]

Hi All,

I need to migrate data from an On-Prem Oracle database onto another Oracle DB on MS Azure.

Pls let me know if this is feasible using Talend Open Studio.

If yes, pls share some references.

Regards,

HPR

[Anonymous]

Hello,

With talend open studio, you have to create many subjobs for mapping table by table in one job, because each table has different table structure, you have to create different subjob with corresponding schema, for example:

tOracleInput_1--main--tOracleOutput_1  (migrate table1)
   |
onsubjobok
   |
tOracleInput_2--main--tOracleOutput_2 (migrate table2)
   |
onsubjobok
   |
...other subjobs for other tables...

Best regards

Sabrina