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 and provides an adapter for Yellobrick. Also, Denodo provides support for Yellowbrick as a cache database, which including the support for loading data using its “Bulk DataLoad API”
Connecting to Yellowbrick
Follow these steps to create a JDBC data source for Yellowbrick:
- Log into the Virtual DataPort Administration Tool or Web Design Studio .
- Click on the menu File > New > Data source. This will open the wizard to create a JDBC data source.
- Enter the following values:
- Name: name of the data source.
- Database adapter: select Yellowbrick.
- Database URI: enter the following, replacing “<hostname>” and “<database>”
jdbc:postgresql://<hostname>:<port 5432>/<database>?loglevel=0&loginTimeout=30&socketTimeout=30&ApplicationName=Denodo |
Yellowbrick may recommend adding additional parameters to this URI.
- Login and Password: enter your Yellowbrick credentials.
- Click Test Connection. If the test is successful, click Save.
- 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.
6. Select the tables/views you want to create a base view over and then click Create selected.
References
Data Source Configuration Properties
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.