#Pentaho data integration 6.0 driver

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.

#Pentaho data integration 6.0 how to

This document explains how to configure these connections using JDBC.Ĭonnecting to Denodo from Pentaho Report Designer :Īt .(Database.java:459)Īt .(Database.java:357)Īt .(Database.java:328)Īt .(Database.java:318)Īt .(DatabaseFactory.java:80)Īt .(DatabaseMeta.java:2734)Īt .(DataHandler.java:588)Īt 0(Native Method)Īt (NativeMethodAccessorImpl.java:62)Īt (DelegatingMethodAccessorImpl.java:43)Īt .invoke(Method.java:497)Īt .(AbstractXulDomContainer.java:313)Īt .(AbstractXulComponent.java:157)Īt .(AbstractXulComponent.java:141)Īt .access$500(SwtButton.java:43)Īt .$4.widgetSelected(SwtButton.java:136)Īt .TypedListener.handleEvent(Unknown Source)Īt .ndEvent(Unknown Source)Īt .ndEvent(Unknown Source)Īt .nDeferredEvents(Unknown Source)Īt .Display.readAndDispatch(Unknown Source)Īt .nEventLoop(Window.java:820)Īt .Window.open(Window.java:796)Īt .show(SwtDialog.java:389)Īt .show(SwtDialog.java:318)Īt .ui.open(XulDatabaseDialog.java:116)Īt .ui.open(DatabaseDialog.java:60)Īt .ui.(SpoonDBDelegate.java:470)Īt .ui.(SpoonDBDelegate.java:457)Īt .ui.(Spoon.java:8750)Īt .access$100(JfaceMenuitem.java:43)Īt .$1.run(JfaceMenuitem.java:106)Īt .nWithEvent(Action.java:498)Īt .ActionContributionItem.handleWidgetSelection(ActionContributionItem.java:545)Īt .ActionContributionItem.access$2(ActionContributionItem.java:490)Īt .ActionContributionItem$5.handleEvent(ActionContributionItem.java:402)Īt .ui.(Spoon.java:1339)Īt .ui.(Spoon.java:7939)Īt .ui.(Spoon.java:9214)Īt .ui.(Spoon.java:653)Īt .Launcher.main(Launcher.java:92)Ĭaused by: .:Īt .(Database.java:574)Īt .(Database.java:443)Ĭaused by: : org/apache/hive/service/cli/thrift/TCLIService$IfaceĪt .nnect(HiveDriver.java:105)Īt (DriverManager.java:664)Īt (DriverManager.java:247)Īt .(Database.java:554)Ĭaused by: : .$IfaceĪt (URLClassLoader.java:381)Īt (ClassLoader.java:424)Īt (ClassLoader.This document describes how to connect to a Denodo Virtual DataPort server from Pentaho Report Designer and from Pentaho BI Server (User Console). Org/apache/hive/service/cli/thrift/TCLIService$Iface At the end when I try to connect, I get the following errors: Error connecting to database : .:Įrror occurred while trying to connect to the databaseĮrror connecting to database: (using class .HiveDriver)

I have added Hive JDBC jar file from this web link. I tried connecting to Pentaho by using connection type:Hadoop-Hive 2, Database name:default and Port No:10000. The details of Hadoop system are as follows: I have configured Hadoop on 'Bare metal server'.

#Pentaho data integration 6.0 windows 7

I have installed Pentaho 6.0 on my Windows 7 (Professional 64bit). I am trying to connect Pentaho to Hive, so that I can run Hive queries through Pentaho.