We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Connection between Vertica and Oracle via ODBC — Vertica Forum

Connection between Vertica and Oracle via ODBC

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?

 

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file