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

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

Ryan_Weber

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

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

I copied the Postgresql technology and was able to use it for some basic operations without any modifications. 

lerat_sylvain

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