Create an FTP or SFTP source connector in the UI
The FTP and SFTP connectors are in beta. The features and documentation are subject to change.
Source connectors in Adobe Experience Platform provide the ability to ingest externally sourced data on a scheduled basis. This tutorial provides steps for creating a FTP or SFTP source connector using the Platform user interface.
This tutorial requires a working understanding of the following components of Adobe Experience Platform:
- Experience Data Model (XDM) System : The standardized framework by which Experience Platform organizes customer experience data.
- Real-time Customer Profile : Provides a unified, real-time consumer profile based on aggregated data from multiple sources.
If you already have a valid FTP or SFTP connection, you may skip the remainder of this document and proceed to the tutorial on configuring a dataflow .
Supported file formats
Experience Platform supports the following file formats to be ingested from external sources:
- Delimiter-separated values (DSV): Support for DSV formatted data files are currently limited to Comma-separated values (CSV). The value of field headers within DSV formatted files must only consist of alphanumeric characters and underscores. Support for general DSV is to be provided in the future.
- Apache Parquet: Parquet formatted data files must be XDM compliant.
Gather required credentials
In order to access your FTP or SFTP server on Platform, you must provide the server's host name , a user name , and a password .
Connect to your FTP or SFTP server
Once you have gathered your required credentials, you can follow the steps below to create a new FTP or SFTP account to connect to Platform.
Log in to Adobe Experience Platform and then select Sources from the left navigation bar to access the Sources workspace. The Catalog screen displays a variety of sources for which you can create an inbound account with, and each source shows the number of existing accounts and dataflows associated with them.
You can select the appropriate category from the catalog on the left-hand side of your screen. Alternatively, you can find the specific source you wish to work with using the search option.
Under the Databases category, select SFTP click on the + icon (+) to create a new FTP or SFTP connector.
The Connect to SFTP page appears. On this page, you can either use new credentials or existing credentials.
If you are using new credentials, select New account . On the input form that appears, provide the connection with a name, an optional description, and your FTP or SFTP credentials. When finished, select Connect and then allow some time for the new account to establish.
To connect an existing account, select the FTP or SFTP account you want to connect with, then select Next to proceed.
By following this tutorial, you have established a connection to your FTP or SFTP account. You can now continue on to the next tutorial and configure a dataflow to bring data from your cloud storage into Platform .