Analytics Data Lake Connector

The Analytics Data Lake Connector exports data from your Boltrics environment to Microsoft Fabric using Open Mirroring — a feature that keeps a near real-time replica of your data in Microsoft's OneLake data lake, ready for analytics, reporting, and AI workloads. Unlike the Analytics API, which requires an external system to pull data via GET requests, this connector pushes data outward from your Boltrics environment through regular data refreshes.

Microsoft Fabric is Microsoft's unified analytics platform, combining data engineering, data warehousing, and business intelligence — including Power BI — in a single environment. Once your data is in Fabric, it is available across all Fabric workloads without additional pipelines.

Key advantages over traditional API-based integrations:

• Deleted records can be tracked more reliably
• New tables added to Business Central can be included in the connector without requiring support from Boltrics
• No need to build or maintain custom extraction pipelines