Oracle to Vertica integration tool

[adrian.oprea]

Hy everybody ,
I have seen there are ways to implement Mysql to Vertica integration thrw Tungsten Replication Tool.
I there away to do this with Oracle -> Vertica ?
I any has any ideas or any exp please share !!

[adrian.oprea]

I see that is nobody who knows anything about this !!
- so i was thinking this last days how can i use the log miner from oracle in parsing the redo log / or arch logs from oracle into flat file script that will automaticlly update Vertica !!
- So what do you guys think ?
Is not going to be real time transactions due to the vertica bad update performance !! but is going to work !!
Any ideas how i can improve this ?
THX

[JimKnicely]

Hi Adrian,

Mining the log is pain

Have you heard of "Heterogeneous Connectivity" from Oracle? Check out the docs here:

http://www.oracle.com/pls/db111/gateways

I wonder if the "Gateway for ODBC for ODBC User's Guide" is for you?

Just curious, what kind of data do you plan on moving into Vertica? How many tables are involved? If you have some sort of transaction date on the table rows could you write a small SQL*Plus script to extract all data every so often with a transaction date greater than the last date you moved data into Vertica into a flat file formatted for a Vertica COPY command and then use COPY LOCAL to load that data into Vertica?

Thanks!

[adrian.oprea]

Ok that is nice way !
Is vertica working on something like this ?