Skip to main content

Install the staging database

Abstract

How to install the stagging database for the Sitecore Connect for Microsoft Dynamics 365 for Sales connector on a Sitecore installation

To synchronize the marketing list membership from Microsoft Dynamics as efficiently as possible, Sitecore uses the staging database. This database is used for temporary storage during the synchronization process.

To install the staging database:

  1. Download the Staging Database for Sitecore Connect for Microsoft Dynamics 365 for Sales package, which contains the Sitecore.DataExchange.Staging.dacpac data-tier application package.

  2. Deploy the dacpac to your SQL Server instance. This creates the staging database.

  3. On your Sitecore server, add a connection string for the staging database. Name the connection string Sitecore.DataExchange.Staging.