Skip to main content

Can Oracle pull data from Vertica

  • April 24, 2017
  • 2 replies
  • 17 views

kanthi_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.

Thanks
Kanthi

2 replies

Forum|alt.badge.img+2
  • Participating Frequently
  • April 25, 2017

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 .


kanthi_vertica
  • Author
  • New Participant
  • April 26, 2017

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.