Options

Load data from Vertica to Oracle db

MoviMovi
in General Discussion

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

 

Comments

  • Options
    FiliNFiliN

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...