How to connect to Yellowbrick from Denodo

Applies to: Denodo 7.0
Last modified on: 10 Jul 2019
Tags: Data warehouse Yellowbrick JDBC data sources

Download document

Goal

This document describes how to create a JDBC data source in Denodo to query Yellowbrick.

Currently, Denodo provides support for Yellowbrick as a data source in Denodo 7.0, provided that the data source is created with the PostgreSQL adapter and the “Source Configuration” is modified as described in this document.

Future updates of Denodo will include the following:

  • An adapter specific for Yellowbrick so users do not have to modify the “Source Configuration” of the data source.

  • Support for Yellowbrick as cache database, including the support for loading data using its “Bulk Data Load API”.

Connecting to Yellowbrick

Follow these steps to create a JDBC data source to Yellowbrick:

  1. Log into Yellowbrick’s support site and download its JDBC driver. Yellowbrick provides several flavors of the driver. The supported one is the PostgreSQL PGJDBC-NG.

    The name of the file you download should be similar to
    pgjdbc-ng-0.5-complete.jar.

  1. Copy the driver to your installation of Denodo (<DENODO_HOME>).
  1. It is recommended to copy JDBC drivers to the folder <DENODO_HOME>/lib-external/jdbc-drivers/database name - version.

For example, in this case, create the folder ’yellowbrick-0.5’ and copy the driver to <DENODO_HOME>/lib-external/jdbc-drivers/yellowbrick-0.5

  1. Log into the administration tool of Virtual DataPort.

  1. Click the menu File > New > Data source > JDBC. This will open the wizard to create a JDBC data source.


  1. Enter the following values:

  • Name: name of the data source.

  • Database adapter: select PostgreSQL 10.

  • Driver class path: enter the path to the file pgjdbc-ng-0.5-complete.jar. If you have copied the driver to the recommended location you can just enter the folder name, in our previous example ’yellowbrick-0.5’, otherwise browse to the file location.

  • Driver class: enter com.impossibl.postgres.jdbc.PGDriver

  • Database URI: enter the following, replacing “<hostname>” and “<catalog>” jdbc:pgsql://<hostname>:5432/<catalog>?networkTimeout=30000&applicationName=YB

Yellowbrick may recommend adding additional parameters to this URI.

  • Login and Password: enter your credentials in Yellowbrick.

  1. Click Test Connection. If the test is successful, click Save.

  1. Go to the Source Configuration tab and do the following changes:

  1. Change the value of the following properties to the value on the right column:

Source Configuration Property

Value of the Property

Allow literal as parameter

No

Supports modifier in aggregate function

No

Supports Full Eq Outer Join

No

Delegate OrderBy Collation Modifier

No

  1. Select the check box next to Delegate scalar functions list and remove the following functions from the list:
  • log
  • round

Consider copying the value of this list on an external editor, do the changes there and paste it back.

In future updates of Denodo, doing these changes will not be necessary.

Denodo may add support for delegating the functions log and round to Yellowbrick.

  1. After creating the data source, click Create base view.

The Tool will display the schemas of the database. Expand a schema to inspect its tables/views and their fields. To search a view or a schema, type its name on the Search located at the top of the dialog. The list will show the elements whose name contains the text you entered.  

  1. Select the tables/views you want to create a base view over and then, click Create selected.

References

Virtual DataPort Administration Guide: JDBC Sources

Virtual DataPort Administration Guide: Data Source Configuration Properties

Questions

Ask a question
You must sign in to ask a question. If you do not have an account, you can register here

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training