The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Can Oracle pull data from Vertica

Hello All,

I have an application with back end as Oracle and it needs to pull data from Vertica database.

Is it possible . I was able to find stuff on pulling data into Vertica from Oracle but not the other way around.

Any help/suggestions are greatly appreciated.



  • skamatskamat Administrator

    Never been asked this question before as most of our customers are moving data in other direction. In any case, moving data into flat file and then uploading into Oracle or using some ETL tool could be your options .

  • Can't do data dumps as its an Oracle based application which needs to pull data dynamically based on user requests. Its something like BO reporting tool. Any ODBC drivers that we can use.

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.