User Guide – Daily Use

Selecting tables and fields

Once the connections to the App Registration, Storage Account, and SQL Database have been verified, you can define which Business Central data should be synchronized.

To access the setup page, search for “Data Warehouse Connector Setup”.

In the Tables section:

  • Select Add to include new tables for export
  • Use Choose fields to specify exactly which fields should be synchronized

This approach ensures that only relevant and necessary data is exported, supporting data governance and efficient reporting.
When you are satisfied with the table and field configuration, select Export and/or configure a Scheduled export.

Scheduled export

The Scheduled export feature allows you to define how frequently data is automatically updated.

To change the schedule:

  1. Select Set on hold to unlock the job queue parameters
  2. Adjust the desired frequency and settings
  3. Set the status back to Set Status to Ready


This ensures regular, automated data updates without manual intervention.

Manual export

To perform a one-time data refresh, select Export.

A manual export does not affect the scheduled export configuration. It is intended for ad hoc updates, for example after period close or structural changes.

In the Tables overview, two fields provide transparency into data freshness:

  • Last Checked At – when the data was last validated
  • Last Exported At – when the data was last successfully transferred

Advanced options

Checksum on tables
You can select a Decimal field in a table to be used as a checksum.
When enabled, the Data Warehouse Connector validates both the record count and the checksum value.

This provides a layer of data verification.

Exporting custom schema name
You may define a custom schema name for tables in your data warehouse. The default schema is [dbo], matching the standard Business Central database structure.