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

July 19, 2024 by Penny Zhou

We are thrilled to share that you can easily browse and connect to your Azure resources automatically with the modern get data experience of Data Pipelines. With the Browse Azure experience, you don’t need to manually fill in the endpoint, URL or server and database name when connecting to Azure resources. Instead, the connection will … Continue reading “Quickly Connect to your Azure Resources in Fabric with the Data Pipeline Modern Get Data Experience”

July 17, 2024 by Ye Xu

Fast Copy boosts the speed and cost-effectiveness of your Dataflows Gen2. We loaded a 6 GB CSV file to a Lakehouse table in Microsoft Fabric with 8x faster and 3x cheaper result. See our last post for details. Today, we’re excited to announce that Fast Copy in Dataflow Gen2 now supports high-performance data transfers from … Continue reading “Fast Copy with On-premises Data Gateway Support in Dataflow Gen2”