How to configure Impala ODBC on BI4.2 Linux server

[former_member259284]

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.

[former_member456023]

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

[former_member259284]

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.