Data Sink Tab

The Data Sink tab shows information about the data sink for the current Job.

• The Data Sink Location dropdown list defines the data sink type. The following options are available:
  • None (default)
  • Attachment
  • FTP
  • SFTP
  • HTTP
  • Email
  • Database (not used for Export Jobs)
  • Digital (Salesforce B2C Commerce)

  Selecting a location from the dropdown refreshes the page with fields appropriate to that location.

• The following table describes the fields appropriate to each location.

  Data Sink location	Fields
  Attachment	These fields define the location and treatment of the export data files. The path can be specified as part of the filename or as part of the external file URL (server address), but not both. Filename: Define the data filename pattern that the export job creates, including the path if needed. Use .NET-style string formatting to define the pattern. Datetimes (for example, {0:YYYYMMdd}), *, and ? are supported wildcards). The following options are available: UniqueID: This functionality is deprecated. TimeStamp: A text field containing the filename pattern appears. The default pattern is ImportFile{0:yyyyMMdd}.csv. Custom: A text field containing the filename pattern appears. The default pattern is ImportFile.csv. Compression: To use ZIP compression on the export file, check the ZIP Compressed box.
  FTP/ SFTP/ HTTP/ Digital	These fields define the location and treatment of the export data files. The path can be specified as part of the filename or as part of the external file URL (server address), but not both. Filename: Define the data filename pattern that the export job creates, including the path if needed. Use .NET-style string formatting to define the pattern. Datetimes (for example, {0:YYYYMMdd}), *, and ? are supported wildcards). The following options are available: UniqueID: This functionality is deprecated. TimeStamp: A text field containing the filename pattern appears. The default pattern is ImportFile{0:yyyyMMdd}.csv. Custom: A text field containing the filename pattern appears. The default pattern is ImportFile.csv. Compression: To use ZIP compression on the export file, check the ZIP Compressed box. External File Destination: (FTP/ SFTP/ HTTP only) Enter the file location URL and the user credentials for accessing that location. If you included the path in the Filename field, then you only need the server address in the URL field. If you selected UniqueID as the Filename type, include the path and filename in the URL. If the location type is FTP, you can check the Passive box to use Passive FTP. Environment: (B2C Commerce only) Select Production or Stage to set the destination environment. The default is Production.
  Database	This selection isn't used for Data Sinks.

• A Format dropdown list appears with the following options:
  • CSV
  • XML
  • Dataset
  In general, only use CSV files. The following settings are available when CSV is selected:
  • Field separator: Select the character used to separate the data fields. The following choices are available:
    • Comma (default selection)
    • Tab
    • Other (enter the desired separator character in the text box)
  • First row contains field names: Check this box if you want the first row in the data export to contain column headings/ field names.

Navigate to the Scheduling Jobs Topic for more information on scheduling and configuring jobs.