Microsoft Fabric Updates Blog

Announcing New Data Factory Connectors Released in Q3 2024

We are excited to announce the release of several powerful new connectors in Fabric Data Factory in Q3 2024! These connectors will significantly enhance your data integration and transformation capabilities, enabling seamless workflows and expanding your data connectivity options. Here’s a detailed overview of the newly released connectors and a sneak peek at what’s coming next.

New Connectors

Salesforce

This new addition to Fabric Data Factory enables seamless integration with Salesforce, one of the most widely used customer relationship management (CRM) platforms. The Salesforce connector simplifies the extraction and loading of data between Salesforce and other data sources. It enhances your ability to synchronize customer data, perform analytics, and drive more informed business decisions. The connector leverages the latest Salesforce Bulk API 2.0 to query and ingest data in a secure and efficient manner. You can submit up to 15,000 batches per rolling 24-hour period. Learn more here.

Key Features

  • Supports both on-premises and cloud connection.
  • Efficient data read and write.
  • Support copy and lookup activity in data pipeline

Azure MySQL Database

The Azure MySQL Database Connector is now available, providing a robust solution for integrating MySQL databases hosted on Azure with Fabric Data Factory. This connector simplifies the process of connecting to Azure MySQL databases, enabling secure and efficient data transfers. By leveraging this connector, you can optimize your data workflows, ensuring high performance and reliability. Learn more here.

Key Features

  • Supports both on-premises and cloud connection.
  • Efficient data read and write.
  • Support copy and lookup activity in data pipeline

Azure Cosmos DB for MongoDB

The Azure Cosmos DB for MongoDB connector allows you to effortlessly connect to Azure Cosmos DB instances with the MongoDB API. It offers high compatibility and performance for your NoSQL data needs, making it easier than ever to integrate and manage data stored in Azure Cosmos DB. With this connector, you can streamline your data operations, improve efficiency, and leverage the full potential of Azure Cosmos DB’s scalability and performance. Learn more here.

Key Features

  • Supports both on-premises and cloud connection.
  • Efficient data read and write.
  • Support copy activity in data pipeline

Upcoming Connectors

Stay tuned for the upcoming connectors in late Q3 2024, such as MariaDB connector, ServiceNow connector, Vertica connector, etc, which will enable seamless integration with more sources, allowing you to bring your data into Fabric Data Factory for comprehensive analysis and reporting.

Getting Started

To start using these new connectors, navigate to the connection configuration section from data pipeline or Manage connections and gateways section in your Fabric Data Factory, where you’ll find the new connectors listed. Detailed documentation is available to help you set up and configure these connectors quickly and efficiently. Learn more here.

Navigate to connection configuration section in data pipeline:

Through pipeline activity canvas:

Create a connection from Copy activity interface

Through copy assistant:

Create a connection from Copy assistant interface

Navigate to connection configuration section in Manage connections and gateways:

Create a connection from Settings - manage connection and gateways

Join the Discussion

We invite you to join the conversation in our community forums to share your feedback, experiences, tips, and questions about these new connectors. Your insights are crucial for us to continue improving and expanding Fabric Data Factory’s capabilities.

Thank you for being a valued member of the Microsoft Fabric community. We look forward to seeing the innovative ways you utilize these new connectors to enhance your data workflows.

Happy integrating!

Related blog posts

Announcing New Data Factory Connectors Released in Q3 2024

September 16, 2024 by Meenal Srivastva

We are excited to announce the launch of authentication with workspace identity for OneLake external shortcuts and data pipelines. Previously, we announced workspace identity for trusted access in OneLake shortcuts, data pipelines, and DW Copy statement.  Now, you can also use workspace identity as an authentication method for the Azure Data Lake Storage gen 2 … Continue reading “Introducing Workspace Identity Authentication for OneLake Shortcuts and Data Pipelines “

September 10, 2024 by Jianlei Shen

Fabric Lakehouse supports the creation of custom schemas. Schemas allow users to group tables together for better data discovery, access control, and more. This is now a Preview feature in Fabric. Learn more here. We are excited to announce the latest enhancement in Fabric Data Factory that Lakehouse connector in data pipeline now supports schema. … Continue reading “Introducing the New Feature in Lakehouse Connector in Fabric Data Factory: Schema Support for Reading and Writing Data”