Step by step how to create a local SAP HANA connection with Analysis for Office 2.x

Create HANA local connection to an SAP HANA server with Analysis for Office 2.x version it easier and simple to configure. A local SAP HANA connection is created in the Select Data Source dialog.

With right click on the “select data source” you will be able to create the connection as you can see on the below images. Before create the connection you need a specific configuration that you can see below:

Restrictions for SAP HANA Connectors

Validity

For the MX_VALID_FROM user attribute, take into account that, if the valid from date for the user is earlier than the current date, the user is provisioned to the SAP HANA system with a validity from the current date. This limitation comes from the SAP HANA system, in which you cannot create a user with a validity starting in the past.

Password Provisioning

If an administrator sets a productive password in the Identity Management system, the user also has to configure it in the SAP HANA system. For more information, see the SAP HANA Platform documentation.

Privilege Grouping

Since no multiple assignments are possible in the SAP HANA system, the SAP HANA Connector in the Identity Management system does not support assignment grouping. For this reason, privileges are provisioned to the SAP HANA system separately, but not as a group.