databricks Platform · Updated Jun 26, 2026

Microsoft Dynamics 365 Connector

Now generally available for seamless data ingestion.

What it does

The Microsoft Dynamics 365 connector in Lakeflow Connect enables users to ingest CRM and ERP data from Dynamics 365 into Databricks via Azure Synapse Link, which exports data to Azure Data Lake Storage Gen2. It supports various features such as UI and API-based pipeline authoring, incremental ingestion, and governance through Unity Catalog. The connector allows for automated schema evolution and supports up to 250 tables per pipeline.

Why it matters

This connector enhances data accessibility and integration for organizations using Dynamics 365, enabling more efficient analytics and reporting. By streamlining the ingestion process, businesses can reduce time-to-insight and improve decision-making capabilities. The support for incremental ingestion and governance ensures that data remains up-to-date and compliant.

Key capabilities

UI-based Pipeline Authoring

Users can create data ingestion pipelines through an intuitive user interface.

Incremental Ingestion

Supports the efficient ingestion of only new or changed data from Dynamics 365.

Unity Catalog Governance

Ensures data governance and security through integration with Unity Catalog.

Automated Schema Evolution

Automatically manages changes in schema, such as new columns and column renames.

Prerequisites

Databricks user persona setup (admin or non-admin)

Configured Dynamics 365 for data ingestion

Selected authentication method (OAuth U2M)

Recommended use cases

Ingesting CRM data for analytics and reporting.Integrating ERP data into data lakes for comprehensive analysis.Automating data updates for real-time insights.

Limitations · remember

!Automated schema evolution does not support data type changes.

!OAuth M2M and manual refresh token authentication are not supported.

!Basic authentication methods (username/password, API key, service account JSON key) are not supported.

Architecture

Lakeflow Connect → Azure Synapse Link → Azure Data Lake Storage Gen2 → Databricks Workflows → Unity Catalog

Get started

Configure Dynamics 365

Enable ingestion from Databricks by configuring Dynamics 365.

Create a Connection

Use Catalog Explorer or the data ingestion UI to establish a connection to Dynamics 365.

Set Up Ingestion Pipeline

Create a data ingestion pipeline using the established connection.

Select Ingestion Frequency

Determine the schedule based on latency and cost requirements.

Monitor and Manage Pipelines

Utilize Databricks Workflows for orchestration and monitoring.

Key takeaway

The Microsoft Dynamics 365 connector streamlines data ingestion into Databricks, enabling organizations to leverage their CRM and ERP data for enhanced analytics and decision-making.

2026-06-26-microsoft-dynamics-365-connector-ga Generated by the Databricks Updates Agent · browse all updates