Ecodel Exclusive - Data Warehouse Connector
de Ecodel
Get access to Microsoft Dynamics 365 Business Central Data in your Azure SQL database
The Data Warehouse Connector App allows you to export the tables and fields from the Microsoft Dynamics 365 Business Central database, to an Azure SQL database of your choice. Thus giving you access to your Dynamics 365 Business Central data for either Business Intelligence purposes, integration purposes or any ETL-jobs needed for other data warehouses or business applications. No APIs, no Synapse Pipelines, no AL-development or black-box data-remodeling needed. Just raw Business Central data directly into SQL tables.
A Job Queue Task manages incremental exports of all inserts, updates and deletes on a schedule set by you. Making sure that the Data Warehouse SQL database tables excactly match the same Business Central SQL database tables.
- Maybe you want your data updated weekly, every night or once every 5 minutes.
- Maybe you only need a few tables and fields or maybe you want more than a 100 tables and 1000+ fields.
It is up to you how you want to set up your Data Warehouse, through selecting tables and fields in a simple and intuitive interface in Business Central.
The business data never leaves your tenant, as it is exported directly from your Business Central service, through a BLOB-storage in your tenant (that you control) to an Azure-SQL Database (also in your tenant and under your control). This way you control all access to data from the instant it leaves the Business Central database.
The Business Central Data Warehouse Connector App makes the setup of tables easy and manages the export-schedule for you. It checks the consistency of the Data Warehouse table data compared to your Business Central table data by using rowcounts and calculating checksums. A system table in your data warehouse SQL database holds the most recent update timestamp and consistency checks for every Business Central table exported.
Benefits
- Access Business Central data in an SQL database
- Simple and intuitive setup in Business Central
- 100% control of business data (business data never leaves your tenant)
- Metadata (table definitions and indexes) are maintained in the SQL database by the App
- Incremental exports of all inserts, updates and deletes
- 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
- You manage the data warehouse size and load by deciding how many tables and fields are exported
- Access your Business Central data for any ETL or datamodeling job needed
Supported Editions
The Business Central Data Warehouse Connector App supports both the Essential and Premium editions of Microsoft Dynamics 365 Business Central.
Supported Countries
The app is available in all countries.
Supported Languages
English.