Create an Oracle DB source connection in the UI
Read this guide to learn how to connect your Oracle DB instance to ÃÛ¶¹ÊÓƵ 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 ÃÛ¶¹ÊÓƵ 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 an Oracle DB connection, you may skip the remainder of this document and proceed to the tutorial on configuring a dataflow.
Gather required credentials
Read the Oracle DB 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 Oracle DB, go to the Databases category, select the Oracle DB source card, and then select Set up.
Use an existing account existing
To use an existing account, select Existing account and then select the Oracle DB 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 Oracle DB database to Experience Platform on Azure using a connection string.
To use connection string authentication, provide your connection string and select Connect to source.
Connect to Experience Platform on Amazon Web Services (AWS) aws
To create a new Oracle DB 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 Oracle DB data
Now that you have successfully connected your Oracle DB database, you can now create a dataflow and ingest data from your database into Experience Platform.