BeyondERP.Newsletter
Menu

Setup step on the Channel database page · Retail and Commerce

Set up Channel database

Use this page to create channel database records, map stores and online channels to them, optionally set a data sync interval, and start a full data sync of a distribution schedule (for example 9999 or 1040) to a selected database.

Used by
Retail operations manager, Retail service, Retail store IT and 1 more role
Business process
Manage sales channels
Menu item
RetailCDXDataStore
Main table
RetailConnDatabaseProfile
Data entity
RetailConnDatabaseProfileEntity
Setup steps
1 on this page
Show what matters for
SETUP GUIDEHow to set it up8 sections. Choose a role to highlight what matters to you.
Everyone

1What it is and why

What it isA setup page where each physical channel database (cloud or self-hosted Commerce Scale Unit) and each Store Commerce offline database is registered, assigned to a channel database group and linked to the channels it serves.
What you do hereUse this page to create channel database records, map stores and online channels to them, optionally set a data sync interval, and start a full data sync of a distribution schedule (for example 9999 or 1040) to a selected database.
ExampleFor example, after adding the online store channels to the Commerce Scale Unit's channel database you run Full data sync with job 9999 so the channel receives all data.
Channel database page in Dynamics 365
The page in Dynamics 365. page title tab to open what to set or check
Functional consultant · Solution architect

2Where it fits

End user · Functional consultant

3How to do it

About the examples: Examples and screenshots in this guide use BEAT, a demo company in a Dynamics 365 test environment. Use your own company's codes and values instead of copying them.

Setup steps on this page

Set up Channel database

Use this page to create channel database records, map stores and online channels to them, optionally set a data sync interval, and start a full data sync of a distribution schedule (for example 9999 or 1040) to a selected database.

Steps from Microsoft

  1. Go to Retail and Commerce > Headquarters setup > Commerce scheduler > Channel database.
  2. On the action pane, select New.
  3. In the Channel database ID field, enter a unique value.
  4. In the Channel data group field, select the group (for example Default) and leave Type as Channel database.
  5. Optionally select a Data sync interval.
  6. On the Retail channel FastTab, select Add and pick each channel that uses this database.
  7. Select Save, and confirm the Mapping a New Retail Channel warning if it appears.

Source: Microsoft Learn

Fields on the page

FieldWhat it meansTable column
Channel database IDUnique identifier of the physical database.Microsoft Learn Name
Channel data groupThe channel database group this database belongs to.Microsoft Learn
TypeWhether the record is a channel database or an offline database.Microsoft Learn DataStoreType
Data sync intervalHow often data is synchronized between this channel database and headquarters; blank uses the CSU default of three minutes.Microsoft Learn
Retail channel (Channel)The stores and online channels whose data is held in this database.Microsoft Learn
Username (Case Sensitive) / PasswordCredentials used to connect to an AX 2012 R3 channel database in N-1 setups.Microsoft Learn
Database name / Server nameName and host server of an AX 2012 R3 channel database in N-1 setups.Microsoft Learn

Test checklist

  1. Create the record, select its channel database group and add the stores on the Retail channel FastTab.
  2. Leave Data sync interval blank to use the three-minute default, or set your own.
  3. Select Full data sync, choose job 9999 and confirm.
  4. On Download sessions check every session for the database reaches the applied state.

Source: Microsoft Learn

Functional consultant

4Setup decisions

Setup stepRecommended value and whyDecision, common mistake and test
Set up Channel databaseOne record per physical database, linked to a channel database group, with its stores on the Retail channel FastTab, followed by a full data sync of job 9999Learn says each record maps 1:1 to a physical database and must belong to a group, and uses Full data sync with 9999 to prepare all data for a new channel database.Leaving the old default database in the Default data group after moving stores to a self-hosted scale unit. Learn says this can cause data sync errors later.
Solution architect

5Design impact

Can it be undoneReversible: Channel mappings and the group can be changed; a full data sync rebuilds the database content.
If you change it laterA full data sync started from this page can only be run once (no recurrence), and if a job excluded from offline databases is fully synced the matching offline tables are emptied. Microsoft Learn
Technical architect

6Technical

Menu itemRetailCDXDataStore Checked in Dynamics 365
FormRetailCDXDataStore Checked in Dynamics 365
TableRetailConnDatabaseProfileShown as “DATABASE CONNECTION PROFILE” in Record infoKey field: NameChecked in Dynamics 365
Data entitiesRetailConnDatabaseProfileEntityDatabase connection profile Checked in Dynamics 365
Who can open itPrivilegesMaintain Retail Commerce Data Exchange RetailCDXMaintainDutiesManage Commerce Data Exchange: Synch Service RetailCDXMaintain
4 security rolesRetail operations manager RetailOperationsManagerRetail service RetailServiceRetail store IT RetailStoreITRetail store manager RetailStoreManager
Checked in Dynamics 365
Roles to set it up and use itTo set it up or change itRetail service RetailServiceRetail operations manager RetailOperationsManagerRetail store manager RetailStoreManagerRetail store IT RetailStoreITGive people one of these roles. On this system, 4 roles can open this page.Checked in Dynamics 365
Actions on the pageDownload: DownloadData sessions: Data sessions(Action Pane without tabs): Full data syncChecked in Dynamics 365
Developer

7Developer

Open it by URLhttps://<your-environment>/?mi=RetailCDXDataStore
Integrate withRetailConnDatabaseProfileEntity data entity Checked in Dynamics 365
Table definitionRetailConnDatabaseProfile columns and relations Microsoft data model
Everyone

8Sources

To cite this step: RC-CDX-060, Set up Channel database. Beyond ERP Atlas Hub, 2026-11-11. https://www.beyonderp.cloud/atlas/step/RC-CDX-060