Skip to Content
Oct 04, 2016 at 01:11 PM

Can BODS 4.1 connect to HANA Cloud Platform?


I acknowledge that BODS 4.1 ended support in 12/2014. We are hoping to upgrade to 4.2 in the next 6 months.

We are doing a POC with HANA Cloud Platform and we've successfully connected on-premise with HANA Cloud Connector. We would like to go into Designer and create a new DataStore for a HANA Database. In BODS 4.2, it looks like you can select HDBODBC driver and configure it with a Data Source Name and Server Port that matches your HANA database in HCP.

BODS 4.1, however, does not have HDBODBC as an option. I found an SCN Blog that explains how to create a new HANA ODBC DSN entry for Data Services. I installed the HANA client for my platform (RHEL x86_64) in /usr/sap/hdbclient.

Unfortunately, the hdbsql command that establishes the connection through HANA Cloud Connector to my HANA DB in the HCP is failing.

hdbsql -n <hanaconnectorhost>:30015 -u dbadmin -p *******

error while loading shared libraries: cannot open share object file: No such file or directory

I've searched high and low to see if this is even possible with BODS 4.1. Does anyone know for sure?