Multiple RDBMS Client configuration
Posted: Sun Dec 31, 2006 2:12 am
Hi,
We are in the process of setting up the development server with DataStage EE on unix. We need to connect to multiple RDBMS (Oracle, SQL Server, etc.,) as our source systems are in multiple RDBMS databases.
1. I have installed Oracle & MS SQL server client in the ETL server.
2. Made entries of home directories in dsenv
3. Made entries of .odbc.ini
4. Made entries of .uvodbc.config
Is there anything else to do in order to access Oralce & MS SQL server databases from ETL server.
Please share your experience, which would enlighten me in the above process.
Thanks in advance.
Regards
Elavenil
We are in the process of setting up the development server with DataStage EE on unix. We need to connect to multiple RDBMS (Oracle, SQL Server, etc.,) as our source systems are in multiple RDBMS databases.
1. I have installed Oracle & MS SQL server client in the ETL server.
2. Made entries of home directories in dsenv
3. Made entries of .odbc.ini
4. Made entries of .uvodbc.config
Is there anything else to do in order to access Oralce & MS SQL server databases from ETL server.
Please share your experience, which would enlighten me in the above process.
Thanks in advance.
Regards
Elavenil