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
Using heterogeneous connector from Oracle to connect to Vertica
Hi!
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.
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.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
