Source connectors in Adobe Experience Platform provide the ability to ingest externally sourced data on a scheduled basis. This tutorial provides steps for creating a PostgreSQL source connector using the Platform user interface.
This tutorial requires a working understanding of the following components of Adobe Experience Platform:
If you already have a valid PostgreSQL connection, you may skip the remainder of this document and proceed to the tutorial on configuring a dataflow.
In order to access your PostgreSQL account on Platform, you must provide the following value:
|The connection string associated with your PostgreSQL account. The PostgreSQL connection string pattern is:
For more information about getting started, refer to this PostgreSQL document.
You can enable SSL encryption for your PostgreSQL connection string by appending your connection string with the following properties:
|Allows you to enable SSL encryption on your PostgreSQL data.
|Validates certificate sent by your PostgreSQL database when
EncryptionMethod is applied.
The following is an example of a PostgreSQL connection string appended with SSL encryption:
Once you have gathered your required credentials, you can follow the steps below to link your PostgreSQL account to Platform.
Log in to Adobe Experience Platform and then select Sources from the left navigation bar to access the Sources workspace. The Catalog screen displays a variety of sources for which you can create an account with.
You can select the appropriate category from the catalog on the left-hand side of your screen. Alternatively, you can find the specific source you wish to work with using the search option.
Under the Databases category, select PostgreSQL DB. If this is your first time using this connector, select Configure. Otherwise, select Add data to create a new PostgreSQL connector.
The Connect to PostgreSQL page appears. On this page, you can either use new credentials or existing credentials.
If you are using new credentials, select New account. On the input form that appears, provide a name, an optional description, and your PostgreSQL credentials. When finished, select Connect and then allow some time for the new connection to establish.
To connect an existing account, select the PostgreSQL account you want to connect with, then select Next to proceed.
By following this tutorial, you have established a connection to your PostgreSQL account. You can now continue on to the next tutorial and configure a dataflow to bring data into Platform.