This page provides information about downstream integration options for SFTP connectors. To perform downstream integration with Secure File Transfer Protocol (SFTP) connectors, consider the following options:
The native setup by Acquia
The standard setup
Capabilities
Native setup -Create a fully managed Acquia CDP-hosted connector to push data by directly dropping files that adhere to structure policies into the CDP system.
Standard setup - Create a pull connector to transfer your data through your own SFTP with support from Acquia Support or Professional Services and ensure alignment with file structure policies.
This page provides information about how to integrate upstream using Native and Standard - Cloud Storage or SFTP Connector options.
The system creates the instance and auto-populates values in the following fields:
SFTP URL Domain
SFTP Port
Username
Password
The password generated at the time of provisioning is displayed once and is not visible after you navigate away from this page or reload your screen. To reset your password, click Re-generate Credentials.
Take a backup of these credentials at a secure location as you cannot view them in the system again.
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.
Important consideration
To implement SFTP native integration, Customer Data Platform (CDP) provides up to 20 connectors along with automatic user account generation.
Native and standard setup - Cloud storage or SFTP connector
This page provides information about downstream integration options for SFTP connectors. To perform downstream integration with Secure File Transfer Protocol (SFTP) connectors, consider the following options:
The native setup by Acquia
The standard setup
Capabilities
Native setup -Create a fully managed Acquia CDP-hosted connector to push data by directly dropping files that adhere to structure policies into the CDP system.
Standard setup - Create a pull connector to transfer your data through your own SFTP with support from Acquia Support or Professional Services and ensure alignment with file structure policies.
This page provides information about how to integrate upstream using Native and Standard - Cloud Storage or SFTP Connector options.
The system creates the instance and auto-populates values in the following fields:
SFTP URL Domain
SFTP Port
Username
Password
The password generated at the time of provisioning is displayed once and is not visible after you navigate away from this page or reload your screen. To reset your password, click Re-generate Credentials.
Take a backup of these credentials at a secure location as you cannot view them in the system again.
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.
Important consideration
To implement SFTP native integration, Customer Data Platform (CDP) provides up to 20 connectors along with automatic user account generation.
Did not find what you were looking for?
If this content did not answer your questions, try searching or contacting our support team for further assistance.
Did not find what you were looking for?
If this content did not answer your questions, try searching or contacting our support team for further assistance.