One of the new features listed in the What’s New guide of SAP BusinessObjects 4.0 FP3 is that ability for Analysis for OLAP to connect directly to HANA OLAP content. However, this connectivity is not available by default. In order to enable this connectivity you have to add a java .jar file, found in the HANA client install, to the “lib” directory of the MDAS Adaptive Processing Server. Below are the steps required to configure this. Please note that the SAP HANA OLAP connection will not display in the CMC OLAP connection drop-down until these steps are followed.
Configuration Steps:
- Using the Central Management Console (CMC), stop the Adaptive Processing Server (APS) that hosts the MDAS.
- Install the SAP HANA Client (64-bit). Use the hdbinst.exe installation program found in the SAP HANA client installation directory.
- Once the client is installed you need to copy the file ngdbc.jar from the SAP HANA client installation directory (for example, C:\Program Files (x86)\sap\hdbclient\). The file should be placed in the “\java\pjs\services\MDAS\lib\external” subfolder. If the default BI platform installation folder is used, the destination folder is: “C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\pjs\services\MDAS\lib\external”. Note: You will need to create the “external” subfolder in the “\java\pjs\services\MDAS\lib” directory.
- Start the Adaptive Processing Server.
- Go to the CMC. The default URL is http://{HostName}/BOE/CMC where {HostName} is the name of your BusinessObjects Tomcat server.
- Go to OLAP Connections.
- Specify a Connection Name and Description.
- In the drop down select SAP HANA
- Configure the SAP HANA server host name
- Configure the SAP HANA port (30015 is the default)
- Click the connect button to test. In the test windows, enter your SAP HANA user / password for an account with access to the Analytic View.
- If you can connect successfully, specify how the MDAS will connect to HANA specifying a user account. You can also choose SSO or alternative credential mapping.
- Assuming you are connected, launch the BI Launch Pad. The default URL is http://{HostName}/BOE/BI where {HostName} is the name of your BusinessObjects Tomcat server.
- Launch “Analysis for OLAP” from the applications frame or dropdown menu.
- You should now see your SAP HANA analytic views as a possible source for OLAP analysis.
This is a terrific post and I’m very grateful you added it to your blog. Did SAP otherwise document this process somewhere? How did you come to find this?
Thanks for the comments and corrections. WordPress.com is bad about interpreting special characters as HTML mark up.
The information came from SAP. They should be releasing a SAP Note on this issue shortly. Until then, I though it would be helpful to get this out for everyone in ramp-up for Feature Pack 3.
Got it. Thanks for the early insight.