cancel
Showing results for 
Search instead for 
Did you mean: 

Having errors with Smart data Access when connecting to Google Bigquery

ravicondamoor
Advisor
Advisor
0 Kudos

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


Former Member
0 Kudos

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

ravicondamoor
Advisor
Advisor
0 Kudos

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

Accepted Solutions (0)

Answers (0)