Welcome to part 2 of this blog with step-by-step instructions on how to setup SDI for HCP.
Before starting here, make sure you have done all steps in part 1 or read the introduction here: Smart Data Integration available for HCP
For connecting your SDI agent to HCP you will need two HANA users:
You can create new users with your SYSTEM user, by going to the HANA Cockpit and select "Manage Roles and Users". When you create these new users, don't forget that the password you set will need to be changed at first login, so login at least once with each of these users to trigger the password change window.
Both of these users will need some specific authorizations. We'll cover here a quick summary, the details about all the authorizations (some optional) are documented here: Assign Roles and Privileges - Administration Guide for SAP HANA Smart Data Integration and SAP HANA ...
The SDI_USER will need these authorizations:
The SDI_DP_AGENT will only need this authorization:
Final step in the setup is to install and configure the on-premise agent. Before starting, let's look at the prerequisites:
Next you run the installer that you find in the package downloaded in step 1 (hdbsetup.exe). Provide the installation path and the Windows user and password and accept all other default values. The installation will only take a couple of minutes.
Once the data provisioning agent is installed, you can run the configuration tool to connect the agent to your HANA instance in the cloud. To start the configuration tool, go to the installation directory, navigate to the ConfigTool folder and start dpagentconfigtool.exe (defaul location: C:\usr\sap\dataprovagent\configTool\dpagentconfigtool.exe).
Once the data provisioning agent is installed, you can run the configuration tool to connect the agent to your HANA instance in the cloud. To start the configuration tool, go to the installation directory, navigate to the ConfigTool folder and start dpagentconfigtool.exe (default location: C:\usr\sap\dataprovagent\configTool\dpagentconfigtool.exe).
In the Agent Configuration tool, click on "Connect to HANA" and complete the fields in the connection information screen:
Once done click Connect and if any error message is returned, read carefully to see what's wrong. If you don't see any errors, your agent is successfully connected to the HANA database on HCP.
Once you have successfully connected, you can also register the agent. Click on "Register Agent" and provide a name that uniquely identifies this agent. Tip: it's useful to include the machine name as part of the name, so that later when you have multiple agents, from within the HANA WebIDE, you will be able to identity where an agent is physically located.
Congratulations, you have setup SDI for HCP now. Let's add one final step to test out a simple scenario for loading a file into HANA on HCP: Step-by-step: Setup SDI for your HCP account (part 3 - testing things out)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
37 | |
19 | |
13 | |
12 | |
11 | |
10 | |
10 | |
9 | |
8 | |
8 |