In the
first part we reviewed the general items around browser based and SDI based blending. This time we will focus on the implementation for the SDI based blending, and for our example we will use a BW 7.5 on HANA system.
Please note, that the following steps do require administrative access towards your SAP Analytics Cloud, and your SAP BW / SAP HANA environment.
Technical Pre-requisites
Before we start with the installation and configuration, please review the following SAP Notes:
- SAP Note 2541557 to review the minimum SAP BW release that is required.
- SAP Note 2715871 for additional SAP Note that might have to be implemented, depending on your SAP BW version / release.
- SAP Note 1600929 to ensure you are on the right version of SAP HANA
SAP Data Provisioning Agent
The Data Provisioning Agent (DP Agent) is available for Windows as well as for Linux and it is important that the DP Agent can connect to your SAP Analytics Cloud system as well as to your SAP HANA system.
Software Download
You can download the software from the SAP Software Download Center.
Installation media for an SAP HANA SPS:
- SAP Software Download Center > Software Downloads > Installations & Upgrades > By Alphabetical Index (A-Z) > H > SAP HANA SDI > SAP HANA SDI 2.0 > Comprised Software Components > HANA DP Agent 2.0
Support Packages and Patches for SAP HANA:
- SAP Software Download Center > Software Downloads > Support Packages & Patches > By Alphabetical Index (A-Z) > H > SAP HANA SDI > SAP HANA SDI 2.0 > Comprised Software Components > HANA DP Agent 2.0
Additional Link:
https://help.sap.com/viewer/DRAFT/7952ef28a6914997abc01745fef1b607/2.4.1/en-US/665d8ea78f0c4f0dbb530...
Installation
For the installation of the Data Provisioning Agent you can follow these steps:
https://help.sap.com/viewer/DRAFT/7952ef28a6914997abc01745fef1b607/2.4.1/en-US/dd8aaa71a6d4490485b8e...
After we installed the SAP Data Provisioning Agent, we now need to make some adjustments to the SAP HANA system.
SAP HANA Configuration Steps
The follow steps are separated into two approaches, depending on your license type with SAP HANA.
Please note, that these steps should be executed on the tenant where you have your SAP BW running (in case your HANA box is a multi-tenant system).
Steps for a full HANA license approach:
- Execute the following SQL command on your SAP HANA System:
CREATE USER SDI_ADMIN PASSWORD <admin_password> NO FORCE_FIRST_PASSWORD_CHANGE;
ALTER USER SDI_ADMIN DISABLE PASSWORD LIFETIME
This creates a administrative user for the table that we are going to create in the next step.
- Execute the following SQL command on your SAP HANA System:
CREATE COLUMN TABLE "SDI_ADMIN"."REMOTE_OBJECTS" (ID VARCHAR(100), TYPE VARCHAR(50), INSERT_TIME TIMESTAMP, SEQ INTEGER, EXPIRE_TIME TIMESTAMP, OBJECT VARBINARY(5000), PRIMARY KEY (ID, TYPE, INSERT_TIME, SEQ));
This will create the table "REMOTE_OBJECTS" as part of the schema SDI_ADMIN.
- After you created the user and the table, you will have to assign the following Object Privileges to the schema SDI_ADMIN to the ABAP Communication user:
The ABAP Communication use should be SAP<SID> or SAPHANADB by default.
Steps for a Runtime Edition HANA license approach:
- Execute the following SQL command on your SAP HANA System:
CREATE USER SDI_ADMIN PASSWORD <admin_password> NO FORCE_FIRST_PASSWORD_CHANGE;
ALTER USER SDI_ADMIN DISABLE PASSWORD LIFETIME
This creates a administrative user for the table that we are going to create in the next step.
- After you created the user, you will have to assign the following Object Privileges to the schema SDI_ADMIN to the ABAP Communication user:
- CREATE ANY
- DELETE
- INSERT
- SELECT
The ABAP Communication use should be SAP<SID> or SAPHANADB by default.
- Execute the ABAP report RS_BICS_INA_BLE_SETUP via transaction SE38.
- Enter SDI_ADMIN for the Database Schema
- Enter REMOTE_OBJECTS for the Database Table
Further details are available in SAP Note 2806650 and 2806682.
Until now we configured the DP Agent and we prepared our SAP HANA System for the Blending scenario. In the next steps we need to register the DP Agent with SAP Analytics Cloud and assign the DP Agent to our Live Connection.
SAP Analytics Cloud – Blending information (Part 1)
SAP Analytics Cloud – Blending information (Part 2)
SAP Analytics Cloud – Blending information (Part 3)
SAP Analytics Cloud - Blending Example
