As before, the driver class name is .Driver, and the connection URL must be like this: jdbc:vdb://host:port/database. Provide a connection name and fill the Settings to configure it. Select Generic Database as the connection type and Native(JDBC) as acces.Create a new Database Connection: go to Manage Data Sources, click on and then click on New Connection :.However, to add a new connection to Denodo VDP in the User Console interface and use it to make reports on the web application, follow these steps: Once the JDBC driver is installed, all the reports made with PRD and uploaded to the User Console can access the Denodo VDP server and can run in the User Console web application. After adding the JDBC driver, the BI Server must be restarted. As before, the driver file can be copied from the folder /tools/client-drivers/jdbc of a Denodo installation to the /tomcat/lib folder of the BI Server. Now it is possible to create data sources using the Denodo VDP connection to make reports:Ĭonnecting to Denodo from Pentaho User Consoleįirst of all, to use the Denodo’s JDBC driver in the Pentaho User Console, the driver must be manually installed on the Pentaho BI Server.Ĭlick on Test to verify that the connection was created successfully. The driver class name is .Driver, and the connection URL must be like this: jdbc:vdb://host:port/database. Enter a connection name that uniquely describes this connection, and fill the Settings to configure it. Select Generic Database as the connection type and JDBC as access type.Go to Data >Add Datasource-> JDBC ( datasource JDBC(Custom) is deprecated ) :.Once the JDBC driver is added to the PRD installation, creating a new connection to access Denodo VDP from the PRD application is very simple. After adding the Denodo JDBC driver the PRD must be restarted. The driver file can be copied from the folder /tools/client-drivers/jdbc of a Denodo installation to the /lib folder. As Denodo’s JDBC driver is not pre-installed as part of the PRD, the driver must be manually installed. Pentaho Report Designer (PRD) allows us to configure several connections and data sources, including custom JDBC connections.
This document explains how to configure these connections using JDBC.Ĭonnecting to Denodo from Pentaho Report Designer This document describes how to connect to a Denodo Virtual DataPort server from Pentaho Report Designer and from Pentaho BI Server (User Console).