cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Datasphere - Create an outbound interface to send the data to SFTP-Server from Datasphere

Mandar_Damle
Participant

Hello Experts,

1. Can we export the daily delta datasets to the Non-SAP application or file server in a flat file (CSV or XLS format) via SFTP connection directly from the datasphere view or local table?
2. Can we generate a filename based on timestamp (yyyymmdd_hhmmss)?

Currently, this is possible with BW. We have a process chain where process steps are created with the ABAP program and its variants to generate and transfer the data from a particular DSO to the CFTP server.

Below is the BW process chain screenshot which showcases the file generation and transfer steps (It is using ABAP code with a variant where the variant contains the DSO names and the loading date based on which the delta dataset is created).

Mandar_Damle_0-1715169085666.png

Mandar_Damle_1-1715169085671.png

Is this possible with SAP Datasphere?

Thanks!

Regards,

Mandar Damle

View Entire Topic
cardoso
Product and Topic Expert
Product and Topic Expert

Hello @Mandar_Damle,

I'm not aware of any simple way to achieve this. 
Maybe in future if replication flows' target supports SFTP as target, could be a way.

This was already requested in Datasphere's Influence channel, see FTP/SFTP as Replication Target.
Feel free to upvote/track it there.

BR.