connect to vertica 9.1

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,.