UnityJDBC Data Virtualization with RazorSQL

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.

Benefits:

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.

  1. Installing the Jars - Copy the unityjdbc.jar into the RazorSQL JRE directory (e.g. C:\Program Files (x86)\RazorSQL\jre\lib\ext).

  2. Setup RazorSQL - Start RazorSQL. Add a UnityJDBC connection profile under menu Connection->Add Connection Profile.

    RazorSQL: Adding a New Connection Profile

  3. Setup RazorSQL - Part 2 - Select OTHER then press the CONTINUE button.

    RazorSQL: Adding a UnityJDBC Virtual Connection using OTHER Option

  4. 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 UnityDemo.xml, UnityDemoOrder.xml, 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: Creating a UnityJDBC Virtual Connection

  5. 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.

    RazorSQL: Executing a Multiple Database Join with UnityJDBC

A few possible setup errors and their resolution:

  1. 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.

    RazorSQL: Error When Unable to Find Sources File

  2. 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.

    RazorSQL: Error When Unable to Find Driver or Incorrect Driver Class Name