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 ?