Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Kettle Not Working With Vertica

  1. #1
    Join Date
    Oct 2013
    Posts
    3

    Post Kettle Not Working With Vertica

    I am writing a simple transformation to read CSV file and write the data to a Vertica db. I am getting the following error when I try to test a Vertica connection. Really appreciate some help and pointers!

    I am using - Vertica 6 and Spoon 4.4

    I tried the following to resolve the error -Copied the following two jars and added them to libext/jdbc - vertica-jdbc-4.1.14.jar and vertica-jdk5-6.1.2-0.jar
    But the above dint help. Looking for pointers! Please help.


    Error:
    Error connecting to database [Vertica Dev] : org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database


    Exception while loading class
    com.vertica.jdbc.Driver




    org.pentaho.di.core.exception.KettleDatabaseException:
    Error occured while trying to connect to the database


    Exception while loading class
    com.vertica.jdbc.Driver




    at org.pentaho.di.core.database.Database.normalConnect(Database.java:366)

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    Try using the Vertica 6 JDBC driver, rather than the Vertica 4 JDBC driver.
    **THIS IS A SIGNATURE - IT GETS POSTED ON (ALMOST) EVERY POST**
    I'm no expert.
    Take my comments at your own risk.

    PDI user since PDI 3.1
    PDI on Windows 7 & Linux

    Please keep in mind (and this may not apply to this thread):
    No forum member is going to do your work for you. We will help you sort out how to do a specific part of the work, as best we can, in the timelines that our work will allow us.
    Signature Updated: 2014-06-30

  3. #3
    Join Date
    Oct 2013
    Posts
    3

    Default

    Quote Originally Posted by gutlez View Post
    Try using the Vertica 6 JDBC driver, rather than the Vertica 4 JDBC driver.
    Thanks That works!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.