SQL Databases

CData Virtuality offers robust support for a variety of SQL-based relational database systems. These connectors allow real-time access, data virtualization, and seamless integration with your data workflows. SQL integration also features real-time query federation, metadata introspection and schema discovery, and push-down optimization for SQL transformations.

Metadata Discovery and Data Type Conversion

CData Virtuality uses JDBC and ODBC drivers to connect to SQL databases in its native SQL dialect. You can define views over one or more source tables and perform joins across different databases. CData Virtuality then executes queries of this data as a single query. CData Virtuality automatically maps data types from different systems into uniform data types. Therefore, when you view your data in a BI tool, the data model looks like one unified SQL database.

Query Pushdown

When you run a query in CData Virtuality, it analyzes your SQL, breaks it into sub-queries that match the capabilities of each source system, and pushes as much work as possible down to the source database. Any work that cannot be pushed down is performed by the CData Virtuality engine.

Supported Databases

CData Virtuality supports the following SQL databases:

• PostgreSQL

• MySQL / MariaDB

• Microsoft SQL Server

• Oracle Database

• IBM DB2

• SAP HANA

• Teradata

• Amazon Aurora (PostgreSQL/MySQL)

• Google Cloud SQL (PostgreSQL/MySQL)

• SQLite (primarily for lightweight local testing)

Each database connector comes with specific setup instructions and performance tuning guidelines.