Migrate data onto Oracle DB on MS Azure using TOS

One Star

Migrate data onto Oracle DB on MS Azure using TOS

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

Moderator

Re: Migrate data onto Oracle DB on MS Azure using TOS

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads