Multiple RDBMS Client configuration

elavenil · Post by **elavenil** » 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

ray.wurlod · Post by **ray.wurlod** » Sun Dec 31, 2006 3:02 am

A small correction, it's not the .uvodbc.config file, it's the uvodbc.config file. There is one in each project, against the possibility that you may need different ODBC data sources to be visible from different projects.

You may also benefit by installing and configuring Oracle client software on the DataStage server machine, so that you have the choice of Oracle (rather than ODBC) when accessing via the Dynamic RDBMS stage. Ditto for any other database to which you wish to connect.