Using ODBC Tracing on UNIX Systems

On UNIX systems, if you cannot connect to the data source or OLAP Metadata Catalog, use the tracing to learn which ODBC call is failing. On UNIX systems, you must edit the odbc.ini file to enable and disable ODBC tracing.

  To use ODBC tracing on UNIX systems:

  1. On the computer running Integration Server, open the odbc.ini file by using a text editor such as vi.

  2. Find the section starting with [ODBC], as shown in the following example:

    [ODBC]
Trace=0
TraceFile=odbctrace.out
TraceDll=/export/home/users/hyperion/is/odbclib/odbctrac.so
InstallDir=/export/home/users/hyperion/is/odbclib

  3. Set the Trace setting to 1 to enable ODBC tracing.

    Note:

    Tracing quickly creates a large log file. Disable tracing when you are finished by setting the Trace parameter to 0.

  4. Start Integration Server and Integration Services Console.

  5. From Integration Services Console, select Connections , then OLAP Metadata Catalog, then Connect, and try to connect to OLAP Metadata Catalog.

  6. If you can connect to OLAP Metadata Catalog, open an OLAP model and try to connect to a data source.

  7. If you cannot connect to OLAP Metadata Catalog step 5or to a data source step 6, read the odbctrace.out file.

    If necessary, share the information in the log file with Oracle Technical Support to help solve the connectivity problem.