Export data from Business Central to any Azure SQL database
Enable efficient data replication from Business Central to an Azure SQL Database without throttling core ERP operations. Maintain operational stability and power advanced Business Intelligence reporting and analytics.
- Get started quickly
- No code setup
- Data stays in your tenant
Access your Business Central data for any ETL or datamodeling job needed
The Data Warehouse Connector App allows you to export the tables and fields from the Dynamics 365 Business Central database into an Azure SQL database of your choice.
This gives you full access to your Business Central data for Business Intelligence purposes, integration purposes or any ETL processes needed for other data warehouses or business applications. No APIs, no Synapse Pipelines, no AL-development or black-box data-remodeling required. Just raw Business Central data directly into SQL tables.
Get started quickly
360° business view
A simple and intuitive setup inside Business Central makes onboarding fast.
Download the App from AppSource and follow our quick guide to install and connect to your Azure SQL database.
A Job Queue Task manages incremental exports of all inserts, updates and deletes according to a schedule set by you. Ensuring that the SQL Data Warehouse database tables always match the corresponding Business Central SQL database tables.
Speed
100% data sovereignty
Incremental exports of all inserts, updates and deletes. The solution supports throughput of 100k rows per minute (at entry level Azure SQL production service-tiers). You control the data warehouse size and load by deciding how many tables and fields to export.
Metadata (table definitions and indexes) are automatically maintained in the SQL database by the App.
Security
90% faster reporting
The business data never leaves your tenant. It is exported directly from your Business Central service, through a BLOB-storage in your tenant (which you control) to an Azure-SQL Database (also within your tenant and under your control). This ensures that you maintain complete authority over the data access from the moment it leaves Business Central.
Consistensy
Unlimited growth
The Data Warehouse Connector App makes the setup of tables easy and handles the export-schedule for you. It validates for consistency of the data warehouse tables compared to your Business Central tables by using rowcounts and calculating checksums.
How the Data Warehouse Connector works
The Data Warehouse Connector replicates Business Central data to an Azure SQL inside your own tenant, with no third-party storage and no middleware.
- Your data stays within your own tenant
- Automatic and fast incremental updates
- Get started quickly
- No throttling
- Real schema replication
- Secure in-tenant operation
Trusted by technical teams across industries
Technical teams rely on the Data Warehouse Connector to support companies’ need for quickly and securely get started building Business Intelligence reports.
- 100K records per minute sync speed with entry-level Azure SQL service tiers.
- You decide how to structure your data warehouse by selecting the relevant tables and fields in a simple and intuitive interface in Business Central.
- Incremental exports of all inserts, updates and deletes ensure fast and efficient data transfer.
Customer Review
Up to 500k records per minute
We used to rely on slow APIs and manual ETL jobs to pull data from Business Central. With this connector, we now replicate full tables directly into Azure SQL — up to 500K records per minute — and keep all dashboards running seamlessly.
Setup was quick, and the schema matched perfectly. It’s like having a super-efficient data butler at my service.
★ ★ ★ ★ ★
Turan Atac, Business Systems Lead
Proven Across Industries and Markets
Frequently asked by CTOs
Will this impact Business Central performance?
No.
The connector offloads analytics into Azure SQL, so your ERP remains fully responsive.
Where does the data live and who controls access?
Everything stays in your Azure tenant. You control users, roles, and networking
How are schema or extension changes handled?
The sync supports both standard and custom tables. When the schema changes, you can include new objects instantly.
Can it integrate beyond Power BI?
Yes — any SQL-based tool or pipeline (ADF, Synapse, notebooks, apps) works seamlessly.
How reliable is the sync?
Refresh windows are configurable, with job monitoring and retry logic for predictable operations.
Build the foundation for faster and more insightful Business Intelligence reporting
Replicate your Business Central data at high speed and with robust security without adding development workload.