Skip to Content
avatar image
Former Member

How to configure Impala ODBC on BI4.2 Linux server

Hi expert,

When I create a new connection with SAP Impala ODBC Driver on Windows IDT client, test connection is pass. But in server middleware mode, IDT test connection is failed.

Error is... DBDriver failed to load : /sap_bi/sap_bobj/enterprise_xi40/dataAccess/connectionServer/drivers/lib64/libdbd_ux32odbc23.so (libodbc.so.1: cannot open shared object file: No such file or directory)

I not much familiar with linux nor odbc concept in BI linux. I try review the BI4.2 SP4 Data Access Guide but still confuse.

Could anyone guide me, what's the working practices.

BI4.2 SP4, RedHat 7.2

Thanks and regards,

Chupong.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 30, 2017 at 06:03 AM

    Hi,

    Impala ODBC configuration on Linux System

    After installation, you can configure the ODBC Driver for UNIX Platform by referring to the ini file sample present in: <install_directory>/ sap_bobj/enterprise_xi40/simbaconf

    To change the Host and Port number, ODBCInstLib information, you need to configure the simba.impalaodbc.ini.sample by renaming it to simba.impalaodbc.ini

    • You can find driver specific libraries for ODBC drivers in the path:<install_directory>/sap_bobj/enterprise_xi40/<Platform>/odbc/simbaimpala/1.0/lib
    • Make sure the driver lib directory has been specified in the library path LD_LIBRARY_PATH
      export LD_LIBRARY_PATH = driver lib directory (/usr/...)
    • Set the environment variables SIMBAINI, ODBCINI to the path where simba.impalaodbc.ini file (inclusive of filename) is present.

      For example: export SIMBAINI= <install_directory>/sap_bobj/enterprise_xi40/simbaconf/<Configuration File>.ini
      export ODBCINI= <install_directory>/sap_bobj/enterprise_xi40/simbaconf/<Configuration File>.ini

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Thanks for your time.

      Could you please descri how can I set the ODBCInstLib?
      The sample ini in <install_directory>/ sap_bobj/enterprise_xi40/simbaconf does not have this.

      Thanks and regards,
      Chupong.