How Do I Work with SAPB1 HANA? (Magic xpi 4.7)
To work with SAPB1 HANA, you first need to:
-
Install the SAP HANA DI API
-
Install the SAP HANA ODBC driver
-
Create ODBC data sources
-
Define the ODB connection string for SAP HANA triggers
|
| Once you have installed the SAP HANA DI API, only that specific version can be used from the machine where it was installed. It is not possible to connect to other SAPB1 versions. |
The SAP HANA ODBC driver that is necessary for connecting to the database is provided with the SAP HANA client software. You need to download the client software and install it on your Magic xpi machine.
Once you have installed the required ODBC driver, you need to create a dedicated ODBC data source for each database that you want to connect to. Data sources hold the connection credentials that are used for locating and accessing the SAP HANA database, such as the database’s name and password, and the user name.
On Windows machines, follow these steps to create an ODBC resource:
-
From the Start menu, select Control Panel and Administrative Tools.
-
In the Administrative Tools dialog box, double-click ODBC Data Sources (32-bit).
-
In the ODBC Data Source Administrator dialog box, click the System DSN tab.
-
Here, create an ODBC data source for 32-bit Windows using the HDBCODBC32 driver that you downloaded with the SAP HANA client software.
|
| If you are working with a 64-bit operating system and you do not see the ODBC Data Sources (32-bit) option in the Administrative Tools dialog box, you should run the %windir%\sysWOW64\odbcad32.exe command to open the ODBC Data Source Administrator dialog box. |
If you want to use SAP HANA triggers, you need to take the ODBC connection string, defined in the ODBC Data Source Administrator dialog box, and enter it in the Connection Properties column of the SAPB1 Multi Resources List . The required format is <connection string>\<db owner>. If the backslash (\) is not entered, the entire entry will be regarded as the connection string and the db owner value will be taken from the SAPB1 resource’s Company Database property.
