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
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
Create a configuration file.
Create a configuration file for the new driver, if one does not already exist in the
and add the following:
- name: datavirtuality file_name: datavirtuality/custom_jdbc_drivers/datavirtuality-jdbc.jar module_path: com.datavirtuality.dv.jdbc.Driver
Tell Looker to use the new driver.
If you’re already using a
lookerstart.cfgfile, just add another startup option to that. If not you can add it directly to your startup script or create one (recommended):
and add the
--use-custom-jdbc-configto the list of
LOOKERARGSenvironment variables. Make sure to leave any other configs that are set there:
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: