Repository navigation
Home
Welcome to the bc2adls documentation! This tool enables you to export incremental data from Dynamics 365 Business Central to Microsoft Fabric or Azure Data Lake Storage.
The bc2adls extension is available as a free app on the Microsoft Marketplace (AppSource). You can install it directly into your Business Central environment:
📥 Download bc2adls from Microsoft Marketplace
Alternatively, the extension is also available as a PTE (Per-Tenant Extension) from the GitHub Releases page. See PTE App vs AppSource App for a detailed comparison of the differences between the two versions (mainly object number changes).
- Get it from the Marketplace
- Introduction
- Export Options
- Getting Started
- Documentation Pages
- Resources
The bc2adls tool provides a powerful solution for exporting Business Central data to external storage platforms. It supports incremental data exports, ensuring that only changed data is transferred, which optimizes performance and reduces costs.
bc2adls supports three different export options, each designed for specific use cases:
Export data to Azure Data Lake Storage Gen2 with full CDM (Common Data Model) support and Azure Synapse Analytics integration.
Best for:
- Organizations already using Azure infrastructure
- Advanced data transformation with Azure Synapse pipelines
- Integration with multiple Azure services
- CDM format requirements for Power BI consumption
Key Components:
- Business Central extension (
businessCentral/app) - Azure Synapse pipelines (
synapse/) - CDM manifest support (CSV and Parquet formats)
📖 Read the Azure Data Lake Setup Guide
Export data directly to Microsoft Fabric Lakehouse and use notebooks to process delta files into Delta Parquet tables.
Best for:
- Organizations using Microsoft Fabric
- Direct integration with Power BI and Fabric ecosystem
- Simplified setup without Azure Synapse
- Modern lakehouse architecture
Key Components:
- Business Central extension (
businessCentral/app) - Fabric notebooks for data consolidation (
fabric/) - Delta Parquet table format
📖 Read the Microsoft Fabric Setup Guide
Use the native Fabric mirroring capability to replicate Business Central data continuously.
Best for:
- Near real-time data replication
- Minimal configuration requirements
- Fully managed solution by Microsoft Fabric
- Organizations wanting the simplest setup
Key Features:
- Native Fabric integration
- Automatic continuous replication
- No notebook required
📖 Read the Fabric Open Mirroring Guide
- Choose your export option based on your infrastructure and requirements
-
Install the Business Central extension from the
releases - Configure Azure/Fabric resources according to your chosen option
- Set up authentication using Service Principal
- Configure export settings in Business Central
- Schedule exports using Job Queue entries
- Set up data consolidation (for ADLS or Fabric with notebooks)
- Dynamics 365 Business Central (Online or On-Premises)
- Azure subscription (for ADLS and Fabric options)
- Appropriate permissions in Business Central and Azure/Fabric
- Configuration Reference - Complete reference for all setup page options and fields
- Azure Data Lake Setup - Complete setup guide for ADLS Gen2 export
- Microsoft Fabric Setup - Setup guide for Fabric Lakehouse with notebooks
- Microsoft Fabric Open Mirroring - Guide for using native Fabric mirroring
- Power Automate Integration - Set up automated pipeline triggering
- Execution Guide - How to run exports and consolidate data
- Multi-Company Export - Export data from multiple companies from a single page
- Scheduling Exports - Configure automated recurring exports
- Shared Metadata Tables - Use Spark tables with Azure Synapse
- CDM Format Options - Understanding CSV vs Parquet formats
- Performance Optimization - Tips for large data volumes
- PTE App vs AppSource App - Differences between the PTE and Marketplace versions (object number mapping)
- FAQs - Frequently asked questions and troubleshooting
- Changelog - Release notes and version history
- Permission Sets - Understanding BC permissions for bc2adls
- Jan 2022 - Webinar introducing bc2adls
- Apr 2022 - Areopa Webinar bc2adls
- Mar 2023 - Enhancements to bc2adls - CloudChampion
- Jan 2024 - Areopa Webinar MS Fabric
- Choose your best option (Fabric is the newest architecture)
- Follow the appropriate setup guide
- Install and configure the Business Central extension
- Test with a few tables before full deployment
- Join the community and share your experience!
This project is maintained by the community. Special thanks to the original creators Soumya Dutta and Henri Schulte.