Source db change from oracle to sql server

Four Stars

Source db change from oracle to sql server

Hi, We have lot of jobs that reads from oracle, our source system decided to change their database from oracle to sql server. what would be the easiest way to convert all the jobs to read from sql server? do we need to rework on each and every job?? are there any utilities available for auto converting the jobs to use sql server instead of oracle??  Thanks & Regards, SaiSridhar Nekkanti

Nine Stars

Re: Source db change from oracle to sql server

I believe there is no easy way to just change the oracle database components to sql server components. They needs to be created again and configured again with the changed server/database details.

If the jobs are using Oledb components like tOledbInput or tOledbOutput then changing the connection URL would suffice provided the tablename, query & schema details are taken care of.

Forteen Stars

Re: Source db change from oracle to sql server

@talendsai,if you have used generic component like (tJDBCinput and tJDBCoutput )  and connection if your are using repository connection,you can just edit the connection and re-trive schemas.if you have used oracle components you need to re-design all the jobs.

Manohar B
Don't forget to give kudos/accept the solution when a replay is helpful.
Highlighted
Employee

Re: Source db change from oracle to sql server

Hi,

 

      Since your programs is currently using tOracle components, you will have to replace them with new components.      

 

      One another aspect you need to think is the type of queries the program is currently using while data extraction. If the program is using Oracle specific functions, then you will have to convert to a compatible function in MS SQL Server.

 

Warm Regards,

 

Nikhil Thampi

   

Tags (2)

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog