从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