Skip to main content

Load data from Vertica to Oracle db

  • August 11, 2015
  • 1 reply
  • 6 views

Movi

Hi

 

Currently the upstream system consumed by our application is using Oracle Db servers and We are fetching data by running jobs into our Oracle Schemas without any problem.

 

Now  the upstream system is moving to Vertica platform

1)What is the efficient strategy to fetch data in an automated fashion on a dialy basis?

2)Does Vertica Support the concept of DBlinks , if not what is the alternative solution ?

 

 

 

Thanks

 

1 reply

FiliN
Forum|alt.badge.img
  • Participating Frequently
  • August 13, 2015

You can fetch data into csv file by using bash and vsql for example.