Skip to main content

How to Connect Vertica to Oracle Data Integrator (ODI v10) ?

  • August 30, 2013
  • 5 replies
  • 26 views
lerat_sylvain
Hello Did someone has already connected Vertica to Oracle Data Integrator (ODI v10) ? We tried but it doesn't seem to work We put the Vertica Driver vertica-jdk5-6.1.2-0.jar in the oracledi_10.1.3.6.0\oracledi\drivers directory on the ODI server (ODI v10) and we can't see it in the selection list ot the topology part of ODI to create the connection. More over using the sun.jdbc.odbc.JdbcOdbcDriver instead of the vertica with this parameter : "jdbc:vertica://ppfga1ver01.hosting.eu:5433/giftcard" did not work too. We get "No suitable Driver" Any help will be appreciated ? Thanks ! Sylvain

    5 replies

    Ryan_Weber
    • Ryan_Weber
    • New Participant
    • September 20, 2013
    In v11, I was able to connect by adding the JDK driver and then manually typing "com.vertica.jdbc.Driver" for the JDBC Driver parameter and the JDBC Url in the "jdbc:vertica://host:port/db" syntax. Hope this helps.
    lerat_sylvain
    • lerat_sylvain
    • Author
    • New Participant
    • September 26, 2013
    Thanks Ryan for the answer we'll need to upgrade our ODI platform so it is a good thing to know that it will possible to connect it with our Vertica database. Which technology do use in ODI to create topology with Vertica ? Did you have to create the mapping by your own ? or did you find one already created for Vertica ? Thanks ! Sylvain
    Ryan_Weber
    • Ryan_Weber
    • New Participant
    • October 1, 2013
    I copied the Postgresql technology and was able to use it for some basic operations without any modifications.
    lerat_sylvain
    • lerat_sylvain
    • Author
    • New Participant
    • October 2, 2013
    Thanks Ryan !
    Really appreciate your help ! I will try it
    Abhishek_Gupta_1
    Ryan, good morning!

    Could you please suggest what were those basic operations that you did. I also copied PostgresSQL Technology and renamed it as "Vertica" . I put the vertica driver jar file at driver location and userlib location. Now, I am able to create a vertica connection successfully.

    Now, I have two vertica tables i.e. source and target tables, where I have created an interface in ODI to move data from source table to target table.

    But, while executing the job through ODI, I am getting below error :

    2015-02-02 05:37:03.455 ERROR ODI-1217 Session Char65k_Table_Interface (39001) fails with return code 7000.

    I need to fix this issue ASAP. Any help would be highly appreciated.

    Thanks,
    Abhi
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement