connect to vertica 9.1

hkhan

Error trying to establish a jdbc connection from Pentaho report designer to Vertica database.

Downloaded report designer from
https://community.hitachivantara.com/docs/DOC-1009856

is there a documentation on how to get this started with?

Platform version being used:
Pentaho report designer version 7.1.0.0 - 12
Vertica Analytic Database v9.1.0-1
macOS high Sierra Version 10.13.6

s_crossman

Hi,

We've got a connection guide that was done for Pentaho Business Analytics 8.1. I couldn't find any indication we had done anything with Pentaho Reporting. While most of our connection guides and quickstarts are based on Windows or Linux clients and servers, the general principals for JDBC connections are the same, so possibly the guide would help. It's at:
https://www.vertica.com/kb/Vertica-Integration-with-Pentaho-Business-Analytics/Content/Partner/Vertica-Integration-with-Pentaho-Business-Analytics.htm

Also, the Pentaho site you cited has a JDBC driver page that lists Vertica and the specific info needed for the driver including the connection string url, classname, and db port.

https://help.pentaho.com/Documentation/8.2/Setup/JDBC_Drivers_Reference#Vertica

The error you are getting sounds like Pentaho can't locate the Vertica driver. So possibly either it's not in the right location or the JAVA classpath that Pentaho is using doesn't include it's location. Those are the two things I'd recommend checking first. Unfortunately we haven't had any exposure to the Reporting, so can't provide you any specifics on either of those items..

I hope it helps,.