UnityJDBC allows RazorSQL users to create a virtual data source that may consist of multiple data sources on different servers and platforms. The user can enter one SQL query to combine and join information from multiple sources.
UnityJDBC allows RazorSQL to support multiple database queries.
No data source or server changes are required.
UnityJDBC will perform function translation where a user requests a function that is not supported on a certain source.
This example assumes that the installation of UnityJDBC has already been completed, and that the user has already created a data virtualization using the UnityJDBC SourceBuilder. The following is an example of creating sources and executing multiple database queries with RazorSQL.
Installing the Jars - Copy the
unityjdbc.jar into the RazorSQL JRE directory (e.g.
C:\Program Files (x86)\RazorSQL\jre\lib\ext).
Setup RazorSQL - Start RazorSQL. Add a UnityJDBC
connection profile under menu
Setup RazorSQL - Part 2 - Select OTHER then press the CONTINUE button.
Setup RazorSQL Connection Profile - When setting up the connection profile, the profile name can be anything you wish. The driver location is where you just put the
unityjdbc.jar. The driver class is
unity.jdbc.UnityDriver. There is no login or password. The JDBC URL is the location of the configuration files for the virtual sources. In this example, we put the files
UnityDemoPart.xml that came in the distribution in the directory
c:/temp/unityjdbc. You will change this to your source files that you built using the SourceBuilder utility.
RazorSQL Multiple Database Connection and Query - Connect to the connection profile. You can then see tables from all your virtual sources and built a multiple database query.
A few possible setup errors and their resolution:
Unable to make a connection - If you do not type the connection string correctly or you have not put the XML files in the right location, you will get the error below. To fix, verify the location of the files.
Unable to find driver - If you did not put the correct class name or location of the
unityjdbc.jar, you will get the following error. Verify the class name and jar location to resolve.