Connect PostgreSQL to Experience Platform using the UI

Read this guide to learn how to connect your PostgreSQL database to Adobe Experience Platform using the sources workspace in the Experience Platform user interface.

Getting started

This tutorial requires a working understanding of the following components of Adobe Experience Platform:

• Experience Data Model (XDM) System: The standardized framework by which Experience Platform organizes customer experience data.
  • Basics of schema composition: Learn about the basic building blocks of XDM schemas, including key principles and best practices in schema composition.
  • Schema Editor tutorial: Learn how to create custom schemas using the Schema Editor UI.
• Real-Time Customer Profile: Provides a unified, real-time consumer profile based on aggregated data from multiple sources.

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.

Gather required credentials

Read the PostgreSQL overview for more information on authentication.

Enable SSL encryption for your connection string

You can enable SSL encryption for your PostgreSQL connection string by appending your connection string with the following properties:

The following is an example of a PostgreSQL connection string appended with SSL encryption: Server={SERVER};Database={DATABASE};Port={PORT};UID={USERNAME};Password={PASSWORD};EncryptionMethod=1;ValidateServerCertificate=1.

Navigate the sources catalog

In the Experience Platform UI, select Sources from the left navigation to access the Sources workspace. Select the appropriate category in the Categories panel Alternatively, use the search bar to navigate to the specific source that you want to use.

To use PostgreSQL, select the PostgreSQL DB source card under Databases and then select Set up.

Use an existing account

To use an existing account, select Existing account and then select the PostgreSQL account that you want to use.

Create a new account

If you do not have an existing account, then you must create a new account by providing the necessary authentication credentials that correspond with your source.

To create a new account, select New account and then provide a name and optionally add a description for your account.

Connect to Experience Platform on Azure

You can connect your PostgreSQL account to Experience Platform on Azure using either account key or basic authentication.

Connect to Experience Platform on Amazon Web Services (AWS)

To create a new PostgreSQL account and connect to Experience Platform on AWS, ensure that you are in a VA6 sandbox and then provide the necessary credentials for authentication.

Create a dataflow for your PostgreSQL data

By following this tutorial, you have established a connection to your MariaDB account. You can now continue on to the next tutorial and configure a dataflow to bring data into Experience Platform.