SAP Analytics Cloud – Blending information (Part 3)

[IngoH]

In the first two parts (Part 1, Part 2) we installed the Data Provisioning Agent and we configured our SAP HANA system for the blending process. Whats left for us to do now, is to configure the Data Provisioning Agent and to register the DP Agent with our SAP Analytics Cloud system.

 

Configuring & Registering DP Agent

• Logon to your SAP Analytics Cloud system.


• Navigate to System > Administration > Data Source Configuration.


• Scroll down to the SAP HANA Smart Data Integration area.


• Click on Register New Data Provisioning Agent.


• Enter a unique name for the DP Agent


• Enter a Description.


• Click Save (but do not close the screen).

 

We will need all the information shown in the screen as part of the next steps.

• Now logon to the system where you installed the DP Agent.


• Navigate to the default installation location, which should be \usr\sap\dataprovagent.


• Open the file dpagentconfig.ini for editing.


• Enter the values from the SAP HANA Smart Data Integration screen for the following options:
  
  
  
  • agent.name
  
  
  • hana.server
  
  
  • hana.port
  
  
  
  


• Also ensure the following values are configured as shown:
  
  
  
  • hana.onCloud=true
  
  
  • hana.useSSL=true
  
  
  
  


• Make sure to save the changes.


• In case you require a proxy, you also need to configure the following lines:
  
  
  
  • cloud.useProxy-true
  
  
  • proxyHost=<proxy hostname>
  
  
  • proxyPort=<proxy port>
  
  
  
  


• Now open a command prompt and set the environment variable
  
  
  
  • on Windows : set DPA_INSTANCE=<Installation Folder>
  
  
  • on Linux: export DPA_INSTANCE=<Installation Folder>
  
  
  
  


• Now Start the DP Agent
  
  
  
  • on Windows: <Installation Folder>/bin/agentcli.bat --configAgent
  
  
  • on Linux: <Installation Folder>/bin/agentcli.sh --configAgent
  
  
  
  


• In case the agent has already been started, use the option to stop and then start.

Configuring HANA XS Details

Now we need to configure the HANA XS User and password as part of the DP Agent configuration.

• Run the following command:
  
  
  
  • on Windows: <Installation Folder>/bin/agentcli.bat --setSecureProperty
  
  
  • on Linux: <Installation Folder>/bin/agentcli.sh --setSecureProperty
  
  
  
  


• Select the option 1. HANA XS Username


• Enter the HANA XS Username that is shown in the SAP Analytics Cloud screen (please note, the user name will not be shown at the command prompt).


• Select the option 2. HANA XS Password.


• Enter the password shown in the screen from SAP Analytics Cloud.


• After you confirmed the password, use Q to close the program.


• Restart the DP Agent using the steps from before.


• Close the screen in SAP Analytics Cloud.

Configuring SAP Analytics Cloud

• In SAP Analytics Cloud navigate to System > Administration > Data Source Configuration


• Scroll down to the area SAP HANA Smart Data Integration.


• Click on the option Add New Remote Source.


• Enter a new Name for the Remote Source.


• Enter the full qualified host name of your SAP HANA System.


• Enter the SQL Port of your SAP HANA System.


• Enter the Schema and Table name of the table you created.
  In our example SDI_ADMIN.REMOTE_OBJECTS


• Enter the credentials for the SDI_ADMIN user we created before.


• Click Save.


• After the Remote Source has been added, click Add Live Data Connection.


• Select the Live Connection, in our example the Live Connection for BW on HANA (or BW4HANA)


• Click Save.

 

 

At this point we have finished the configuration and we can now use the browser based as well as SDI based blending and combine data from BW with data - for example - from a spreadsheet.

 

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

[former_member653197]

Hello Ingo,

Thanks for the complete Articles on the SDI Blending. Its very detailed and very much useful

I have a scenario where i am trying to Blend the data from SAP BW Live Model with Import Model (Excel based ) on SAC. The Overall data volume from the Live Model is more than 10MB size and hence the Browser based Blending is not suitable for us.

So we started with the SDI based Blending and we are in the process of configuration of SDI and DP Agent setup

• System Details. BW 7.5 on HANA 1.0 SP12

My Question here is:

Is the Data Blending happens on SAC or on the HANA system where SDI is configured ? I read the sap documents saying that Blended data will be stored on SAC in a temporary Cache for upto 1hr but i am not sure if the Data Blending also happens in SAC

Ideally we want the data from Import Model (in SAC) to be pushed down to HANA (where SDI is configured) and Blending of data should happen with in OnPremise and not on SAC and than result should be sent back to SAC.

Please let me know your feedback

Thanks,Ram

[rajakaturi]

Are any additional features available for blending of data in SAC?

 

Regards,

Raj.