---
schema_version: "1"
id: e0d3872770f3839eef9ea3f4562a279fe73063e3e87269d0714903cae3f25e51
title: Configure the Destination Database and Connect Data
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/dato_anlyz_export_config_dest.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_anlyz_export_config_dest.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 28dbd4559089596d32818263679a237ec82e288ea128e9108645811e44d2b86e
description: 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.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# 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.

### 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="d10370e38">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d10370e38 ">To create a database export:</td>

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

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

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.").

After you connect to the database, map the fields from your source data to the database fields to ensure that the data is connected properly.

1. From the **Analyze & Act** tab, select **Database Exports**.
2. Create a database export, or edit one.
3. At the bottom of the page, select **Map to Destination**.
4. In the **Destination Database** area, select the database that you’re exporting to.
5. After you connect to a database, all tables in the database that the user has INSERT and DELETE permissions for are available for selection.
6. Select the table that you’re connecting to. After you select a table, all available fields appear in the **Mapping** area farther down the page. The fields change according to the table that you select.
7. In the **Mapping** area, map fields from the dataset to the required field in the database. For example, map the measurement Website Clicks to Clicks.
8. Repeat this step for all dimensions and measurements that you want to map.
9. To move onto the next step, click **Next**.