Connection between Vertica and Oracle via ODBC

Igor_Trosko

I've used Vertica 7.2.2 database and I need get data from Oracle database.

I want to use Oracle ODBC for access to the database from Vertica. I've installed Oracle instance client and oracle sqlplus:

oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64
oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64

What additoon packages do I need to install and how I can configure Oracle DSn for Vertica?

 

Adrian_Oprea_1

 

Why don`t you pipe it into Vertica ! 

Use this example here : 

http://www.aodba.com/migrate-sql-server-hp-vertica-single-step/ 

 

use the same template for Oracle

19223

Page you are looking is not found Something Changed ! try the bottom link

Adrian_Oprea_1

http://aodba.com/migrate-sql-server-hp-vertica-single-step/

 

 

19223

Many Thanks, but I need transfer data from Oracle to Vertica database in Linux environment 

rok

Hi 19233,

 

I can't help you with Oracle but googeling "linux oracle odbc" yielded a lot.

 

Of course, you have to get things running first, but if you do not already have a differen solution, I can stronly recommend the ODBCLoader package which approved to be very useful for us.

 

Greets

   rok