HCI-DS Agent installation and Configuration
This blog is intended for SAP Technical/BASIS administrator, who need to setup SAP Cloud Integrator Data Services. Document describe the detail steps for setting up SAP Cloud Integrator Data Service in context of SAP IBP (Integrated Business Planning) Cloud application and customer on-premise landscape. Same procedure can also be used for setting up connection for SAP Success Factor application.
The SAP Data Services Agent provides secure connectivity to on-premise sources in your landscape.
At design-time, the agent is used to provide metadata browsing functionality for on-premise sources to the web-based user interface. At run-time, the agent will take care of the secure data transfer from the on-premise source to the targets in the cloud.
SAP Cloud Platform Integration for data services interacts with your local SAP landscape via the SAP Data Services Agent and secure HTTPS and RFC connections.
During initial setup of HANA Cloud Integration instance for your organization, SAP will setup administrator ID for your organization. Administrator Id can further request access for more users with different access and authorization based on individual role.
User will get an account activation mail containing Organization Name and with link to activate the account to access SAP Cloud Platform Integration Portal WebUI. Ideally existing S-User Id for SAP portal will be authorized to access the HCI DS Portal.
Organization name will be having <DS><2-digit for Data Cenre Geography><4 numeric digit for organization code> e.g DSUS1234
Login to SAP Cloud Platform Integration Portal WebUI
Login using S user ID or e-mail Id mapped with S-user Id in User profile on SAP Portal.
Go to AGENTS tab and click on Download Agent Package.
Download latest DS Agent package.
- Copy Downloaded Agent package on Windows host.
Run the package installer as administrator.
HCI-DS Agent need user with administrator privileges. Get a User e.g. SVCHCIAGENT and add it to local administrator group. This user will be used to start/stop SAP Data Agent Service on Window system.
Enter User name as SVCHCIAGENT and Password
Following log will be generated as a successful installation of Data Service Agent.
=== Installing files
Installing Files…please wait
=== Configuring environment
Generating configuration file
Updating Adapters startup script
Updating the adapters startup script
Updating configuration file
Setting the environment variables
=== Generating certificates
Creating SSL keys and certificates for the Job Server…
Initializing the keystore for Job Server…
Initializing the keystore for Metadata Browsing Server…
=== Configuring internal database
=== Create an event to purge SQLA log files
=== Creating repositories
Creating sandbox repository
Creating production repository
=== Configuring job server
Creating the Job Server
Adding the repository into the Job Server
=== Upgrading adapters
Updating the adapters configuration files
=== Starting agent service
SAP Data Services Agent service started successfully
Success: Installing files
Success: Configuring environment
Success: Generating certificates
Success: Configuring internal database
Success: Create an event to purge SQLA log files
Success: Creating repositories
Success: Configuring job server
Success: Upgrading adapters
Success: Starting agent service
SAP HCI-DS Agent setup require Agent Configuration file from SAP Cloud Platform Web UI
Go to HCI Web UI to download Agent Configuration File.
Click on New Agent.
Enter some meaning full name with Description.
Name under Agent Group will be your Organization Name i.e. DSUS1234.
Save AgentConfig.txt file.
Copy the AgentConfig.txt file at directory C:\Program Files\SAP\DataServiceAgent on DS Agent server.
Go to C:\Program Files\SAP\DataServiceAgent and run ConfigureAgent as administrator.
Enter e-mail Id registered with S-User ID, used to access Cloud Web UI.
Specify location for AgentConfig file. Leave other option as default.
Go back to HCI Web UI
Agent status will change to GREEN.
Selecting the Agent will display the detail of the DS Agent host.
To create Data Store connection for SAP Cloud instance in HCI Web UI, instance tenant had be ready by SAP for your organization unit as per customer license.
Go to tab DATASTORES
Click on New DataStore icon.
Specify the input for Name and Description.
In Credentials section, select ‘Integrated Business Planning’ as Application Type and Instance as ‘<Organization>_Test_NW’ from drop-down list.
Save the entry.
Go to DATASTORES tab and click on ‘+’ icon to create new Data Store.
Enter the required connection detail for customer SAP system and Save.
All DataStore connection will appear in the left side navigation panel.
To test the connection, press button
Create directory structure as defined below. You can use any naming convention of your choice.
Go to C:\Program Files\SAP\DataServicesAgent and run ConfigureAgent as administrator.
Click on Configure Directories.
Click on Add and enter directory C:\Program Files\SAP\DataServicesAgent\HCI_INTEGRATION
It will prompt to restart the agent. Select Yes.
Go to SAP Cloud Platform Integration and go to tab DATA STORES.
Click on button to add New DataStore
Provide the input as above. In the Type field, select ‘File Format Group’.
Click on Save.
Select DS_AGENT_FILE and click on Configuration
Enter C:\Program Files\SAP\DataServicesAgent\HCI_INTEGRATION\ in Root directory and Save.
If Gateway Security is enabled in SAP environment, make sure that HCI DS Windows hosts is permitted in Gateway security to connect with SAP system.
Once all technical connection are setup, metadata is defined under individual DataStore to be used by various HCI Tasks.
Based on project requirement, SAP Cloud Platform Integrator for Data Services further can be used to setup connection to any Database including SAP HANA DB, hosted in customer On-Premise landscape or other cloud platform. I shall be describing process of setting up Data Store in SAP Cloud Platform Integration for an On-Premise HANA DB, using HANA DB Client.
Hope this is helpful to consultants, who is working on setup SAP Cloud Platform Integrator for Data Services for the first time.