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

October 30, 2024 by Patrick LeBlanc

Welcome to the October 2024 Update! Here are a few, select highlights of the many we have for Fabric this month. API for GraphQL support for Service Principal Names (SPNs). Introducing a powerful new feature in Lakehouses: Sorting, Filtering, and Searching capabilities. An addition to KQL Queryset that will revolutionize the way you interact with … Continue reading “Fabric October 2024 Monthly Update”

October 29, 2024 by Leo Li

We’re excited to announce several powerful updates to the Virtual Network (VNET) Data Gateway, designed to further enhance performance and improve the overall user experience. These new features allow users to better manage increasing workloads, perform complex data transformations, and simplify log management. Expanded Cluster Size from 5 to 7 One of the key improvements … Continue reading “New Features and Enhancements for Virtual Network Data Gateway”