Microsoft Fabric Updates Blog

Announcing New Data Factory Connectors Released in May 2024

We are excited to announce the release of several powerful new connectors in Fabric Data Factory this May 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

Oracle database Connector

The Oracle connector allows you to integrate your Oracle databases with Fabric Data Factory, simplifying data migration and ETL processes. Learn more here.

Key Features

  • Supports on-premises connection.
  • Efficient data extraction and loading.
  • Secure connections with Oracle authentication.

MySQL database Connector

Seamlessly integrate your MySQL databases with Fabric Data Factory to manage and analyze your data more effectively. Learn more here.

Key Features

  • Supports both on-premises and cloud connections.
  • Supports full and incremental data loads.
  • Secure and high-performance data transfers.

Oracle Cloud Storage Connector

Connect to Oracle Cloud Storage with ease, enabling you to manage and transfer your cloud-stored data within Fabric Data Factory. Learn more here.

Key Features

  • Easy integration with Oracle Cloud Storage.
  • Efficient data movement capabilities.
  • Secure and efficient data handling.

Azure AI Search Connector

Enhance your data retrieval and analytics capabilities by integrating Azure AI Search with Fabric Data Factory. Learn more here.

Key Features

  • Seamless integration with Azure AI Search.
  • Enhanced search and indexing capabilities.
  • Secure and efficient data handling.

Azure Files Connector

Connect Azure Files with Fabric Data Factory to manage and integrate your file storage data efficiently. Learn more here.

Key Features

  • Easy integration with Azure Files.
  • Supports various file formats and sizes.
  • Secure and efficient data transfers.

Dynamics AX Connector

Streamline your business data workflows by integrating Dynamics AX with Fabric Data Factory, enhancing your data analysis and reporting capabilities. Learn more here.

Key Features

  • Seamless integration with Dynamics AX.
  • Supports various Dynamics AX data entities.
  • Secure and efficient data transfers.

Google BigQuery Connector

We understand the growing importance of integrating with cloud-native data warehouses, and our new Google BigQuery connector is here to facilitate that. This connector allows you to seamlessly read and move data between Google BigQuery and Microsoft Fabric. You can now easily load, transform and analyze your data with minimal effort. Learn more here.

Key Features:

  • Supports both on-premises and cloud connections.
  • Efficient data movement between Google BigQuery and Fabric.
  • Secure and efficient data transfers.

Snowflake Connector (powered by ADBC driver)

Our new Snowflake connector, built on the ADBC driver, offers enhanced performance and compatibility, making it easier to integrate Snowflake with Fabric Data Factory. Learn more here.

Key Features:

  • High-speed data transfers optimized for performance.
  • Efficient data movement between Snowflake and Fabric.
  • Secure and efficient data transfers.

Upcoming Connectors

Stay tuned for the upcoming connectors such as Salesforce connector, Azure MySQL Database connector, Azure Cosmos DB API for MongoDB connector, 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.

Screenshot of the Get Data window showing the connectors in this update

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!

The Microsoft Fabric Team

Related blog posts

Announcing New Data Factory Connectors Released in May 2024

June 21, 2024 by Marc Bushong

Developing ETLs/ELTs can be a complex process when you add in business logic, large amounts of data, and the high volume of table data that needs to be moved from source to target. This is especially true in analytical workloads involving relational data when there is a need to either fully reload a table or incrementally update a table. Traditionally this is easily completed in a flavor of SQL (or name your favorite relational database). But a question is, how can we execute a mature, dynamic, and scalable ETL/ELT utilizing T-SQL with Microsoft Fabric? The answer is with Fabric Pipelines and Data Warehouse.

June 18, 2024 by RK Iyer

✎ Co-Author – Abhishek Narain Overview Building an effective Lakehouse starts with establishing a robust ingestion layer. Ingestion refers to the process of collecting, importing, and processing raw data from various sources into the data lake. Data ingestion is fundamental to the success of a data lake as it enables the consolidation, exploration, and processing … Continue reading “Demystifying Data Ingestion in Fabric: Fundamental Components for Ingesting Data into a Fabric Lakehouse using Fabric Data Pipelines”