Treasury sFTP Integrations

Use sFTP for Treasury CSV and original file integrations. Set up and manage multiple Treasury sFTP accounts for your integrations from Coupa Core. You can also configure custom scheduling for integration runs.

Set up sFTP accounts for Treasury integrations

Setting up sFTP accounts for Treasury Management integrations is the same process as for Coupa Core. However, you can have multiple sFTP accounts for Treasury exports. This may help you if you have differing encryption or authentication needs for your integrations.

Create Treasury sFTP account
  1. In Coupa Core, navigate to Setup > Integrations > sFTP Accounts.
  2. In the Application field, select Treasury.
  3. Enter a username for this account. The screen shows you a preview with the account suffix based on your Coupa URL.
  4. Security and Encryption / sFTP Account Security, select an option:
    1. Username and Password: This option generates the password on the screen after you create the account.

    2. SSH Key opens a Choose File button. You can use this to upload a file with Secure Shell (SSH) keys for authentication, or you can generate SSH keys when you create the SFTP account.

  5. Select Create to complete the sFTP account setup. You see the password or masked SSH authentication keys, depending on your Security and Encryption option.
Figure 1.
Edit Treasury sFTP account
  1. From Setup > Integrations > sFTP Accounts, click the pencil icon for an account from the sFTP Account data table.
  2. In the Edit sFTP Account dialog, you can do the following:

    1. sFTP Authentication method: Regenerate password or upload a SSH file.

    2. Inbound File Encryption (optional): You can generate, download, and upload a public PGP key if you want to encrypt the exported files on the integration level. You enable PGP encryption by selecting Enable Encryption when you create or edit the integration.

  3. Select Save to update the account. You can view all edits by clicking the History toggle.

Figure 2.

For more information, see sFTP Account Management.

Manage Treasury integrations

Define settings for Treasury SFTP integrations:

  1. In Coupa Core, navigate to Setup > Integrations > Integrations.
  2. Locate the standard integration you want to manage and select the Edit icon.
    1. To Coupa indicates import (inbound) integrations. For inbound integrations, simply drop the file into the configured sFTP folder—no further action is required. For more information, see Standard Treasury CSV Imports.For inbound integrations, simply drop the file into the configured sFTP folder—no further action is required. For more information, see Standard Treasury CSV Imports.
    2. From Coupa indicates export (outbound) integrations. For more information on settings for export integrations, see Exports.

Exports

Use these guidelines when setting up all Treasury CSV and original file exports:

  • Always build your integrations using file headers instead of column positions, as positions are subject to change.
  • Exported data cannot exceed the supported limit of 150,000 rows.
  • For more information on the elements for the CSV exports, refer to the API documentation in the Treasury application. See View Treasury API Documentation.
Important:

All Treasury CSV exports contain the full set of fields that are available for integrations. The columns in the export are not configurable, which means that you cannot reorder or remove any attributes before the CSV file is exported.

From Setup > Integrations > Integrations, locate the standard integration that you want to manage in the table and click the pencil icon.

You can define the following settings for outbound integrations:

SettingDescription

End System Type

Type of system to consume the files.

End System

System to consume the files.

Enable Encryption

When enabled, exported files are PGP encrypted. Key can be maintained in sFTP account.

Enable Scheduler

Schedule for the profile.

Remove new line

When selected, removes new lines from your export. Available for CSV integrations only.

Remove carriage return

When selected, removes carriage returns from your export. Available for CSV integrations only.

Delimiter

Select a delimiter for your export. Available for CSV integrations only.

Delta filter

Select whether you want to include a delta filter for your recent changes in your export. Available for CSV integrations only.

Send file even if empty

When selected, exports an empty (zip) file if there is no data.

Send unzip file

When selected, exported files are unzipped. Available for original file integrations and classic table and classic statement exports.

Subfolder

Defines a subfolder for the export. The system automatically pluralizes the last segment of the folder name using a standard pluralization library. For example, if you enter a path like bankfile/PDF, the last segment is pluralized, resulting in bankfile/PDFS.

You see the subfolder path in the integration runs.

For more information, see Standard Treasury CSV Exports and Using the Flat File Format.

Self-service for Treasury export integrations

If you need export capabilities beyond the standard integrations, you can create custom export integrations using Automation Views or Automation Users that you configure in Treasury Management.

For more information, see Custom Treasury Exports.

Schedule Treasury export integration runs

You can customize the scheduling of your export integrations. Use the scheduler with integrated Cron settings to configure specific delivery times and dates for all Treasury outbound integrations.

Figure 3.

After you save an integration, you schedule integration runs from the Integrations data table. To schedule integration runs, use the following steps:

  1. Use the pencil icon to open and edit the integration from the data table.
  2. In the Edit dialog, activate Enable Scheduler.
  3. For Schedule Mode, select an option:
    1. Simple Interval is selected by default, and is sufficient for configuring intervals up to once a day. Select values from dropdown to set the interval for your runs.
    2. Advanced Cron opens the Cron Expression field. Use this to set integrations run that don't run every day, for example once a week. Enter values to represent the delivery time, date, and frequency. The Schedule Preview guides your input, and shows any errors and your configured interval before you save.
  4. Save your configuration.

For more information, see Manage Treasury integrations.