topic Re: Migration of data from sql server to oracle server with different table structure. in Talend Studio

Migration of data from sql server to oracle server with different table structure.

Anonymous — Tue, 16 Apr 2019 12:03:32 GMT

Hi everyone,

Since i am new to this platform,need to know whether i can use Talend Open Studio for my business need i.e migration of data from Sql server to oracle server with different table structure i.e the old database(SQL server) is having different number of columns and the destination server that is oracle will have different number of columns post migration.

Please give your recommendation on this whether this ETL tool will meet my business need in an effective way.

Your inputs will be highly acknowledged and appreciated!!!

Thank you!!

Re: Migration of data from sql server to oracle server with different table structure.

joearun4u — Tue, 16 Apr 2019 12:19:00 GMT

hi @Manishs ,

Yes, Talend is the best ETL tool for any ETL development / transformation of data between any databases.

For answer to your question, You can migrate the data from MS sql server, and do transformation( customizing schema) and can able to load data into Oracle server.

Kindly feel free and post your questions to get answers here.

Thanks,

Joe

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

Re: Migration of data from sql server to oracle server with different table structure.

Anonymous — Tue, 16 Apr 2019 13:09:21 GMT

hi joearun4u,

Is there any limitations or challenge while using Talend Open studio?
Just want to know what is the risk factors involved while using this tool.

Re: Migration of data from sql server to oracle server with different table structure.

joearun4u — Tue, 16 Apr 2019 18:48:36 GMT

Hi,

The job which you will create through Talend open studio will work properly without any issues whenever you run .

But in Talend open studio , from my understanding

1.you can't execute the jobs in parallel using tparallelize component ,
2. Team collaboration is not possible .
3. TAC console will be available only with enterprise version ..

And few more components will not be available in Talend open studio .

Thanks ,
Joe

Don't forget to give kudos when you feel this reply is useful and accept the solution

Re: Migration of data from sql server to oracle server with different table structure.

joearun4u — Tue, 16 Apr 2019 18:50:00 GMT

Hi,

Kindly check the below link , it will be useful

https://community.talend.com/t5/Installing-and-Upgrading/Difference-between-the-open-source-and-enterprise-versions-of/td-p/157503

Thanks ,
Joe

Don't forget to give kudos if you feel this reply is useful and accept the solution

Re: Migration of data from sql server to oracle server with different table structure.

Anonymous — Wed, 17 Apr 2019 08:59:43 GMT

Thanks Joe for your valuable inputs.

Since,being the beginner in this tool I just have to propose my approach towards data migration from Sql server to Oracle server.

Database size is also not too large.

Just trying to figure out if any tool can minimize my manpower effort in this migration process.

Since the table structure has already modified from the original structure. Will TOS will serve my purpose?

And ,How complex or easy is to learn this tool being a complete new comer in ETL .

Re: Migration of data from sql server to oracle server with different table structure.

joearun4u — Wed, 17 Apr 2019 09:41:13 GMT

Hi,

According to me , you have selected the correct tool .. Talend is one of
the best tool to do all kind of ETL development .

It's very straight forward and easy to learn from beginners perspective
compared to all ETL tools ...

Feel free to post your queries here to get the answers ..

Thanks ,
Joe

Don't forget to give kudos or solution accepted if you find this suggestion
is helpful