Connect Microsoft Dynamics to your Definite lakehouse in minutes.
Native sync with row-level security, CDC where supported, and hourly-or-faster freshness. Query it with SQL, build dashboards, or ask Fi.
Everything Microsoft Dynamics exposes, modeled and queryable.
Extracts ERP data from Microsoft Dynamics 365 Business Central, including company profiles, products/items, vendors, purchasing and payments, sales orders and invoices (with line items), chart of accounts, general ledger entries with dimensions, and dimensional metadata. This enables analysis of revenue and invoicing, AP/AR, vendor spend, inventory and product performance, financial postings, and dimensional reporting.
Tables & streams
Represents an operating company within the tenant; used to scope data, compare subsidiaries, and manage currency and fiscal settings for consolidated reporting.
The chart of accounts that classifies financial postings; enables financial statement mapping, account rollups, and KPI groupings.
Line-level financial postings with debit/credit amounts and applied dimensions; foundation for P&L, balance sheet, trial balance, and dimensional analysis.
Definitions and values for segmenting transactions, plus their application on entries; enables slicing financials by department, project, region, or custom hierarchies.
Customer orders with header and line items; supports backlog tracking, order-to-cash cycle time, fulfillment status, and conversion to invoices.
Issued sales invoices and line items; enables revenue reporting, AR aging, average invoice value, tax analysis, and sales by item or dimension.
Vendor AP invoices with header and line items; supports spend analysis by vendor or account, accruals, AP aging, and cost of goods purchased.
Supplier master data with identifiers, balances, and aggregated spend; used for vendor performance, concentration risk, and payment behavior analysis.
Payment batches and lines applied to vendor invoices; enables cash outflow tracking, DPO, discount capture, and settlement reconciliation.
Product and item master data with pricing and inventory attributes; supports revenue by product, inventory valuation, and product performance analysis.
Warehouses and operational locations; supports inventory and fulfillment metrics by site or region.
Definitions for due dates and cash discounts; used to model AR/AP due dates, measure DSO/DPO, and analyze discount capture.
Connects securely via Microsoft Azure AD OAuth using your client ID, client secret, and a refresh token to obtain an access token
Requires a Microsoft Dynamics account to connect.
Operational data, performance metrics, and business insights.
Three steps. One afternoon.
Authenticate Microsoft Dynamics in a few clicks. OAuth, API key, or IAM role — we handle secrets and rotation.
We pull every stream into your lakehouse. CDC where the API supports it; full + incremental otherwise. Hourly-or-faster, row-level secure.
SQL, dashboards, or ask Fi in plain English. Your Microsoft Dynamics data lives next to every other source — ready to join.
Build your own with the Definite SDK, or ask us — we add new connectors every week.
