Tabular Foundation Models (TFMs) logopeterindia.net
Knowledge Hub

Data Virtualization Tools

Data virtualization explained: platforms, open-source query engines and cloud query federation, and how they relate to data fabric.

25 topics•5 categories•Updated October 2026

What Is Data Virtualization?

4 entries

Data virtualization gives applications a single logical view of data that stays in its source systems, so queries run across databases, lakes and applications without first copying the data into a warehouse. It is a core technique in data fabric architectures and is related to query federation, which engines such as Trino use to join data across sources. The trade-offs are query performance, source-system load and governance, which products address with caching, pushdown and security layers.

01Data Fabric Solutions & SoftwareData fabric platforms that combine virtualization, integration and active metadata, on this site. 02Data Fabric vs. Data MeshHow virtualization-based fabrics differ from domain-owned data mesh, on this site. 03Data Integration, ETL and CDC ToolsTools that move and transform data instead of virtualizing it, on this site. 04Data Mesh TechnologiesTechnologies for data products and cross-domain query, on this site.

Data Virtualization Platforms

6 entries

Commercial platforms built around a logical data layer. Descriptions follow each vendor's own pages and are not independent evaluations.

05DenodoDenodo describes a platform that connects, governs and unifies data in real time for AI systems and business users. The site also reports Denodo Platform 9.4 (10 March 2026), and IT Brief reported Platform 9.5 in July 2026. 06TIBCO Data VirtualizationTIBCO's data virtualization product. TIBCO's site returns 403 to automated checks, so the link may need a manual click. 07CData VirtualityCData's data virtualization product. CData's site returns 403 to automated checks, so the link may need a manual click. 08StarburstCommercial platform built on Trino; its site describes querying across sources with data federation, Trino and Apache Iceberg while limiting data copies. 09DremioLakehouse platform that its site describes as open and high performance for analytical and AI workloads. SAP announced on 4 May 2026 that it would acquire Dremio and completed the acquisition on 6 July 2026, according to SAP. 10K2viewData product platform whose site describes turning fragmented enterprise data into reusable data products without rebuilding pipelines.

Open-Source Query Federation Engines

6 entries

Open engines that query many sources through connectors. Release and activity facts are from each repository's GitHub page.

11TrinoDistributed SQL query engine for big data (Apache-2.0); GitHub lists release 484 as the latest, from 16 October 2026. 12Trino (GitHub)Source repository for Trino, formerly known as PrestoSQL. 13PrestoThe Presto distributed SQL query engine for big data (Apache-2.0); GitHub lists 0.299 as the latest release, from 28 August 2026. Presto's site returns 403 to automated checks. 14Apache DrillDistributed MPP query layer for self-describing data (Apache-2.0); GitHub lists drill-1.22.0, from June 2025, as the latest release. 15Apache CalciteFramework for SQL parsing, optimization and federated query planning that many engines embed; active in October 2026. 16TeiidData virtualization system from the Red Hat community that lets applications use data from multiple sources. Its GitHub repository's last push was in January 2023, so check its activity before adopting it.

Cloud and Platform Query Federation

5 entries

Federation and virtualization features built into data platforms. Descriptions follow each vendor's own documentation.

17Amazon Athena data source connectorsAWS documentation on connecting Athena to external data sources through connectors for federated queries. 18BigQuery federated queriesGoogle documentation on federated queries that read external databases such as AlloyDB, Spanner and Cloud SQL. 19SQL Server PolyBaseMicrosoft documentation describing PolyBase in SQL Server, including connectors and data virtualization. 20Microsoft Fabric OneLake shortcutsMicrosoft documentation on OneLake shortcuts, which connect to existing data without copying it. 21Databricks Lakehouse FederationDatabricks documentation on query federation to external data sources.

Frequently Asked Questions

What is data virtualization?

A technique that presents data from many sources as one logical layer, so applications can query it in place without copying it into a central store.

How is data virtualization different from ETL?

ETL copies and transforms data into a target store ahead of time, while virtualization queries the sources on demand. Virtualization avoids copies and gives fresher data, but query speed depends on the sources and on caching and pushdown.

What is query federation?

Running one SQL query across several data sources through connectors. Engines such as Trino and cloud services such as BigQuery federated queries do this, and it overlaps with data virtualization.

When should I use data virtualization?

It suits cases where data cannot or should not be copied, where fresh data across systems is needed quickly, or where a logical layer simplifies governance. Heavy analytics over very large joins often still benefits from loading data into a lakehouse or warehouse.

Is data virtualization the same as a data fabric?

No. A data fabric is a broader architecture that combines virtualization with integration, metadata and governance. See the Data Fabric Solutions & Software page on this site.

How current is this page?

Links were checked on 31 October 2026. TIBCO, CData and Presto's site return 403 to automated checks and may need a manual click. Release facts are from GitHub, and vendor descriptions follow each vendor's own pages and are not independent evaluations.