Load data from Vertica to Oracle db



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 ?







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

Leave a Comment

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