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:
Through copy assistant:
Navigate to connection configuration section in Manage connections 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!