Using ODBC Tracing on Windows Systems

On Windows systems, if you cannot connect to the data source or OLAP Metadata Catalog, use the tracing utility in ODBC Administrator to learn which ODBC call is failing.

  To use the tracing utility in ODBC Administrator:

  1. Start ODBC Administrator on the computer running Integration Server.

  2. Click the Tracing tab, specify a log file for the tracing utility, then click Start Tracing Now.

    Note:

    Tracing quickly creates a large log file. Disable tracing when you are finished: On the Tracing tab, click Stop Tracing Now.

  3. Start Integration Server and Integration Services Console.

  4. From Integration Services Console, selectConnections , then OLAP Metadata Catalog, then Connect, and try to connect to OLAP Metadata Catalog.

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

  6. If you cannot connect to OLAP Metadata Catalog (step 4) or to a data source (step 5), see the file that you specified as the log file in the root directory.

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