从Oracle数据库连接到非Oracle数据库和外部数据源的几种方法:
参考自:
Options for Connecting to Foreign Data Stores and Non-Oracle Databases - For Example - DB2,sql*Server,Sybase,Informix,Teradata,MysqL (Doc ID 233876.1)
其实,有如下几种方法可以从Oracle数据库连接到非Oracle数据库和外部数据源
1.Oracle Gateways 2.Procedural Gateways 3.Generic Connectivity 4.OCI and JDBC 4.1 Oracle Call Interface 4.2 JDBC 5.Access Managers 6.Migrating to Oracle 6.1 Oracle sql*Developer 6.2 Oracle Migration Workbench 10.1.0.4 6.3 Migration Toolkits 6.4 Other Options 7. 12c Features 8. Replicating Data Using GoldenGate