How to Connect to a HANA Database Using an OLEDB-ODBC Bridge

Introduction

This article provides guidance for using the Call Stored Procedure (OLEDB) tool to connect to a SAP Business One HANA database.

Problem

The SAP HANA database has an 32-bit ODBC driver (HDBODBC32). However, if your tasks make use of the Call Stored Procedure (OLEDB) tool, you are unable to make use of the stored procedures.

You’ve tried to create a OLEDB connection to the HANA ODBC data source but this has resulted in the BPA Platform client being unresponsive.

Solution

To create an OLEDB connection to an ODBC data source, you must use Microsoft OLEDB Provider for ODBC Drivers and create a connection to any ODBC data source first before changing it to the SAP HANA data source. In the procedure below, we are connecting to a Microsoft SQL Server data source:

Creating an ODBC Data Source

Create an ODBC data source to a working database (not HANA):

  1. Launch the Windows ODBC Data Source Administrator (32-bit).

    ODBC Data Sources Administrator (32-bit)

  2. In the System DSN tab, Add a new ODBC data source.
  3. Select the relevant driver and click Finish — for this example, use SQL Server.
  4. Name this connection and select the Server to connect to.
  5. Click Next and provide the server details (username, password, and so on) as requried.
  6. Save the connection.

Creating a BPA Platform OLEDB Connnection

Now create a global OLEDB connection to a valid database using the ODBC data source. You can create the global connection in either the Database Query (OLEDB) or Call Stored Procedure (OLEDB) tool; the global OLEDB configuration is shared between the two:

  1. Log into the BPA Platform client.
  2. Go to Manage < Tools < Data Connectors < Call Stored Procedure (OLEDB).
  3. Add a new connection using the Microsoft OLEDB Provider for ODBC Drivers driver.
  4. Go to the Machine Data Source tab and select the System DSN created previously:

    OLEDB Global Connection - Microsoft OLEDB Provider for ODBC Drivers - Machine Data Source

  5. Clear the selection for Use Trusted Connection and enter the required credentials for the database.
  6. Click Options and choose the relevant Database.
  7. Click OK.

Connecting to the SAP HANA Data Source

NOTE: The following assumes a HANA ODBC data source has already been created in the machine’s ODBC Data Source Administrator. If not, follow the instructions found in Creating an ODBC Data Source, connecting to the HANA ODBC driver instead.

Finally, we change the OLEDB connection to point to the HANA database:

  1. Still in the OLEDB global configuration window, highlight the new connection created previously and click Properties.
  2. Click Reconfigure.
  3. Change Machine Data Source to the HANA ODBC data source; click OK.
  4. Change the Login ID (username), Password, Database, and Workstation to the relevant SAP HANA database.
  5. Save your changes.

You should now be able to access the SAP HANA database over OLEDB.