Skip to Content
0

Having errors with Smart data Access when connecting to Google Bigquery

Aug 17, 2017 at 09:32 PM

177

avatar image
Former Member

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


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

Marco

0
Former Member

I didn't pursue this further...but I heard that SDA will officially support BigQuery soon. Don't have any firm dates.

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

0 Answers