---
schema_version: "1"
id: f836ce2986ee2d7d029a65414ba514c2b58205a900fecb37b8aa09f7872577da
title: Create a Database Export
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/dato_anlyz_export_create.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_anlyz_export_create.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: f39afd56c7443997916a707aa0f3d424e80c166196587ea9b97783f21da24d6d
description: Create a database export to export marketing data from Marketing Cloud Intelligence, 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.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Create a Database Export

Create a database export to export marketing data from Marketing Cloud Intelligence, 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.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d11181e38">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d11181e38 ">To create a database export:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d11181e38 ">Admin</td>

          </tr>
        </tbody>
      </table>

Before creating a database export, configure the database you’re connecting to. This is done in the Integrations tab. For more information see [Adding or Editing Database Integrations](https://help.salesforce.com/s/articleView?id=mktg.dato_anlyz_export_add_int.htm&release=264.0.0&type=5 "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.").

1. From the **Analyze & Act** tab, select **Database Exports**.
2. Click **Create New**.
3. Define the data that you want to export.
4. Map the source data fields to the destination database fields.
5. Configure the database export feed.
6. Save your work, and run the export.

Here’s a video about database exports:

- **[Define the Data to Export](https://help.salesforce.com/s/articleView?id=mktg.dato_anlyz_export_define.htm&release=264.0.0&type=5)**  
    Define the source dataset by selecting the dataset, required dimensions, and measurements and date range.
- **[Configure the Destination Database and Connect Data](https://help.salesforce.com/s/articleView?id=mktg.dato_anlyz_export_config_dest.htm&release=264.0.0&type=5)**  
    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](https://help.salesforce.com/s/articleView?id=mktg.dato_anlyz_export_config_feed.htm&release=264.0.0&type=5)**  
    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](https://help.salesforce.com/s/articleView?id=mktg.dato_anlyz_export_trouble.htm&release=264.0.0&type=5)**  
    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](https://help.salesforce.com/s/articleView?id=mktg.dato_anlyz_export_add_int.htm&release=264.0.0&type=5)**  
    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.