Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
shoeb_k
Participant
Hello,

 

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.


Subaccount Information


 

Step 2: SAP Cloud Connector

Log in to SAP Cloud Connector - Click on ‘Connector’ -> Add Subaccount


 

Fill the subaccount information picked from DWC in Step1


 

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


 

 

Step 3: SAP Cloud Connector

In the Cloud Connector -> select sub account and then click 'Cloud To On-Premise'


 

On the 'Access Control' tab click +


 

For SFTP connectivity (or for any other non-SAP connectivity) - select the following options



 

Fill in the SFTP server details


On the next screen - define a virtual host and port. The virtual host and port will be used for connectivity on the cloud side.


 

Review summary and finish the setup


 

To check and validate the connectivity from Cloud Connector


 

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.


click create.

Next,

Click on ‘Connections’ -> navigate to the appropriate SPACE ID which you want to use for connectivity.

click 'create'


 

select the connection type -'Generic SFTP'


Fill the respective fields




*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


 

'validate' the connection from DWC


Successful connection will return the following


 

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


Ljs trace and traffic trace will be helpful in troubleshooting scenarios.

 

Regards,

Shoeb

--

References:

https://help.sap.com/docs/SAP_DATASPHERE/9f804b8efa8043539289f42f372c4862/5454a8cfdb9845a9b6c772d63b...

https://help.sap.com/docs/SAP_DATASPHERE/9f804b8efa8043539289f42f372c4862/70ee87c19d3b47459ac7f2c8d4...

https://help.sap.com/docs/SAP_DATASPHERE/9f804b8efa8043539289f42f372c4862/2f80b57359254b5cbb4faac794...

https://help.sap.com/docs/SAP_DATASPHERE/9f804b8efa8043539289f42f372c4862/35141e7668774958b5e59495f7...

 

 

 

 
12 Comments
Labels in this area