Overview

Zap Data Hub for Dynamics 365 Business Central automates the creation and maintenance of a governed data warehouse for Business Central data, delivering pre-built, business-friendly data models and connectors so finance and operations teams can use Excel, in-browser analytics and Power BI with refreshable, trusted numbers rather than manual exports. The solution centralizes and prepares ERP data for reporting, reconciliation and downstream analytics or AI workloads.

Features and Capabilities

• Data Warehouse Automation: Automates ETL/ELT and builds a governed warehouse from Dynamics 365 BC source tables so heavy transforms run in the warehouse.
• Pre-built Business Data Models: Ships with business-ready schemas and mappings for common financial and operational tables, reducing model build time.
• Power BI Integration & Sync: Supplies a Power BI-ready semantic and model layer and syncs with Power BI data models so reports use the same trusted numbers.
• Excel Add-in (Zap Live): Live Excel connectivity to the governed model so analysts can build formatted financial reports using the same data.
• In-browser Analytics (Zap Analytics): Built-in web analytics UI for role-based dashboards and ad-hoc exploration without exporting data.
• Automated Refresh & Scheduling: Scheduled model refreshes and incremental loads to keep reports current with minimal ERP load.
• Security & Governance: Centralized governance, access controls and a semantic layer to standardize names and definitions across teams.
• Multi-ERP / Multi-Company Support: Connects multiple company databases and ERP systems, including Dynamics variants and others, into a unified model.
• Deployment Flexibility: Cloud SaaS hosting with options to deploy on cloud infrastructure, designed for rapid deployment within days or weeks.
• Tiered Plans & Capacity: Offers tiered packaging with different capacity and feature levels, including storage, consumers and refresh options.