To use an SFTP location, you must select the SFTP Output option on the Select Channel screen:
To add a new SFTP connector, send a request to Support or your customer value manager (CVM), and provide the following information:
Connector name such as “SFTP - Monetate”
Host name such as “sftp1.agilone.com
Username
Password
IP address to allowlist if applicable
You can use a key-based authentication instead of a password-based authentication by providing Customer Data Platform (CDP) with a private .pem SSH key. The keys must not have passphrases.
You can change the following parameters by sending a request to Support. The changes apply to all files that are exported to that connector going forward.
Parameter | Values | Example | Description |
|---|---|---|---|
filename.date.format | Date format | YYYY-MM-DD | Date format that is appended to the end of the file name. |
date.column.date.format | Date format Default: epoch timestamp | YYYY-MM-DD | Datetime format that is used when the output columns are dates. For example, first transaction date. |
date.column.date.format.timezone | Time zones Default: UTC | – | Timezone that is used when the output columns are dates. For example, first transaction date. |
pgp.public.key | PGP public key Default: none | – | Public encryption key if the output file should be encrypted. |
exclude.execution.id | true or false Default: false | – | This determines whether the executionID column is included at the end of the output CSV file. |
output.file.extension | File extension Default: csv | csv, tsv, txt, or NO_EXTENSION | File extension |
sftp.delimiter | Comma, pipe, tab, etc. Default: comma | – | The delimiter to use to separate fields within a row. Use a single ASCII character to delimit data. |
If this content did not answer your questions, try searching or contacting our support team for further assistance.
To use an SFTP location, you must select the SFTP Output option on the Select Channel screen:
To add a new SFTP connector, send a request to Support or your customer value manager (CVM), and provide the following information:
Connector name such as “SFTP - Monetate”
Host name such as “sftp1.agilone.com
Username
Password
IP address to allowlist if applicable
You can use a key-based authentication instead of a password-based authentication by providing Customer Data Platform (CDP) with a private .pem SSH key. The keys must not have passphrases.
You can change the following parameters by sending a request to Support. The changes apply to all files that are exported to that connector going forward.
Parameter | Values | Example | Description |
|---|---|---|---|
filename.date.format | Date format | YYYY-MM-DD | Date format that is appended to the end of the file name. |
date.column.date.format | Date format Default: epoch timestamp | YYYY-MM-DD | Datetime format that is used when the output columns are dates. For example, first transaction date. |
date.column.date.format.timezone | Time zones Default: UTC | – | Timezone that is used when the output columns are dates. For example, first transaction date. |
pgp.public.key | PGP public key Default: none | – | Public encryption key if the output file should be encrypted. |
exclude.execution.id | true or false Default: false | – | This determines whether the executionID column is included at the end of the output CSV file. |
output.file.extension | File extension Default: csv | csv, tsv, txt, or NO_EXTENSION | File extension |
sftp.delimiter | Comma, pipe, tab, etc. Default: comma | – | The delimiter to use to separate fields within a row. Use a single ASCII character to delimit data. |
If this content did not answer your questions, try searching or contacting our support team for further assistance.
Acquia CDP