Microsoft Fabric Blog presents an in-depth overview of the latest Fabric Data Factory connector updates, highlighting advancements in data integration, performance, governance, and security for enterprise analytics teams.

Enhancements in Microsoft Fabric Data Factory Connectors for Enterprise-Scale Data Integration

Introduction

In this article, the Microsoft Fabric Blog highlights major updates to Fabric Data Factory connectors aimed at improving data integration capabilities across enterprise analytics environments. The new features touch on connectivity, throughput, governance, and security.

1. Expanded Connector Coverage

Recent updates introduce new connectors for a wide range of enterprise data sources and platforms:

  • Copy Job & Pipeline: AWS RDS for Oracle, Azure Database for PostgreSQL 2.0, Azure Databricks Delta Lake, Cassandra, Greenplum, HDFS, Informix, Microsoft Access, Presto, SAP BW Open Hub, SAP Table, Teradata
  • Dataflow Gen2: Snowflake 2.0, Databricks 2.0, Google BigQuery 2.0, Impala 2.0, Netezza, Vertica, Oracle (OPDG only)

These connectors enable bringing varied, structured and semi-structured data sources into Fabric without external ETL tools, helping break down data silos.

2. Performance Improvements

  • Salesforce & Salesforce Service Cloud Connectors now support partitioned data reading, enabling parallel, multi-threaded data pulls for higher throughput without intricate configurations.

3. Enterprise Readiness Enhancements

  • Delta Lakehouse Upsert: Supports incremental, merge-style data updates.
  • Delta Column Mapping & Deletion Vector: Helps manage evolving schemas and deleted records for resilience and reliability.
  • varchar(max) Support in Data Warehouse: Facilitates storage of large, unstructured text fields.
  • Temporal Data Fidelity: MongoDB & MongoDB Atlas connectors now preserve timestamp and date types.
  • Azure Databricks Connector Governance: Users can target specific Unity Catalogs for precision in organizational governance.
  • DB2 Package Collection Configuration: Enterprises can specify DB2 package collection at pipeline level, supporting database standards and governance.
  • Snowflake Role Specification: Assigns custom access roles to ensure security-compliant data movement.
  • Azure Database for PostgreSQL Upsert and Script Activity: Supports incremental writes and in-pipeline custom SQL execution.

4. Security Enhancements

  • Microsoft Entra ID Authentication: PostgreSQL connector supports central, managed authentication (formerly Azure AD).
  • TLS 1.3 Support for PostgreSQL: Latest encryption standards ensure data in transit is secure and compliant.
  • Workspace Identity Authentication: Enables connectors to use managed identities, reducing the need for hardcoded credentials across pipelines.

Resources and Next Steps

Conclusion

These enhancements strengthen Microsoft Fabric as a platform for secure, scalable, and flexible data integration in the enterprise. Updates to connector support, performance, and governance give organizations fine-grained control and enable compliance with modern security standards, while simplifying integration of vast and diverse datasets across analytics workloads.

This post appeared first on “Microsoft Fabric Blog”. Read the entire article here