1700213 - Configuration Steps To Enable HANA Connectivity In Feature Pack 3

Symptom

• SAP HANA is not listed in the drop down in the Central Management Console (CMC) when attempt to create a connection to SAP HANA.

Environment

• SAP BusinessObjects Business Intelligence Suite 4.0 Feature Pack 3
• SAP HANA Database

Reproducing the Issue

1. Access the Central Management Console (CMC)
2. Create an OLAP connection
3. Select the drop down to select the OLAP source
4. SAP HANA is not listed
   

Cause

SAP BusinessObjects Analysis, edition for OLAP can connect to HANA data sources.  In order to enable this connectivity a few steps - outlined below - must be performed.  We expect that these manual steps will not be necessary with the release of Service Pack 4.

Resolution

Windows

1. Using the Central Management Console (CMC), stop the Adaptive Processing Server (APS) that hosts the MDAS. For more information about the APS and CMC, see the SAP BusinessObjects Business Intelligence Platform Administrator Guide.
2. Run the hdbinst installation program found in the SAP HANA client installation directory.
3. Copy the file ngdbc.jar from the SAP HANA client installation directory (for example, C:\Program Files (x86)\sap\hdbclient\) to the java\pjs\services\MDAS\lib\external subfolder of the BI platform installation folder. If the default BI platform installation folder is used, the destination folder is: C:\Program Files (x86)\SAP BusinessObjects\SAPBusinessObjects Enterprise XI 4.0\java\pjs\services\MDAS\lib\external.

Note:

1. You will need to create the external subfolder under the java\pjs\services\MDAS\lib folder.
2. Restart the Adaptive Processing Server.

SUSE Linux

1. Using the Central Management Console (CMC), stop the Adaptive Processing Server (APS) that hosts the MDAS. For more information about the APS and CMC, see the SAP BusinessObjects Business Intelligence Platform Administrator Guide.
2. Switch to the hdbclient installer path.
3. Change permissions on the sdbrun file in the SAP HANA client installer folder by typing chmod 777 sdbrun.
4. Install the SAP HANA client by performing these steps:

a. Type the command su.
b. Invoke the SAP HANA client installer by typing ./hdbinst -1 client.
c. Type the command exit su.
    5.  Copy the file ngdbc.jar from the /usr/sap/hdbclient32/ folder to the SAP BusinessObjects Enterprise XI 4.0/java/pjs/services/MDAS/lib/external/ folder.
Note:

1. You will need to create the external subfolder under the java/pjs/services/MDAS/lib folder
2. Restart the Adaptive Processing Server.

Red Hat Enterprise Linux

1. Using the Central Management Console (CMC), stop the Adaptive Processing Server (APS) that hosts the MDAS.  For more information about the APS and CMC, see the SAP BusinessObjects Intelligence Platform Administrator Guide.
2. Add a new temporary user, named “temp”.
3. Log out from the console terminal and log back in as “temp”.
4. Download and install the 32-bit version of libstdc++ for Red Hat Enterprise Linux (the SAP HANA installer requires the 32-bit library).
5. Switch to the hdbclient installer path.
6. 6.Change permissions on the hdbinst file in the SAP HANA client installer folder by typing chmod 777 hdbinst.
7. Change permissions on the sdbrun file in the SAP HANA client installer folder by typing chmod 777 sdbrun.
8. Install the SAP HANA client by performing these steps:

a. Type the command su.
b. Invoke the SAP HANA client installer by typing ./hdbinst -a client.
c. Type the command exit su.
   9.  Copy the file ngdbc.jar from the /usr/sap/hdbclient32/ folder to the SAP BusinessObjects Enterprise XI 4.0/java/pjs/services/MDAS/lib/external/ folder.
Note:

1. You will need to create the external subfolder under the java/pjs/services/MDAS/lib folder.
2. Restart the Adaptive Processing Server.

Keywords

SAP HANA,
Analysis for OLAP,
Feature Pack 3