---
schema_version: "1"
id: 47189ac770fa9ff9714c23cf7f7d17b2623b06bd00b946bab7bd36deff633e60
title: Configure the Database Export Feed
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_feed.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_anlyz_export_config_feed.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: b82956369b5139ff53fac5a6365116fde118d82ec97b16cfe69af42a4b1bfff2
description: 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.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# 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.

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

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

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

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 **Configure Feed**.
4. In the **Load Mode** section, select how you want to load new data into the database.
    
    <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small "><tbody><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Upsert</strong></td><td class="slds-cell-wrap">Update and Insert. Existing records are updated if they exist in the destination table based on a combination of fields defined as upsert keys. If they don’t exist, they’re inserted as new records.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Incremental</strong></td><td class="slds-cell-wrap">All new data is incremented into the database and added to the existing data.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Total Replace</strong></td><td class="slds-cell-wrap">Every time new data is updated, it replaces all the data in the database table.</td></tr></tbody></table>
5. In the **Trigger** section, define when to execute the export. For example, set a daily frequency, and then set a time. For example, you can have the data update every day at 8:00 AM.
6. If you want to apply advanced settings on the export, in the **Advanced** section, set the export type.
    
    <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small "><tbody><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Entire dataset</strong></td><td class="slds-cell-wrap">Exports the entire dataset as one report.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Partitioning</strong></td><td class="slds-cell-wrap">Exports the dataset into separate reports. If you select this option, set the division by day, week, month, and so on.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Replace empty values</strong></td><td class="slds-cell-wrap">Replace empty values with a set value, then enter a value. For example, replace all empty values with the word NULL. All empty values are replaced, no matter if they’re dimensions or measurements.</td></tr></tbody></table>
7. Define how to display unrelated measurements. For more information, see [Unrelated Measurements in Data Reports](https://help.salesforce.com/s/articleView?id=mktg.dato_anlyz_reports_data_unrelated.htm&release=264.0.0&type=5 "When you query entities from different data types with different measurements that are unlinked in the platform, unrelated measurements appear in your report. For example, a report pulling Ads data— Impressions and a measurement that isn’t in the Ads data type—visits, results in unrelated measurements in your report.").
8. To delete the report history after a specified time, set the **Purge Report History Days** and then enter a value. For example, if you enter 30, the report’s history is deleted after 30 days.
9. To create the database export, click **Create**.
10. To create the database export and run the export, click **Create & Run**.