Using heterogeneous connector from Oracle to connect to Vertica

In our application we want to move results of query fired on Vertica to Oracle database. Currently it is done by spooling the query results to a csv file and later loading it in Oracle using sqlldr, this is bit complex and error prone, can we use the heterogeneous connector from Oracle for this ?.
http://docs.oracle.com/cd/B28359_01/server.111/b28277/tgvsgc.htm

Comments

  • Hi!
    can we use the heterogeneous connector from Oracle for this ?.
    The answer is - yes, you can use in non-heterogeneous connector, but you need to develop this functionality. Use it, good luck, don't see a problem.


    PS
    It require an agent and Vertica has no agent for this purposes, but defenitly you can use in non-heterogeneous connector, Vertica has no restriction on this.
    image

Leave a Comment

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