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

[Anonymous]

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!!

[joearun4u]

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

[Anonymous]

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.

[joearun4u]

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

[joearun4u]

Hi,

Kindly check the below link , it will be useful

https://community.talend.com/t5/Installing-and-Upgrading/Difference-between-the-open-source-and-ente...

Thanks ,
Joe

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

[Anonymous]

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 .

[joearun4u]

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