Configure an external database to import data from Marketing Cloud Intelligence Data Pipelines. You configure the database before creating a database export. The user whose credentials are used when connecting to the database must have INSERT and DELETE permissions for at least one table in the database.
- From your workspace settings, on the left window, click Workspace Integration.
- Select the Database tab.
- All database integrations appear here. To create an integration, click Add Integration.
- Select the vendor.
- Enter a name.
- Configure the connection details, including host, port, database, warehouse, role, and account.
- To use a connection string instead, click Or, and then enter the string used for the connection.
- Define the authentication details, including user, password, and if necessary, private key.
- Before you create the integration, check it to make sure that it works and is valid. At the top right-hand side of the page, click Validate Connection.
- If there are any errors, a red information icon appears that you can click to view more details. If the integration is valid, click Create.