Data Virtualization Tools

Data Virtualization Tools Overview

What are Data Virtualization Tools?

Data virtualization provides access to data while hiding technical aspects like location, structure, or access language. This allows applications to access data without having to know where it resides. This can be used in (for instance) data federation, where data in separate data stores are made to look like a single data store to the consuming application.


Data virtualization tools are confused with Enterprise Application Integration (EAI) as both concern data integration. But EAI supports passing data between enterprise applications. Data virtualization allows querying across multiple databases and data management tools as though they were one data store.


Data virtualization is also distinct from Extract, Transform, and Load (ETL) technologies which normalize and stream data to a data warehouse. Unlike ETL, data virtualization tools provide real-time answers to queries while the data remains in place without replication. Data virtualization tools are faster and less resource intensive than ETL.

Data Virtualization Tools Features & Capabilities

Data virtualization tools generally provide these features:

  • Treat multiple data sources as a single source

  • Combine, transform data to produce virtual data model

  • Graphical or codeless data modeling, data design tools

  • Advanced transformation (e.g. for non-relational data)

  • Virtualize real-time access to data without moving it

  • Advanced query engine

  • Centralize metadata control

  • User-friendly view of enterprise data

  • On-demand data publication

  • Business directory and controlled, easy data search

  • Virtual data layer provides data firewall, secure access control

Pricing Information

Data virtualization provides a relatively inexpensive means of acting upon combined data from disparate sources. Many tools are available on a trial basis, after which they are available on a monthly or annual subscription. Licensing cost scales with the number of data sources drawn from, as well as the number of queries to be run.

Data Virtualization Products

(1-14 of 14) Sorted by Most Reviews

TIBCO Data Virtualization

Cisco Data Virtualization, formerly Composite (acquired July 2013) is, as the name might suggest, a data or datacenter virtualization platform.

Oracle Data Service Integrator

Oracle Data Service Integrator provides companies the ability to develop and manage federated data services for accessing single views of disparate information. Oracle Data Service Integrator is standards based, declarative, and enables re-usability of data services. For more information…

Denodo

Denodo is the eponymous data integration platform from the global company headquartered in Silicon Valley.

AtScale

AtScale, headquartered in San Mateo, offers intelligent data virtualization which they state provides live, secured and governed access to Big Data across disparate systems wherever it resides—and without disruption.

SAS Federation Server

SAS Federation Server is a data integration service.

Actifio Sky

Actifio Sky, from Massachusetts based Actifio, is a data virtualization platform.

Stone Bond Enterprise Enabler

Enterprise Enabler is a data virtualization or data integration platform from Stone Bond Technologies in Houston, Texas.

IBM Cloud Pak for Data (formerly IBM Cloud Private for Data)

IBM Cloud Pak for Data (formerly IBM Cloud Private for Data) provides data management, data governance, and automated data discovery and classification.

Oracle Big Data SQL Cloud Service

The Oracle Big Data Cloud Service is a PaaS supporting data scientists with secured and encrypted Hadoop clusters, running a diverse set of workloads from Hadoop-only workloads (ETL, Spark, Hive etc.) to interactive, all-encompassing interactive SQL queries using SQLon-Hadoop tools…

Starburst Presto

Presto is a distributed SQL query engine used for large-scale, interactive analytics, enabling users to run analytic SQL queries across a wide variety of data sources with elastic scaling. Starburst Presto Enterprise Edition (EE) is Starburst Data's paid solution that supplies performance,…

Dremio

Dremio, from the company of the same name in Santa Clara, is described as a data lake engine. Dremio operationalizes data lake storage and speeds analytics processes, boasting a high-performance and high-efficiency query engine while also democratizing data access for data scientists…

CONNX

CONNX, from Software AG (acquired in 2016), is a mainframe integration solution that allows users to access and integrate mainframe data, relational data, and cloud data wherever it resides and however it is structured, without altering core systems.

Keenlog Analytics

Keenlog Analytics provides intelligence to the SMB business and supports decision-makers with the necessary data visibility to control and take actions to meet their logistics’ financial and market goals. The vendor states the product includes the following: • More…