User Guide Getting Started Help Center Documentation Community Training

To use Looker with DataVirtuality, you will need to configure a DataVirtuality driver. These instructions describe that process, assuming use of a startup script similar to the examples provided here.

You will need to acquire a DataVirtuality driver JAR, include it as part of the startup process, and add an option to tell Looker to access it.

Installing the driver

  1. Move the driver JAR to a subdirectory. For example:

    # log in as the looker user
    cd ~/looker
    mkdir ~/looker/custom_jdbc_drivers
    mv ~/datavirtuality-jdbc.jar  ~/looker/custom_jdbc_drivers/datavirtuality-jdbc.jar
  2. Create a configuration file.

    Create a configuration file for the new driver, if one does not already exist in the ~/looker directory:

    vim ~/looker/custom_jdbc_config.yml

    and add the following:

    - name: datavirtuality
      file_name: datavirtuality/custom_jdbc_drivers/datavirtuality-jdbc.jar
      module_path: com.datavirtuality.dv.jdbc.Driver
  3. Tell Looker to use the new driver.

    If you’re already using a lookerstart.cfg file, just add another startup option to that. If not you can add it directly to your startup script or create one (recommended):

    vim lookerstart.cfg

    and add the --use-custom-jdbc-config to the list of LOOKERARGS environment variables. Make sure to leave any other configs that are set there:

  4. Restart Looker:

    ./looker restart

Feature Support

Looker’s ability to provide some features depends on whether the database dialect can support them.

In the current Looker release, DataVirtuality supports the following Looker features: