One of the key features of SAP Data Warehouse Cloud is its vast openness towards integrating a great variety of different data sources. No matter where your data lives, you should be able to access it in your Data Warehouse solution!
In this video, we’ll look at how to establish connections to remote SAP HANA databases, applications build on top the ABAP application server, or public OData services in SAP Data Warehouse Cloud.
In the Space Management go into the Space which you’d like to connect to the remote system or service.
Scroll to the section “Connections” and add a new connection by clicking the + icon.
Connecting a remote SAP ABAP-based system
Let’s start with an ABAP connection. Click the tile,
and you’ll be prompted to provide a name and select the Data Provisioning Agent.
Please note: before you can establish an SAP ABAP and a SAP HANA connection, you WILL need to create a Data Provisioning Agent in DWC first.
To learn how to do this, please click here.
Click “Next step”, and you’ll be prompted to enter the Connection Properties.
One possibility to get the connection details is via SAP Logon.
Fill in the information on the Server, Client, Instance Number, as well as the Credential Mode, if you want to define a specific user, e.g. the Technical User or a Secondary name-specific user. Then, also enter your username and password. And then: click “Create Connection”.
You’ll now see this new ABAP Connection listed in your Connections. Select the connection and Click on “Validate Connection” to make sure that the connection is – in fact – valid and working.
And that’s it. Our ABAP Connection is good to go!
Let’s move right on to a SAP HANA connection.
Again, we’ll click on the tile and again, the wizard walks us through creating the connection.
Provide a Business and Technical Name and the Data Provisioning Agent.
Click “Next Step” and enter the Connection Properties here.
Please note: For HANA connections, you can find the credentials inside HANA Studio.
Provide the Host, Port Number, the correct Security details, the Credential Mode for the user, as well as your own credentials.
Click “Create Connection” and see how your new connection appears in the list.
Again, check the validity of the connection by clicking on the little check-box icon.
And finally, let’s also make a connection to a public OData service.
We’ll click on the OData tile, and then
Provide the Business and Technical Name of our new connection.
And then simply provide the URL of the OData service..
Please note: At this point, SAP Data Warehouse Cloud only support simple OData connections. For example, Parameters are currently not yet supported.
Then, also choose the Connection Mode that works for you, and type in your username and password.
Click “Create Connection” and voila! There it is!
Again, check the validity of your creation as a last step.
Then get the most out of your three new connections!
Thanks for watching!