Symptom
- You have installed an SAP Datasphere installation and need to connect some satellite systems.
- The connection is failing.
- This could be a Data Provisioning (DP) Agent or any other satellite system which is connecting.
- In this KBA we will show how you can quickly rule in or rule out an IP Allowlisting issue.
Environment
SAP Datasphere
Cause
Depending on the type of connection you are making, it will be necessary to Allowlist the IP's of the connecting systems.
Refer to KBA 3456052 FAQ: About IP Addresses used in SAP Datasphere, for more details on this.
This KBA shows a very quick way to rule in or rule out IP Allowlisting as the reason for the connection error.
You can temporarily allow all IP's and if your connection is then successful, then you will know the reason for the connection error is IP related.
You can then identify the correct IP or IP range for the connection system and add this into the SAP Datasphere tenant.
Also to note, it is not recommended or advised to allow all IP's for a prolonged basis. This is merely recommended for a brief testing period and then the configurations as below should be removed.
Resolution
- Logon to the SAP Datasphere tenant
- Go to System -> Configuration -> IP Allowlist -> Trusted IPs
- Click on Add in 0.0.0.0.0/0
- Test your connection and if it is successful you can focus on identifying the correct IP or IP range for the connecting system(s).
- Remove the option here to allow all IP's after the testing is completed.
See Also
- Add IP address to IP Allowlist | SAP Help Portal
- Finding SAP Datasphere IP addresses | SAP Help Portal
- Connect and Configure the Data Provisioning Agent | SAP Help Portal
- KBA 3524830 Error when adding Datasphere HANA DB details in SAP Integration Suite
Keywords
DS, DPAgent, SAP Cloud Connector, SCC, security, firewall, restrict, limit, SAP DBTech JDBC: Cannot connect to jdbc, Ensure that the IP address of the agent host is allowlisted in SAP HANA system. , KBA , DS-DI-CON , Connections , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem