DSXchange

Hi

We need to change the Databse, planning to use SQL server DB instead of Oracele DB.
For that i need to test the SQL connectivity in my environment. and i got a SQL server name ,DB name ,User_id and pwd.

Can you tell me what are all i need to setup? before i create a sample job with ODBC stage (Source ODBC stage for SQL server -> Target Oracle stage)
Do i need to add TNS entry in any of the Unix files(in DSEngine).

It will be helpfull if someone give me detailed steps.

Thanks in Advance

Update the .odbc.ini file loacated in $DSHOME thru adding the DSN with the correct Driver information,ip address,username&password and port num...

Update the uvodbc.config file loacated at $DSHOME and each project directory,adding the new DSN name...

Update the dsenv file....and execute this file after updating..