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 26, 2024 by Ye Xu

Fast Copy in Dataflow Gen2 is now General Available! This powerful feature enables rapid and efficient ingestion of large data volumes, leveraging the same robust backend as the Copy Activity in Data pipelines. With Fast Copy, you can experience significantly shorter data processing times and improved cost efficiency for your Dataflow Gen2. Additionally, it boosts … Continue reading “Announcing the General Availability of Fast Copy in Dataflows Gen2”

September 26, 2024 by Leo Li

Fabric Data Pipeline support in the On-Premises Data Gateway is now generally available! The on-premises data gateway allows you to seamlessly bring on-premises data to Microsoft Fabric. With data pipelines and the on-premises data gateway, you can perform high-scale data ingestion of your on-premises data into Fabric. Enhancements Over Self-Hosted Integration Runtime in Azure Data … Continue reading “Announcing the General Availability of Fabric Data Pipeline Support in the On-Premises Data Gateway”