The following table summarizes the features of UnityJDBC and the version where they were first introduced.
Table 9.3. UnityJDBC Feature List
| Version | Feature Description |
|---|---|
| 1.0 | Cross-database SQL queries for any JDBC source |
| 1.0 | Query by-pass |
| 1.0 | MERGE feature with MATCH functions |
| 1.0 | Embedded relational database engine |
| 1.0 | Source and schema file encryption |
| 1.0 | Support for Applets |
| 1.0 | Support for query results/databases larger than main memory |
| 2.0 | DataSource connections |
| 2.0 | Pooled connections |
| 3.0 | Prepared Statements |
| 3.0 | User-defined Functions |
| 3.0 | INSERT, DELETE, UPDATE on a single source |
| 3.0 | INSERT, DELETE, UPDATE across sources |
| 3.0 | INSERT INTO across sources |
| 4.0 | Paging using LIMIT/OFFSET |
| 4.0 | Query and ResultSet caching |
| 4.0 | Universal dialect and function translation (support for sources missing functions) |
| 4.0 | Single source subqueries |
| 4.1 | Support for BLOBs/CLOBs. |
| 4.2 | Multiple source subqueries in FROM clause |
| 4.2 | EXPLAIN command for query execution information |
| 4.2 | Ability to control tables extracted into data virtualization by inclusion/exclusion patterns |
| 4.3 | Full subquery support including correlated subqueries |
| 4.3 | INTERSECT/EXCEPT |
| 4.3 | >MongoDB, Splunk, ServiceNow, and Cassandra support |
| 4.4 | Tableau JDBC integration with support for Splunk and MongoDB |
| 4.4 | MongoDB nested query optimizations |
| 4.4 | Additional SQL functional and translation support |
| 4.4 | Enhanced support and performance for Splunk, MongoDB, and ServiceNow |