You can translate the document:


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 provided that the data source is created with the PostgreSQL adapter and the “Source Configuration” is modified as described in this document.

Future versions and updated 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 a 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 for Yellowbrick:

  1. Log into the administration tool of Virtual DataPort.

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

  1. Enter the following values:

  1. Name: name of the data source.

  1. Database adapter: select PostgreSQL 10.

  1. Database URI: enter the following, replacing “<hostname>” and “<catalog>


Yellowbrick may recommend adding additional parameters to this URI.

  1. Login and Password: enter your Yellowbrick credentials.

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

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

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

Source Configuration Property

Value of the Property

Allow literal as parameter


Supports modifier in aggregate function


Supports Full Eq Outer Join


Delegate OrderBy Collation Modifier


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

To make the change easier, copy the value of this list to an external editor, do the changes there and paste it back.

Note: Denodo will 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 in the Search bar 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.


Virtual DataPort Administration Guide: JDBC Sources

Virtual DataPort Administration Guide: Data Source Configuration Properties


Ask a question

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