Before creating a database export, configure an external database to import data from
Marketing Cloud Intelligence. The database user requires INSERT and DELETE permissions for at
least one table. Capitalize the table name for Snowflake databases to avoid connection
failures.
Required Editions
| User Permissions Needed |
| To add or edit database integrations: |
Admin |
-
From your workspace settings, on the left window, click
Integrations.
-
Select the Database tab.
-
All database integrations appear here. To create an integration, click Create
New 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.
