Microsoft Fabric Integration Pathways for ISVs

Microsoft Fabric offers three distinct pathways for ISVs to seamlessly integrate with Fabric. For an ISV starting on this journey, we want to walk through various resources we have available under each of these pathways.

Interop with Fabric

The primary focus with Interop model is on enabling ISVs to integrate their solutions with the OneLake Foundation. To Interop with Microsoft Fabric, we provide integration using REST APIs for OneLake, a multitude of connectors in Data Factory, shortcuts in OneLake, and database mirroring.

Here are a few ways to get you started with this model:

OneLake APIs

• OneLake supports existing Azure Data Lake Storage (ADLS) Gen2 APIs and SDKs for direct interaction, allowing developers to read, write, and manage their data in OneLake. Learn more about ADLS Gen2 REST APIs and how to connect to OneLake.
• Since not all functionality in ADLS Gen2 maps directly to OneLake, OneLake also enforces a set folder structure to support Fabric workspaces and items. For a full list of different behaviors between OneLake and ADLS Gen2 when calling these APIs, see OneLake API parity.
• If you're using Databricks and want to connect to Microsoft Fabric, Databricks works with ADLS Gen2 APIs. Integrate OneLake with Azure Databricks.
• To take full advantage of what the Delta Lake storage format can do for you, review and understand the format, table optimization, and V-Order. Delta Lake table optimization and V-Order.
• Once the data is in OneLake, explore locally using OneLake File Explorer. OneLake file explorer seamlessly integrates OneLake with Windows File Explorer. This application automatically syncs all OneLake items that you have access to in Windows File Explorer. You can also use any other tool compatible with ADLS Gen2 like Azure Storage Explorer.

Data Factory in Fabric

• Data Pipelines boast an extensive set of connectors, enabling ISVs to effortlessly connect to a myriad of data stores. Whether you're interfacing traditional databases or modern cloud-based solutions, our connectors ensure a smooth integration process. Connector overview.
• With our supported Dataflow Gen2 connectors, ISVs can harness the power of Fabric Data Factory to manage complex data workflows. This feature is especially beneficial for ISVs looking to streamline data processing and transformation tasks. Dataflow Gen2 connectors in Microsoft Fabric.
• For a full list of capabilities supported by Data Factory in Fabric checkout this Data Factory in Fabric Blog.

Multicloud Shortcuts

Shortcuts in Microsoft OneLake allow you to unify your data across domains, clouds, and accounts by creating a single virtual data lake for your entire enterprise. All Fabric experiences and analytical engines can directly point to your existing data sources such as OneLake in different tenant, Azure Data Lake Storage (ADLS) Gen2, Amazon S3 storage accounts, and Dataverse through a unified namespace. OneLake presents ISVs with a transformative data access solution, seamlessly bridging integration across diverse domains and cloud platforms.

• Learn more about OneLake shortcuts
• Learn more about OneLake, one copy

Database Mirroring

You’ve seen the shortcuts, now you’re wondering about integration capabilities with external databases and warehouses. Mirroring provides a modern way of accessing and ingesting data continuously and seamlessly from any database or data warehouse into the Data warehousing experience in Microsoft Fabric. Mirror is all in near real-time thus giving users immediate access to changes in the source. You can learn more about mirroring and the supported databases at Introducing Mirroring in Microsoft Fabric.

Develop on Fabric

With the Develop on Fabric model ISVs can build their products and services on top of Fabric or seamlessly embed Fabric's functionalities within their existing applications. It's a transition from basic integration to actively applying the capabilities Fabric offers. The main integration surface area is via REST APIs for various Fabric workloads. Here's a list of REST APIs available today.

Fabric Experience	API	Description
Data Warehouse
	Create Warehouse	Creates a Data warehouse.
	Get Warehouse	Get Metadata about warehouse.
	Update Warehouse	Update an existing warehouse.
	Delete Warehouse	Delete an existing warehouse.
	List Warehouse	List warehouses in your workspace.
Data Engineering
	Create Lakehouse	Creates Lakehouse along with SQL analytics endpoint.
	Update Lakehouse	Updates the name of a lakehouse and the SQL analytics endpoint.
	Delete Lakehouse	Deletes lakehouse and the associated SQL analytics endpoint.
	Get Properties	Gets the properties of a lakehouse and the SQL analytics endpoint.
	List tables	List tables in the lakehouse.
	Table Load	Creates delta tables from CSV and parquet files and folders.
OneLake
	Create Shortcut	Creates a new shortcut.
	Delete Shortcut	Deletes the shortcut but doesn't delete destination storage folder.
	Get Shortcut	Returns shortcut Properties.
	ADLS Gen2 APIs	ADLS Gen2 APIs to create and manage file systems, directories, and path.
Workspace
	CRUD APIs for Workspace and Workspace Role Management	Create Workspace, Get Workspace details, Delete Workspace, Assign workspace to a capacity, Add a workspace role assignment.
Fabric Data Factory	Coming soon
Real Time Analytics	Coming Soon

This section will be updated as more Fabric APIs become available.

Build a Fabric Workload

Build a Fabric Workload model is designed to equip ISVs with the tools and platform capabilities required to craft customized workloads and experiences on Fabric. It enables ISVs to tailor their offerings to deliver their value proposition while leveraging the Fabric ecosystem by combining the best of both the worlds. We're working closely with select design partners for this integration path and it's currently available by invitation only.