Aug 17, 2017 at 09:32 PM

Having errors with Smart data Access when connecting to Google Bigquery

512 Views

Hi,

Am trying to access data from Google BigQuery from Hana 2.0

Am using the ODBC driver from Simba.The driver is configured correctly and a test through isql works without any errors. But the driver fails to load through SDA.

My LD_LIBRARY_PATH is set correctly.

hdbadm@hana-bigdata:/usr/sap/HDB/home> echo $LD_LIBRARY_PATH /usr/sap/HDB/HDB00/exe/krb5/lib/krb5/plugins/preauth:/usr/sap/HDB/HDB00/exe/krb5/lib:/usr/sap/HDB/HDB00/exe:/usr/sap/HDB/HDB00/exe/Python/lib:/usr/sap/HDB/HDB00/exe/filter:/usr/sap/HDB/HDB00/exe/dat_bin_dir:/usr/sap/HDB/HDB00/exe/plugins/afl:/usr/sap/HDB/HDB00/exe/plugins/lcapps:/usr/sap/HDB/HDB00/exe/plugins/repository:/usr/sap/HDB/SYS/global/hdb/federation:/usr/sap/HDB/SYS/global/hdb/plugins/3rd_party_libs:/usr/local/lib:/usr/lib:/opt/simba/googlebigqueryodbc/lib/64

The driver file libgooglebigqueryodbc_sb64.so is in the LD_LIBRARY_PATH

Here is the error I get...

SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: [SAP][ODBC Driver Manager] Unable to load driver /opt/simba/googlebigqueryodbc/lib/64/libgooglebigqueryodbc_sb64.so

Any help will be much appreciated.

Thanks