Fast and Easy Export of Business Central data to Azure SQL database
Easily configure which tables to pull from Business Central to your Azure SQL database, enabling you to create analyses and reports for better business management through Business Intelligence tools.
- SAVE TIME WITH FAST DATA PROCESSING.
- ENSURE DATA SECURITY BY KEEPING IT WITHIN YOUR TENANT.
- GAIN ACCURATE INSIGHTS WITH RELIABLE DATA MANAGEMENT
- SAVE TIME WITH FAST DATA PROCESSING.
- ENSURE DATA SECURITY BY KEEPING IT WITHIN YOUR TENANT.
- GAIN ACCURATE INSIGHTS WITH RELIABLE DATA MANAGEMENT
- SAVE TIME WITH FAST DATA PROCESSING.
- ENSURE DATA SECURITY BY KEEPING IT WITHIN YOUR TENANT.
- GAIN ACCURATE INSIGHTS WITH RELIABLE DATA MANAGEMENT
Integrate and secure your business data
with Ecodel Data Warehouse Connector
Data Access and Integration
The Data Warehouse Connector App exports tables and fields from Microsoft Dynamics 365 Business Central to an Azure SQL database, providing easy access for BI, integration, or ETL tasks. No APIs, Synapse Pipelines, or AL-development needed. Just raw Business Central data directly into SQL tables.
- Access Business Central data in an SQL database
- Access your Business Central data for any ETL or datamodeling job needed
- 100% control of business data (business data never leaves your tenant)
Automated Extraction of Data to Azure SQL Server
When the plugin is configured, it exports the selected fields/tables from Business Central Cloud into an Azure SQL Server database of your choice, as if it had been natively accessible. This works smoothly and allows the data to be further used for BI Integration.
★ ★ ★ ★ ★
Export Management and Customization
Manage incremental exports of inserts, updates, and deletes on a customizable schedule. Select which tables and fields to export using an intuitive interface in Business Central.
- Incremental exports of all inserts, updates, and deletes
- You manage the data warehouse size and load by deciding how many tables and fields are exported
- Simple and intuitive setup in Business Central
Very fast data replication from Business Central to an Azure SQL database
Setting up the Ecodel Data Warehouse Connector is very simple and self-explanatory. The tables to be replicated can be selected with just a few clicks. It is even possible to select individual fields for replication. Replication is very fast and reliable. A really great app that I can recommend to everyone!
★ ★ ★ ★ ★
Data Security and Consistency
Data remains within your tenant, ensuring security and control. The app manages export schedules and checks data consistency between Business Central and the SQL database.
- 100k rows per minute throughput (at entry-level Azure SQL production service-tiers)
- Consistency checks after every export available both in Business Central and the Data Warehouse SQL database
- Metadata (table definitions and indexes) are maintained in the SQL database by the App
