UnityJDBC - Multiple Database Querying, Reporting, Development

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. See all features.

It allows real-time decisions and reporting in minutes with easy installation and dramatically lower total cost of ownership than data warehousing and server federation/integration.

UnityJDBC allows applications and reports to be built faster and respond quicker to changing business conditions. As your company grows, adding new systems can be done quickly with minimal cost while allowing a complete integrated view of all valuable corporate data and inter-relationships.

Diagram

UnityJDBC allows better, faster business decisions and advantages by integrating data from all your data sources in real-time without costly investments in new system infrastructure.

UnityJDBC Solutions

  • Multiple database reporting - allow your reporting software such as JasperReports and Pentaho to generate reports with data from many sources.
  • Multiple database querying - add UnityJDBC to your favorite query tool (e.g. Aqua Data Studio, SQuirreL SQL, DatabaseSpy, RazorSQL) and perform multiple database queries and joins in 5 minutes.
  • Build portable and maintainable applications - UnityJDBC provides function and SQL translation for database dialects. Develop your application with one SQL dialect, and UnityJDBC will translate it automatically for whatever database is used.
  • Rapid ETL and Querying - Do you need an answer now? Write a query, generate a report, or build an application in minutes that combines data in real-time from multiple sources. No new software or system changes and no hassle.

UnityJDBC Features

  • Join Across Multiple Databases/Systems - Write a single SQL query to query two databases or any number of JDBC-accessible data sources (including Oracle, MySQL, DB2, Microsoft SQL Server, Microsoft Access, Sybase, PostgreSQL, HSQLDB, SQLite, Generic JDBC/ODBC).
  • Match & Merge Data - Match data across several sites and determine if it is consistent across databases.
  • Supreme Performance - The optimizer intelligently executes portions of the query on each data source to maximize performance. UnityJDBC contains a complete database engine that executes cross-database joins and operations.
  • Platform Independent - UnityJDBC is pure Java and can be used on any Java-enabled platform. The system supports standard SQL queries and works exactly as other JDBC drivers. Works with stand-alone applications and web applications and servers.
  • Scalability and Flexibility - UnityJDBC provides data caching in server installations and can reduce the load on data sources by deploying multiple integration servers running UnityJDBC that handle complicated queries instead of overloadiing production databases.

Five Minute Setup

UnityJDBC - Setup and Query Oracle, Microsoft, PostgreSQL, and MySQL in 5 minutes!

Client Testimonial

"Jasper Reports Server is an open-source reporting application quickly gaining traction. The one thing that Jasper is missing is the ability to report across multiple data sources simultaneously. Your driver is perfect for covering this gap. It suddenly became absolutely essential in a hundred different places."

  - Max Mayrhofer, Senior Software Developer at a leading Swiss private banking group.