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. The UnityJDBC distribution contains embedded drivers for MongoDB, ServiceNow, and Splunk. 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
Qlikview
Pentaho
SAP Lumina
Splunk
Tableau
TIBCO
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