Data access from one dB to other

[satish]

Dear erman,

apart from dblink,what all the ways we have to access data from oracle to non oracle/oracle databases.

Are DB Links and web services are used to integrate and get data from other external systems?what is the difference and in what cases each one is used...



Thanks

[ErmanArslansOracleBlog]

Yes, you can use db links, web services, some code that have the access drivers for those databases like jdbc, also you can have a replication tool that replicates data from one db to another, a CDC application, a fast and atomic ETL and so on.. you name it..

But db link is the old fashion.. I don't recommend using them for critical and long processes.. The errors on the dblink layer is not catchable most of the time.. Consider a modern approach..