Can BODS 4.1 connect to HANA Cloud Platform?

[richard_howard]

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: libpam.so.0: 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?

[richard_howard · Accepted solution]

http://scn.sap.com/community/data-services/blog/2014/03/10/how-to-create-a-new-hana-odbc-dsn-entry-f...

https://www.youtube.com/watch?v=_fiyjIt2pKQ

https://www.youtube.com/watch?v=whQTt0guROA

The answer is YES, you can create a Datastore in BODS 4.1 on-prem and connect it through Cloud Connector to a HANA DB in HCP.  The above links were great reference material.  Now to test that it works as expected and transfer some data.

[richard_howard]

The libpam.so.0 error was resolved by loading 32-bit libraries.

yum install pam.i686

But still curious if anyone has successfully connected.  I'm going to keep trying.

[richard_howard]

Ugh.  I didn't need 32-bit libraries.  I needed to install the HDB_CLIENT_LINUX_X86_64 client.  I thought I had but must have gone too fast.

Regardless, I was able to successfully run an hdbsql command from my BODS 4.1 server to HCP and check the status of the Database so I'm optimistic about making this work.