Technical Articles
How to create remote connections – SAP Data Warehouse Cloud
Overview
Built on the concept of cross-application warehousing, SAP Data Warehouse Cloud prides itself with its openness and flexibility. Connect to third-party ETL tools, utilize a great variety of different data sources, and experience the full potential of a data warehouse in the cloud.
One of the great features of the SAP Data Warehouse Cloud is that it is compatible with a great variety of data sources, SAP, and non-SAP sources.
In order to get connected to your remote data source with SAP Data warehouse cloud, you need to set up a connection between your SAP system and SAP Data Warehouse cloud.
Below are the steps on how to connect your SAP S4/HANA or SAP BW systems to Data warehouse Cloud.
Log into your cloud tenant and navigate to your SPACES
This will bring into the main Space Management page. Locate the section that says (Connections). Here you can click on the (+) icon which will enable you to create the remote connection.
In the next screen, you will see the below pop up box where you choose which type of connection you would like to connect to.
In my case, I am going to be connecting to an SAP BW/4HANA system (ABAP).
Enter any business name you would like to give the system. In my case, I’m just going to say BW/4HANA. You can name it as your preference.
To proceed any further, you need to have a DP AGENT configured on your Data Warehouse Cloud tenant and it should be up and running as well. In case there is no DP agent set up or if it is currently is set up and not successfully running then you will not be able to proceed any further until the DP agent is fully functional.
Enter the details of your ABAP system you are trying to connect to
- Application Server details
- Client ID
- Instance Number
- User and Password (same details that you use to log on to your SAP system)
Once you have entered these details press (Create Connection). You will then be brought back to the main Space Management Screen where you will see the system you have added.
You can also check and confirm if the connection you created has been configured properly and if it is working by using the VALIDATE option.
Select the system you have just added and click validate, this will check and see if there are any errors associated with this configuration or the connection is ready to be used.
That’s it. You are done. Now you can consume all your tables, Views, Data models from the BW system in SAP Data warehouse cloud.
Reference Links:
If you have any questions about what I have done in this blog post please feel free to ask them below in the comment section. If you have any questions regarding SAP Data Warehouse Cloud in general, please post them into our Q&A section in the link below: