New Source Connector: Microsoft Dynamics 365 Business Central

[lukewatters-airbyte]

Problem

Users who manage their business operations in Microsoft Dynamics 365 Business Central have no way to sync that data into their data warehouse via Airbyte. There is currently no native Business Central source connector in the catalog, leaving ERP data — such as customers, vendors, invoices, and sales orders — inaccessible through Airbyte.

Proposed Solution

Add a native source connector for Microsoft Dynamics 365 Business Central using its publicly available OData v4 API (v2.0). This API provides structured access to core Business Central entities and is well-documented by Microsoft:
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/

Who benefits

Teams using Microsoft Dynamics 365 Business Central as their ERP who want to centralise business data alongside other sources in their data warehouse. Particularly relevant for SMBs already using other Microsoft connectors in Airbyte (SharePoint, Teams, Dataverse, etc.).

Additional context

Airbyte already supports several Microsoft platform connectors. A Business Central connector would round out that suite for users in the Microsoft ecosystem. A generic OData connector could serve as a partial workaround, but a dedicated connector would
provide a far better out-of-the-box experience.