This page provides information about how to add and view input connectors for the following scenario:
Data engineers and IT professionals want to monitor all the downstream integrations from CDP to any channel through source system APIs or SFTP. They also want to create a new downstream connector for Email Service Provider channels such as Salesforce Marketing Cloud.
Creating SFTP CSV connectors
You can create the following SFTP CSV connectors:
- SFTP External
- SFTP CDP
- Sign in to the CDP user interface.
- Click Integrations > Output Connectors.
Click Add Integration.
- To create an external connector that you want to associate with the CDP SFTP connector:
- On the Add Integration page, select SFTP CSV Connector and click Next.
- Specify the name and description for the connector, and click Next.
- Select SFTP External.
Enter the appropriate value for Host URL and Port Number.
In the Account Verification Method, specify your username and password. Alternatively, enter the private SSH key to access the SFTP instance.
The private SSH key must be in the RSA format and not in the OpenSSH format. Ensure that it is a 4096-bit PEM file and does not have a passphrase or password. A 2048 bits file is acceptable but a 4096 bits file is preferred.
The following is the structure of the private key:
1 -----BEGIN RSA PRIVATE KEY----- 2 cdopsdsoFsjasoizx (a long paragraph of random letters) 3 -----END RSA PRIVATE KEY----
- To test the connection with the FTP instance, click Test Connection.
- Click Next.
- In Basic Parameters, do the following:
- Select a delimiter from the available options.
- Specify whether you want to include the executionID column in the output file.
Select a date and time format from the available options.
- In Advanced Parameters, do the following:
- Specify whether you want to use a non-traditional CSV format.
- Select a date and time format for the output file name.
- Define whether you want to enable PGP encryption to your output file. If yes, then enter the PGP public key.
Specify the extension for non-CSV format output files.
Click Save.
The system saves the output connector in the
Unpublished
state.To publish the connector, Click Publish.
The system saves the output connector in the
Active
state. You can use the connector for further processing.
To create an SFTP CDP connector:
To use SFTP CDP, you must create an SFTP Instance.
On the Add Integration page, select SFTP CSV Connector and click Next.
Specify the name and description for the connector, and click Next.
Select SFTP CDP.
In Instance Name, select an instance and click Next.
- In Basic Parameters, do the following:
- Select a delimiter from the available options.
- Specify whether you want to include the executionID column in the output file.
- Select a date and time format from the available options.
- In Advanced Parameters, do the following:
- Specify whether you want to use a non-traditional CSV format.
- Select a date and time format for the output file name.
- Define whether you want to enable PGP encryption to your output file. If yes, then enter the PGP public key.
- Specify the extension for non-CSV format output files.
Click Save.
The system saves the output connector in the
Unpublished
state.To publish the connector, Click Publish.
The system saves the output connector in the
Active
state. You can use the connector for further processing.
Creating an ExactTarget email connector
To create an ExactTarget Email output connector:
- Sign in to the CDP user interface.
- Click Integrations > Output Connectors.
- Click Add Integration.
- On the Add Integration page, select ExactTarget Email Connector and click Next.
- Specify the name and description for the connector, and click Next.
- In API User Name, specify the user name to access the ExactTarget APIs.
- In API Password, specify the password to access the ExactTarget APIs.
- In FTP URL, specify the URL to access the FTP instance.
- In FTP User Name, specify the user name to access the FTP instance.
- In FTP Password, specify the password to access the FTP instance.
To test the connection with the FTP instance, click Test Connection.
Click Save.
The system saves the output connector in the
Unpublished
state.To publish the connector, Click Publish.
The system saves the output connector in the
Active
state. You can use the connector for further processing.
Creating an S3 output connector
To create an S3 AWS output connector:
- Sign in to the CDP user interface.
- Click Integrations > Output Connectors.
- Click Add Integration.
- On the Add Integration page, select S3 Output Connector and click Next.
- Specify the name and description for the connector, and click Next.
Select S3 External.
- In AWS S3 Bucket Name, specify the name of your S3 bucket.
- In AWS S3 Bucket Folder Name, specify the folder name that contains your S3 bucket.
- In AWS Access Key, specify your AWS access key.
- In AWS Secret Key, specify your AWS secret key.
- To test the connection with the external S3 instance, click Test Connection.
- Click Next.
- In Basic Parameters, do the following:
- Select a delimiter from the available options.
- Define whether you want to enable AWS server side encryption.
Select a date and time format from the available options.
- In Advanced Parameters, do the following:
- Select a date and time format for the output file name.
- Define whether you want to enable PGP encryption to your output file.
- Specify the file extension for non-CSV format output files.
Define whether you want to split your output file. If you select Yes, specify the number of parts in which you want to split the file.
Click Save.
The system saves the output connector in the
Unpublished
state.To publish the connector, click Publish.
The system saves the output connector in the
Active
state. You can use the connector for further processing.
Creating a Google Customer Match connector
To configure a Google Customer Match output connector:
- Sign in to the CDP user interface.
- Click Integrations > Output Connectors.
- Click Add Integration.
- On the Add Integration page, select Google Customer Match Connector and click Next.
- Specify the name and description for the connector, and click Next.
- In Manager Developer Token, specify the manager developer token.
- In Manager Oauth Client Id, specify the Oauth client ID.
- In Manager Oauth Client Secret, specify the Oauth client secret.
- In Manager Oauth Refresh Token, specify the Oauth refresh token that is used to renew Oauth access.
- In Customer Ad account Id, specify your unique number that is assigned to your Google Ads account.
To test the connection with the FTP instance, click Test Connection.
- Click Save.
- To get this connector published, contact Acquia Support.
Using output connectors
To use the output connectors:
- Sign in to the CDP user interface.
- Click Actions > Campaigns+ and create a campaign.
- Access the Destinations tab, search for the destination name, and select the destination for your campaign.
Deleting output connectors
To delete an output connector:
- Sign in to the CDP user interface.
- Click Integrations > Output Connectors.
Click the name of the connector that you want to delete.
Click Actions > Delete.
The system displays the Delete Connector dialog box.
In the Delete Connector dialog box, click Delete Connector.