Connect MySQL to Experience Platform using the UI
Read this guide to learn how to connect your MySQL 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 MySQL connection, you may skip the remainder of this document and proceed to the tutorial on configuring a dataflow.
Gather required credentials
Read the MySQL overview for information on authentication.
Navigate the sources catalog
In the Experience Platform UI, select Sources from the left navigation to access the Sources workspace. Choose a category or use the search bar to find your source.
To connect to MySQL, go to the Databases category, select the MySQL source card, and then select Set up.
Use an existing account existing
To use an existing account, select Existing account and then select the MySQL account that you want to use.
Create a new account new
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 azure
You can connect your MySQL database to Experience Platform on Azure using either account key or basic authentication.
To use account key authentication, select Account key authentication, provide your connection string, and then select Connect to source.
To use basic authentication, select Basic authentication, provide values for your authentication credentials, and then select Connect to source.
Connect to Experience Platform on Amazon Web Services (AWS) aws
To create a new MySQL 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 MySQL data
Now that you have successfully connected your MySQL database, you can now create a dataflow and ingest data from your database into Experience Platform.