Skip to Content
avatar image
Former Member

Having errors with Smart data Access when connecting to Google Bigquery

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


Add comment
10|10000 characters needed 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

  • Former Member

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

  • Get RSS Feed

0 Answers