Do you have data in more that one system that you need to access?

Do you want to avoid costly system integration and data warehouse development?

Do you want a solution that is quick to deploy, cost-effective, and expandable?

Do you need to relate data in systems to detect for errors and inconsistencies?

If you answered "yes" to any of these questions, then UnityJDBC is the solution. With UnityJDBC you can write one query that extracts data from multiple databases. The databases can be on several servers from different vendors. You do not need to build a data warehouse or create a separate application server. All you need to do is write a query using standard SQL syntax that requests the data in each database. UnityJDBC also allows you to compare data across systems with ease. Do all your systems store the same, correct information about your customers or products? With a few UnityJDBC queries, you can find out.

The UnityJDBC driver can integrate and query any number of JDBC-accessible data sources (including Oracle, Microsoft SQL Server, IBM DB2, MySQL, and Postgres) in a single SQL query.


Yes Join Across Multiple Databases/Systems
Write a single query to extract data from any number of JDBC-accessible data sources.

Yes Match & Merge Data
Match data across several sites or use the unique MERGE operator to track the provenance of the data.
Is the data in your systems consistent? Write some simple queries to find out.

Yes Supreme Performance
A new join algorithm (US patent submitted) returns results faster than ever before. Additionally, the built-in optimizer restructures queries to create the most efficient execution plans.

Yes Platform Independent
UnityJDBC is pure Java and can be used on any Java-enabled platform (Windows, Linux, Solaris). The system supports standard SQL queries and works exactly as other JDBC drivers. You can use UnityJDBC for stand-alone Java applications, applets, and with web and application servers.

 

May 1st, 2008 - UnityJDBC 3.0 Released

UnityJDBC version 3.0 is newly released! This version adds support for native updates, user-defined functions, connection pooling, and PreparedStatements. UnityJDBC allows a single SQL query to be executed across any number of JDBC-compliant databases (MySQL, Microsoft SQL Server, PostgreSQL, Oracle, IBM DB2). Queries can join, compare, merge, and relate data from the sources which allows for easier data consistency and validation across systems. Download your free trial copy today.