Introduction:
In this blog post we will be discussing the steps required to setup connectivity between SAP Datasphere (formerly Data Warehouse Cloud) and SFTP data source hosted on-premise.
Components involved:
- SAP DWC/Datasphere
- SAP Cloud Connector – on premise
- SFTP server – on Premise
The connectivity type used will be ‘Generic SFTP’ and it will support ‘Data flows’.
Pre requisites:
- The firewall rules must be adjusted to allow SAP Cloud connector to connect with SFTP server.
- SAP Datasphere is allowed to connect with SAP CC.
- You must have access to Cloud Connector administration.
- You must also have administration credentials on SAP DWC/Dataspehere.
Step 1: SAP Datashphere environment
Collect details of your DWC environment – log in DWC -> System -> Administration -> Data Source Configuration
make note of account information, subaccount, Region, user and also make sure that you have the password for the subaccount user.
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-1.jpg?resize=352%2C269&ssl=1)
Step 2: SAP Cloud Connector
Log in to SAP Cloud Connector – Click on ‘Connector’ -> Add Subaccount
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-2.jpg?resize=604%2C119&ssl=1)
Fill the subaccount information picked from DWC in Step1
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-3.jpg?resize=481%2C333&ssl=1)
Take note of the ‘Location ID’. It will be used later in the steps.
Location ID is defined by us, it is a unique ID for the account.
When the account is set-up we can select to switch account to view its status
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-4.jpg?resize=730%2C254&ssl=1)
Step 3: SAP Cloud Connector
In the Cloud Connector -> select sub account and then click ‘Cloud To On-Premise’
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-5.jpg?resize=221%2C321&ssl=1)
On the ‘Access Control’ tab click +
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-6.jpg?resize=602%2C140&ssl=1)
For SFTP connectivity (or for any other non-SAP connectivity) – select the following options
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-7.jpg?resize=475%2C217&ssl=1)
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-8.jpg?resize=473%2C213&ssl=1)
Fill in the SFTP server details
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-9.jpg?resize=473%2C214&ssl=1)
On the next screen – define a virtual host and port. The virtual host and port will be used for connectivity on the cloud side.
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-10.jpg?resize=543%2C244&ssl=1)
Review summary and finish the setup
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-11.jpg?resize=537%2C244&ssl=1)
To check and validate the connectivity from Cloud Connector
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-12.jpg?resize=730%2C190&ssl=1)
Step 4: SAP Datasphere
Log on to the DWC environment : Go to ‘system’ -> ‘administration’ -> ‘Data Source Configuration’
Click – ‘Add a new location’
Add the cloud connector location ID which we created in SAP Cloud Connector subaccount setup.
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-13.jpg?resize=399%2C351&ssl=1)
click create.
Next,
Click on ‘Connections’ -> navigate to the appropriate SPACE ID which you want to use for connectivity.
click ‘create’
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-14-1024x369.jpg?resize=730%2C263&ssl=1)
select the connection type -‘Generic SFTP’
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-15.jpg?resize=602%2C318&ssl=1)
Fill the respective fields
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-16.jpg?resize=602%2C211&ssl=1)
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-17.jpg?resize=602%2C150&ssl=1)
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-18.jpg?resize=602%2C204&ssl=1)
*Note that the host key will be provided by the SFTP administrator.
Procedure to generate the host key is explained here
*Authentication can be user/password based or it can also be SSH type.
*Desired root path can also be defined for browsing objects.
Finalize the connection
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-19.jpg?resize=602%2C317&ssl=1)
‘validate’ the connection from DWC
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-20.jpg?resize=602%2C128&ssl=1)
Successful connection will return the following
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-21.jpg?resize=168%2C114&ssl=1)
Conclusion:
Source data on the SFTP servers can easily be accessed using the procedure defined above.
Data Flows are enabled without the need to set any additional connection properties.
Troubleshooting:
Cloud Connector Troubleshooting, logs and traces:
Update the trace level by clicking edit button and select the highlighted parameters
![](https://i0.wp.com/www.erpqna.com/wp-content/uploads/2023/03/sap-datasphere-on-premise-sftp-connectivity-22.jpg?resize=602%2C261&ssl=1)