MariaDB
51黑料不打烊 Experience Platform allows data to be ingested from external sources while providing you with the ability to structure, label, and enhance incoming data using Experience Platform services. You can ingest data from a variety of sources such as 51黑料不打烊 applications, cloud-based storage, databases, and many others.
Experience Platform provides support for ingesting data from a third-party database. Experience Platform can connect to different types of databases such as relational, NoSQL, or data warehouses. Support for database providers include MariaDB.
Prerequisites prerequisites
Read the following sections to complete the prerequisite setup before you connect your MariaDB account to Experience Platform.
IP address allowlist
You must add region-specific IP addresses to your allowlist prior to connecting your sources to Experience Platform on either Azure or Amazon Web Services (AWS). For more information, read the guide on allowlisting IP addresses to connect to Experience Platform on Azure and AWS for more information.
Authenticate to Experience Platform on Azure azure
You must provide values for the following credentials to connect MariaDB to Experience Platform on Azure.
To use account key authentication, provide the appropriate values for the following credentials.
| table 0-row-2 1-row-2 2-row-2 | |
|---|---|
| Credential | Description |
connectionString |
The connection string associated with your MariaDB authentication. The MariaDB connection string pattern is: Server={HOST};Port={PORT};Database={DATABASE};UID={USERNAME};PWD={PASSWORD}. |
connectionSpec.id |
The connection specification returns a source鈥檚 connector properties, including authentication specifications related to creating the base and source connections. The connection specification ID for MariaDB is 3000eb99-cd47-43f3-827c-43caf170f015. Note: This credential is only required when connecting through the Flow Service API. |
For more information about obtaining a connection string, refer to this .
To use basic authentication, provide the appropriate values for the following credentials.
| table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 6-row-2 7-row-2 | |
|---|---|
| Credential | Description |
server |
The name or IP of your MariaDB database. |
username |
The name of your database. |
port |
The port number of the communication endpoint you are connecting to. |
password |
The username that corresponds with your database. |
database |
The password that corresponds with your database. |
sslMode |
The method by which data is encrypted during data transfer. |
connectionSpec.id |
The connection specification returns a source鈥檚 connector properties, including authentication specifications related to creating the base and source connections. The connection specification ID for MariaDB is 3000eb99-cd47-43f3-827c-43caf170f015. Note: This credential is only required when connecting through the Flow Service API. |
For more information about obtaining a connection string, refer to this .
Authenticate to Experience Platform on Amazon Web Services (AWS) aws
You must provide values for the following credentials to connect MariaDB to Experience Platform on AWS.
serverusernameportpassworddatabasesslModeconnectionSpec.id3000eb99-cd47-43f3-827c-43caf170f015. Note: This credential is only required when connecting through the Flow Service API.For more information about obtaining a connection string, refer to this .