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 10, 2024 by Abhishek Narain

At the Microsoft Fabric Community Conference Europe 2024, we announced the General Availability (GA) of Copilot for Data Factory. It operates like a subject-matter expert (SME), collaborating with you to design your dataflows. Find our Copilot for Data Factory GA announcement blog.   Today, we all brainstorm ideas and draw sketches before formalizing them. As … Continue reading “Use Azure OpenAI to turn whiteboard sketches into data pipelines”

October 4, 2024 by Jason Himmelstein

We had an incredible time in our host city of Stockholm for FabCon Europe! 3,300 attendees joined us from our international community, and it was wonderful to meet so many of you in person. Throughout the week of FabCon Europe, our teams published a wealth of valuable content, and we want to ensure you have … Continue reading “Fabric Community Conference Europe Recap”