SAP Knowledge Base Article - Public

3658540 - Datasphere - SFTP as source of flow - use of dynamic file names

Symptom

You are creating a flow (Data Flow or Replication Flow) in SAP Datasphere.

The source of the flow is an SFTP server.

Relevant pages:
Prepare Connectivity for Generic SFTP
Generic SFTP Connections

You have to select what file from the SFTP server you want to load using the flow.

The challenge is that your SFTP server generates a new file everyday with a different name each time.
eg: day1.CSV, day2.CSV

You want the flow to load a file with a different name each time, without having to adjust the design of the flow.

Environment

SAP Datasphere

Resolution

Refer to documentation page Secure File Transfer Protocol (SFTP) Sources for Replication Flows

Refer to the section that describe the user of 'Global Pattern' and see the examples provided.

You can make use of the 'Global Pattern' to control which files get replicated.

---

If this functionality does not cover your needs, and you would like to propose a change to this functionality, please use the Influence tool:

SAP Note 3332382 - How to create an enhancement request for SAP Datasphere? 

Keywords

KBA , DS-DI-RF , Replication Flow Runtime , Problem

Product

SAP Datasphere all versions