db Link in vertica

Hi, we are doing migration from Td to vertica. we wanto check if db link features is available in vertica. If so pls let us know the details. Earlier when we did a migration from sybase to oracle. we have created a db link in orcale and used scripts to compare the source & target data. wanted to try something similar way to ensure that the data validation is done correctly.


  • Options
    Prasanta_PalPrasanta_Pal - Select Field - Employee
    As per knowledge, I do not find any dblink for vertica. But surely, you can copy the ORACLE data to Vertica using a unix shell script. Use COPY command in Vertica. In a shell script, pipe the output from oracle to Vertica in COPY command ( using input as STDIN) and then run the script. This shell script can also be used as STORED PROC in Vertica and running this Stored Proc from Vertica will pull the data from Oracle to Vertica. Any one in the forum may please add more information if I haved missed any thing.
  • Options
    Members of my team have been able to dblink from SQL Server to Vertica. So, that would indicate that it is very possible to go from another platform that provides dblink capabilities to Vertica.
  • Options
    I would love to see more about this "dblink"! 
  • Options
    May I please get a copy of the shell script and also the STORED PROC in Vertica?  Appreciate your prompt response.

Leave a Comment

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