update/add/delete trigger from sql tables to oracle table

[wanabdba]

I am trying to push user information from 2 sql tables to an oracle table. Does anyone have any experience with this procedure? From the research i have done, i believe an update/add/delete trigger would do this, but how do i define my oracle data source (odbc)???

Thanks in advance

jaime

 

[eramgarden]

have u looked at "linked server"? Not sure, but that comes to my mind for linking between databases.

 

[wanabdba]

no, but i will take a look. thank you