UnityJDBC Features Comparison

UnityJDBC is a JDBC-driver that allows any Java program, reporting software, or query tool to combine data from multiple databases without requiring any new systems or server modifications. Download a free trial.

Feature Client Version Server Version
System Features
JDBC-compliant Type 4 Driver
SQL 92 compliant
SQL function translation
SQL dialect translation
Over 100 built-in SQL functions
Connection user id/password encryption
Embedded database engine
Unlimited number of connections only 2 allowed
Web server compatible
Supports connection pooling
Query and result caching
Query Features
Cross-database joins
Multiple database joins
GROUP BY/ORDER BY/HAVING
Result paging using LIMIT/OFFSET
User-defined functions
Subqueries in FROM (derived tables)
Unlimited databases in one query
Compare data in two different databases
Advanced query optimization
Minimizes data communication
Pushes down selections and joins to sources
Can manipulate query engine directly
Supported Databases
Cassandra
HSQLDB
IBM DB2
Microsoft Access
Microsoft SQL Server
MongoDB
MySQL
Oracle
PostgreSQL
ServiceNow
SQLite
Sybase IQ, SQL Anywhere, Sybase ASE
Any JDBC/ODBC Source
Reporting Software Compability
BIRT
JasperReports/iReport
Pentaho
WebFocus
Any reporting software that supports JDBC sources
Query Software Compability
Aqua Data Studio
DatabaseSpy
RazorSQL
Rapid SQL
SQuirreL SQL
Any query software that supports JDBC sources