Skip to content

Microsoft integrates Oracle and BigQuery data reflecting into its Fabric platform, offering seamless data sharing and integration across various services.

Constructs a Graph Database from Recycled LinkedIn Profiles

Microsoft integrates Oracle and BigQuery data reflecting into its Fabric platform, enhancing data...
Microsoft integrates Oracle and BigQuery data reflecting into its Fabric platform, enhancing data interoperability.

Microsoft integrates Oracle and BigQuery data reflecting into its Fabric platform, offering seamless data sharing and integration across various services.

Microsoft has expanded its cloud-based data platform, Fabric, with the introduction of Graph in Fabric. This new service, developed by the team at LinkedIn, acquired by Microsoft in 2016, is a low/no-code platform for modeling and analyzing relationships across enterprise data.

The primary use of Graph in Fabric is to understand the relationships between data in Fabric. It supports a variety of external systems, including Google and Oracle databases, and partners such as Neo4j, ESRI, and Lumel.

Fabric's mirroring feature, introduced in 2023, allows users to replicate a snapshot of external databases from these providers to OneLake in Delta Lake tables and keeps the replica synced in near real-time. This means users don't need to extract, transform, and load (ETL) data from supported systems or build and maintain data pipelines.

Fabric's mirrored data store uses Apache Parquet and Delta Lake open table format, making it compatible with other lakehouse-based services like Databricks, AWS, Oracle, and Snowflake. Microsoft Fabric also supports Apache Iceberg for mirroring, which aligns with Databricks' promise of greater integration between Apache Iceberg and Delta Lake.

Organizations deeply invested in related products like Power BI and Synapse might find Fabric a logical move, as it offers a comprehensive data analytics solution. However, users of these platforms might see Microsoft's proposition differently.

Google, AWS, Oracle, Databricks, and Snowflake have their own interpretations of the lakehouse concept, and it remains to be seen how Fabric will differentiate itself in this competitive landscape.

It's worth noting that users may need to grant Fabric permission to access the Oracle database, and if it's on a premises system or behind a firewall, a Fabric enterprise gateway is required to connect to it.

With the launch of Graph in Fabric, Microsoft continues to solidify its position as a leader in cloud-based data solutions, offering enterprises a powerful tool for understanding and analyzing their data relationships.

Read also:

Latest