Skip to Content

Having errors with Smart data Access when connecting to Google Bigquery

Aug 17, 2017 at 09:32 PM


avatar image


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 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/

Any help will be much appreciated.


10 |10000 characters needed characters left characters exceeded

Hi Ravi,

I have to try the same thing you described: connect SAP HANA SDA to Big Query, did you succeed in doing that at the end? Could you share with me your findings, please?

Thanks in advance

Kind Regards


* Please Login or Register to Answer, Follow or Comment.

0 Answers