Skip to Content

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: 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?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Oct 05, 2016 at 07:41 PM

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

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 04, 2016 at 02:36 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.