Microsoft Dynamics 365
Sync Dynamics 365 financials, sales, and inventory.
The Microsoft Dynamics 365 connector syncs your ERP data into analytics-ready tables in your data warehouse. Pull financials, sales orders, customers, and inventory through the Dynamics 365 and Dataverse Web APIs, with Ingest handling auth, pagination, and retries.
Microsoft Dynamics 365 is not a certified connector yet. Ingest authors one from the vendor's API documentation when a customer asks for it, runs it against the real API, and only then lists it as deployable. Request it and it moves up the queue.
What you can sync
Ingest lands the following Microsoft Dynamics 365 data in your warehouse or lake, each as its own table on the schedule you pick:
- Financials
- Sales orders
- Customers
- Products and inventory
Authentication
OAuth2 (Microsoft Entra ID). Register an app in Microsoft Entra ID and grant it access to your Dynamics 365 environment.
Credentials go into a form, never into a chat, and are held in a secret store under your own path. Only the key NAMES ever reach the control database.
Resources
- Microsoft Dynamics 365 API documentation: https://learn.microsoft.com/en-us/dynamics365/
- Every source Ingest connects
- The tables Ingest creates
- Request Microsoft Dynamics 365