Export data from Marketing Cloud Intelligence Data Pipelines, and connect it to an enterprise database such as Snowflake and PostgreSQL. With Database Exports, automate the export of MDP marketing data. Enhance enterprise-wide analytics by making marketing insights accessible, and get a full view of your company’s data.
- Create a Database Export
Create a database export to export marketing data from Marketing Cloud Intelligence Data Pipelines, and import it to an external database. Select the criteria that you want to export, define scheduling to determine when the export occurs, and map the source data fields to the database fields. - Define the Data to Export
Define the source dataset by selecting the dataset, required dimensions, and measurements and date range. - Configure the Destination Database and Connect Data
Set the external database where you’re exporting the data to. Databases are configured in Workspace Integrations. Configure the database first, and then you can select it. - Configure the Database Export Feed
After you connect to the database and map your fields, configure how the exported data is inserted into your database table and how often to execute the export. This step defines what happens when new data is loaded into the database and how to handle it. - Troubleshoot Database Exports
After a database export is created, view and manage exports execution in the History tab. If an export fails, troubleshoot to find out what happened. You can download a report, and even rerun or reprocess it. - Adding or Editing Database Integrations
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.