Skip to Content
0

How to configure Impala ODBC on BI4.2 Linux server

Nov 29, 2017 at 09:44 PM

98

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mohammed Ashraf
Nov 30, 2017 at 06:03 AM
0

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

Show 1 Share
10 |10000 characters needed characters left 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.

0