Using heterogeneous connector from Oracle to connect to Vertica

Sreehari_1

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

id10t

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.