The Dynamics 365 Finance & Operations connector is the velocity lane: OData extract in, budget writeback out, consolidation in between — all delivered through =EPM() in the workbooks your finance team already uses. Available today; each tenant's endpoints and credentials are validated during onboarding.
F&O exposes clean OData services and the platform's connector registry keeps read and write credentials separate. That makes Dynamics the lowest-friction ERP to stand up on Konsolidat.
Pull GeneralJournalAccountEntry, main accounts and financial dimensions from F&O via OData — a purpose-built source on Airbyte's connector SDK (the framework behind its 550+ connectors), with incremental sync, schema-drift handling and retries.
Push approved budgets and plans back into Dynamics 365 F&O through a connector configured with write credentials — closing the loop from plan to ERP. Validated per tenant during onboarding.
Each connector holds separate extract and writeback credential profiles, resolved per legal entity. Read access and write access are never the same key.
Sign in with Microsoft Entra ID via OIDC / SAML, alongside 2FA, RBAC and full audit logging — configured against your tenant's identity provider.
Multi-entity IFRS / GAAP consolidation, FX translation, IC eliminations, NCI and driver-based allocations — on F&O data, validated by 26 automated dbt assertions.
Results land in Excel through =EPM() worksheet functions. Your finance team keeps its spreadsheets; nothing new to relearn.
The Dynamics 365 F&O extract and budget writeback are built and shipping. What varies between tenants is configuration: OData service activation, the app registration and its scopes, and the writeback credential. We validate all of it during onboarding rather than assuming it works everywhere.
Available. OData extract + budget writeback via the connector registry. Tenant endpoints & credentials validated during onboarding.
Roadmap. Not a self-serve connector today. Talk to us if BC is on your group's critical path.
A 4-week pilot validates the F&O connector on your tenant and stands up your first consolidation scenario.
Book a 30-minute technical demo — F&O extract, a real consolidation, and budget writeback back into Dynamics. Then scope a pilot on your tenant.