Connecting Oracle Database Gateway to TDV Using ODBC
Oracle and the Oracle heterogeneous services are a third-party tools. These instructions are included only as a guideline; your system and the steps necessary to configure it might vary from the test system that was used in this sample. You will need to refer to Oracle documentation and perform thorough testing of your system after completing the install and configuration.
To connect to TDV Server through Oracle on UNIX
1. Obtain DG4ODBC.
DG4ODBC interacts with Oracle Heterogeneous Services to provide transparent connectivity between Oracle and non-Oracle systems. DG4ODBC is shipped with Oracle 11g. You can also download DG4ODBC from the Oracle Technology (OTN) Software Downloads Page.
2. Setup ODBC drivers and define necessary environment variables. For more information, see the TDV Administration Guide information about using ODBC drivers with UNIX. For example, the following environment variables might need to be defined:
— COMPOSITE_HOME
— ODBCINI
— ODBCINSTINI
— LD_LIBRARY_PATH
3. Make a backup copy of existing odbc.ini and odbcinst.ini files.
4. Run the TDV driverConfig utility to generate the odbc.ini, odbcinst.ini files.
5. Change the Oracle environment to include the odbc.ini, odbcinst.ini files.
6. Add the path to the TDV ODBC driver for the following environment variable depending on your system type:
System Type | Environment Variable |
Linux | LD_LIBRARY_PATH |
AIX | LIBPATH |
7. Configure a connection to the TDV Server on the Oracle Server.
8. Test the connectivity between TDV and Oracle.