从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