BC2SQL – Business Central SQL Access Platform

Unlock the full potential of your Microsoft Dynamics 365 Business Central data.

BC2SQL is a high-performance SQL access platform that gives you fast, secure and reliable access to your Business Central data for reporting, Business Intelligence, integrations, data warehousing and AI.

Whether you need simple Excel exports or a complete SQL platform with near real-time synchronization, BC2SQL scales with your business.

A Modular Solution

BC2SQL consists of three components that can be deployed individually or together, allowing you to start small and expand as your requirements grow.

1. Business Central App

The Business Central App is the heart of BC2SQL and can be used as a standalone solution.

With the app you can:

• Select which Business Central tables to export
• Choose individual fields
• Apply filters
• Create reusable export configurations
• Export data directly to Microsoft Excel

No additional software or database is required.

This makes BC2SQL an ideal solution for customers who need flexible Excel exports directly from Business Central.

2. BC2SQL Synchronization Service (.NET)

The optional synchronization service continuously transfers data from Business Central to your SQL database.

Features include:

• Near real-time synchronization
• Incremental updates
• Automatic background processing
• Minimal impact on Business Central performance
• Reliable synchronization engine

3. Database Component

The database component stores your synchronized Business Central data in a standard relational database.

Supported platforms include:

• Azure SQL Database
• Microsoft SQL Server
• PostgreSQL

Once synchronized, your data is immediately available for:

• Microsoft Power BI
• Reporting
• SQL Views
• Third-party integrations
• Data Warehouses
• AI and Machine Learning solutions

Start with Excel. Upgrade to SQL.

BC2SQL grows with your business.

Business Central App only

Perfect for organizations that need configurable Excel exports without additional infrastructure.

Complete BC2SQL Platform

Add the Synchronization Service and Database Component to enable continuous SQL synchronization for enterprise reporting, integrations and AI.

No migration is required—simply extend your existing installation when you're ready.

Why Choose BC2SQL?

Unlike traditional API-based reporting solutions, BC2SQL creates a dedicated SQL platform optimized for performance and scalability.

Benefits include:

• Near real-time synchronization
• Incremental data transfer
• Minimal API usage
• Reduced load on Business Central
• Standard SQL database
• Business Central SaaS and On-Premises support
• Multi-company support
• Multi-environment support
• Flexible table and field selection
• Enterprise-ready architecture

Full Control of Your Data

BC2SQL does not lock your data into a proprietary reporting platform.

Instead, it provides a high-performance SQL foundation while allowing you to choose your preferred BI tools, reporting solutions, integration platforms and AI technologies.

Your data remains yours.

Getting Started

Install the Business Central App from AppSource and start exporting data to Excel within minutes.

When your organization is ready for advanced reporting, integrations or AI, simply add the BC2SQL Synchronization Service and Database Component to enable continuous near real-time SQL access.

Support

Professional onboarding, implementation and consulting services are available from the BC2SQL team to help you get the most from your Business Central data.

Supported Editions

This app supports the Essential and Premium editions of Microsoft Dynamics 365 Business Central

Supported Countries

This app supports all countries where Business Central is available

Supported Languages

The app is available in English , Danish (Denmark), German (all areas) and Norwegian