Skip to Content
avatar image
Former Member

ODBC Trace in SAP HANA driver

Hi All,

Is it possible to enable tracing at ODBC level for SAP HANA connection from Informatica PowerCenter?

Regards,

JR

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 07, 2017 at 07:23 AM

    In case you wanted to trace the ODBC connection from Informatica PowerCenter to HANA with PowerCenter as a HANA client, then the federation trace is not going to help you.

    For this scenario, you can use the ODBC tracing, documented here: https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.02/en-US/35368f78f6884b019caee12c125b255a.html

    Basically you use the hdbodbc_cons tool to set up the tracing (be sure to use the same OS level user that runs the PowerCenter binaries).

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 06, 2017 at 11:40 PM

    Try turning on the federation tracing.

    1: Turn on the tracing with this command.

    alter system alter configuration ('indexserver.ini','SYSTEM')

    SET('trace','fedodbctrace')='debug',('trace','fedtrace')='debug',('trace','federationexecution')='debug' with reconfigure;

    2: Reproduce the issue

    3. Turn off tracing

    alter system alter

    configuration ('indexserver.ini','SYSTEM') UNSET

    ('trace','fedodbctrace'),('trace','fedtrace'),('trace','federationexecution') with reconfigure;

    Also see SAP note 1993254

    Add comment
    10|10000 characters needed characters exceeded