Loading...

Native and standard setup - Cloud storage or SFTP connector

This page provides information about upstream integration options for Native and Standard - Cloud Storage or SFTP Connector.
To perform upstream 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.

Native CDP-hosted setup

Creating an instance

  1. Sign in to the CDP user interface.
  2. Click Integrations > Instances.
  3. Click Add Instance.

    The system displays the Create Instance page.

  4. In Name, enter the name for your instance.
  5. In Instance Type, select the preferred instance type.

    The system displays additional fields depending on the instance type.

  6. Click Save.

    The system auto-populates values in the fields in the Instance Credentials section.

  7. Copy the credentials from each field by clicking the square icon at the right of the field.

Creating Acquia CDP-hosted SFTP instance

To create an instance that you want to associate with an SFTP destination connector:

  1. Navigate to the Create Instance page.
  2. In Name, enter the name for your instance.
  3. In Instance Type, select SFTP Service Provision.
  4. In Allow-List Source IP Addresses, add the comma-separated IP addresses that can access the SFTP location.

    You can add a maximum of 10 IP addresses. By default, CDP does not provide access to the SFTP location.

    The following are the criteria to allowlist IP addresses:

    • Private IP addresses are not allowed. For example, 10.0.0.0 - 10.255.255.255, 172.16.0.0 - 172.31.255.255, 192.168.0.0 - 192.168.255.255
    • Domain and IP range is not allowed.
    • Subnet masks must not be less than 22. For example, xx.yyy.0.0/22.
    • IPv6 addresses are not allowed.

    For more information on allowlisting IP addresses, see Allowlisting IP addresses.

  5. Click Save.

    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.

  6. Take a backup of these credentials at a secure location as you cannot view them in the system again.

Standard setup

Creating a new SFTP connector

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.

Verifying the standard connector in input connectors

  1. Click Integrations > Input Connectors.

    Professional Service or Acquia Support saves the input connector in either the Published or Ready state.

  2. To view the connector, select it from the list and use it for further processing.

Updating the parameters to an existing connector

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.

ParameterValuesExampleDescription
filename.date.formatDate formatYYYY-MM-DDDate format that is appended to the end of the file name.
date.column.date.format

Date format

Default: epoch timestamp

YYYY-MM-DDDatetime 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_EXTENSIONFile 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.

Back to Section navigation