The UnityJDBC driver can integrate and query any number of JDBC-accessible data sources (including Oracle, SQL Server, MySQL, and Postgres) in a single SQL query. UnityJDBC contains a built-in database engine and optimizer that can be used separately from the integration system. UnityJDBC will automatically translate SQL functions and dialects and can be used when translating from one database system to another.
Integrate Everything: UnityJDBC allows you to write a single SQL query to extract data from any number of JDBC-accessible data sources. The query can join or match data between sources and return a single ResultSet.
Supreme Performance: UnityJDBC has minimal overhead and contains a unique join algorithm that returns results faster than previous algorithms. The built-in optimizer restructures queries to create the most efficient execution plans. It can process queries larger than main memory.
Standards based: UnityJDBC is pure Java and can be used on any Java-enabled platform (Windows, Linux, UNIX). The system supports standard SQL queries and works exactly as other JDBC drivers. This allows for rapid development of applications that access multiple databases without requiring new middleware software or training programmers on a different development environment. It can be deployed within application and web servers as well as stand-alone Java applications.
Database Annotation: The system allows developers to rename fields and tables in the databases being queried. This makes it easier to track and query the databases.
Matching and Merging Data: The MERGE operator allows queries that go beyond standard joins and track the provenance of the data.
Function Translation: UnityJDBC supports all standard SQL functions, user-defined functions, and translates functions specific to the dialect and level of support on each database system including date/time functions, string manipulation, and LIMIT/OFFSET paging.
» version 4.0 - posted on 2011-08-11
» version 1.0 - posted on 2006-07-03
EULA - End User License Agreement
IMPORTANT--READ THESE TERMS CAREFULLY BEFORE DOWNLOADING THIS SOFTWARE. BY DOWNLOADING OR USING THIS SOFTWARE, YOU ACKNOWLEDGE THAT YOU HAVE READ THIS LICENSE AGREEMENT, THAT YOU UNDERSTAND IT, AND THAT YOU AGREE TO BE BOUND BY ITS TERMS. IF YOU DO NOT AGREE TO THE TERMS AND CONDITIONS OF THIS LICENSE AGREEMENT, PROMPTLY EXIT THIS PAGE WITHOUT DOWNLOADING THE SOFTWARE.
Grant of License for Registered Users
UnityJDBC, grants you a non-exclusive, non-transferable license to use program with which this license is distributed ("UnityJDBC driver"), including any documentation files accompanying Software ("User Guide") on a single computer. If this computer is a server (if Software is server based) then a server license must be purchased. Each client license allows software to be installed and used on a personal computer (not a server) provided that: (i) Software is NOT modified; (ii) all copyright notices are maintained on Software; and (iii) you agree to be bound by terms of this License Agreement. Software and Documentation shall be used only by you, only for your own personal or internal business use and not in operation of a service bureau or for benefit of any other person or entity.
You have no ownership rights in Software. Rather, you have a license to use Software as long as this License Agreement remains in full force and effect. Ownership of Software, Documentation and all intellectual property rights therein shall remain at all times with UnityJDBC. Any other use of Software by any person, business, corporation, government organization or any other entity is strictly forbidden and is a violation of this License Agreement.
Software and Documentation contain material that is protected by United States Copyright Law and trade secret law, and by international treaty provisions. All rights not granted to you herein are expressly reserved by UnityJDBC. You may not remove any proprietary notice of UnityJDBC from any copy of Software or Documentation.
You may not publish, display, disclose, rent, lease, modify, loan, distribute, or create derivative works based on Software or any part thereof. You may not reverse engineer, decompile, translate, adapt, or disassemble Software, nor shall you attempt to create source code from object code for Software. You may not transmit Software over any network or between any devices, although you may use Software to make such transmissions of other materials. A registered version of the software cannot be copied between machines or distributed as part of another application or system. A single client license is only valid for the machine where the software is registered.
You acknowledge that Software contains proprietary trade secrets of UnityJDBC and you hereby agree to maintain confidentiality of Software using at least as great a degree of care as you use to maintain confidentiality of your own most confidential information. You agree to reasonably communicate terms and conditions of this Software License Agreement to those persons employed by you who come into contact with Software, and to use reasonable best efforts to ensure their compliance with such terms and conditions, including, without limitation, not knowingly permitting such persons to use any portion of Program for purpose of deriving source code of the program or defeating the registration and key system.
Limitation of Liability
UnityJDBC driver is supplied as is. The author disclaims all warranties, expressed or implied, including, without limitation, warranties of merchantability and of fitness for any purpose. The author assumes no liability for damages, direct or consequential, which may result from use of UnityJDBC driver. In no event will UnityJDBC be liable to you or any third party for any incidental or consequential damages (including, without limitation, indirect, special, punitive, or exemplary damages for loss of business, loss of profits, business interruption, or loss of business information) arising out of use of or inability to use program, or for any claim by any other party, even if UnityJDBC has been advised of possibility of such damages.
This license agreement is expressly made subject to any laws, regulations, orders, or other restrictions on export from Canada of software or information about such software which may be imposed from time to time by government of Canada. You shall not export software, documentation, or information about software and documentation without consent of UnityJDBC and compliance with such laws, regulations, orders, or other restrictions.
This License Agreement is effective until it is terminated. You may terminate this License Agreement at any time by destroying or returning to UnityJDBC all copies of Software and Documentation in your possession or under your control. UnityJDBC may terminate this License Agreement for any reason, including, but not limited to, if UnityJDBC finds that you have violated any of terms of this License Agreement. Upon notification of termination, you agree to destroy or return to UnityJDBC all copies of Software and Documentation and to certify in writing that all known copies, including backup copies, have been destroyed. All provisions relating to confidentiality, proprietary rights, and non-disclosure shall survive termination of this Software License Agreement.
This License Agreement shall be construed, interpreted and governed by laws of Canada without regard to conflicts of law provisions thereof. exclusive forum for any disputes arising out of or relating to this License Agreement shall be an appropriate court sitting in British Columbia, Canada. This License Agreement shall constitute entire Agreement between parties hereto. Any waiver or modification of this License Agreement shall only be effective if it is in writing and signed by both parties hereto. If any part of this License Agreement is found invalid or unenforceable by a court of competent jurisdiction, remainder of this License Agreement shall be interpreted so as to reasonably effect intention of parties.