1. Background Information
Let me give some background information to help you understand the support discussion later.
1.1 What is GGCS?
GGCS is now an unmanaged PaaS service, which means GGCS provides a virtual machine hosting the software, and you as a user need to configure and to maintain the software execution. GGCS now has the following Oracle GoldenGate software installed on the virtual machine by default:
- Oracle GoldenGate for Oracle DB 12.2
- Oracle GoldenGate for Big Data 12.3.0.1
- Oracle GoldenGate for MySQL 12.2
1.2 What is Oracle GoldenGate Remote Capture and Delivery?
Oracle GoldenGate 12.2 now supports remote capture and delivery for the following databases/servers:
- Oracle Database (capture/delivery)
- MySQL (delivery)
- DB2 LUW (capture/delivery)
- Informix (capture/delivery)
- Big Data (delivery)
- Teradata (delivery)
- DB2 for iSeries (delivery)
- Microsoft SQL Server (delivery)
- JMS (capture/delivery)
2. What is Supported?
Let's talk about what's supported.
2.1 GGCS Supported Sources and Targets on Oracle Public Cloud
When running Oracle GoldenGate Cloud Service (GGCS), the following sources and targets are certified on Oracle Public Cloud:
- Capture and Delivery
- Oracle Database Cloud Service and Oracle Database Cloud Exadata Service: Oracle Database 11g and 12.1 (Delivery only support for DB 12.2)
- Delivery Only
- Oracle Big Data Cloud Service: HIVE, HBASE, HDFS, Flume, and Kafka
- Oracle MySQL Cloud Service
2.2. GGCS Supported Source and Target On-Premises and 3rd Party Cloud
GGCS can be configured to perform Remote Capture and Delivery for the On-Premises Databases and Databases running on the 3rd Party Cloud and the following sources and targets are the supported:
- Remote Capture and Delivery
Note that the operating system running the database has to have the same endian as LINUX.- Oracle Database 11g and 12.1 (No 12.2 capture support) (Oracle Database Cloud Service on Oracle Cloud Machine, Oracle Exadata Cloud Machine)
- Informix, Sybase ASE, DB2 LUW *
(Additional software installations are needed on GGCS.)
- Remote Delivery Only
Note that the operating system running the database has to have the same endian as LINUX.- Big Data Repositories: Apache Hadoop, HBase, Hive, Flume and Kafka; Storm, Spark, Oracle NoSQL,MongoDB,Cassandra; Amazon Redshift, IBM PureData System for Analytics (Netezza)
- MySQL and MySQL Cluster
- TimesTen,PosgreSQL, File Adapter, Teradata(Additional software installations are needed on GGCS)
- Working with Oracle GoldenGate
Oracle GoldenGate Cloud Service (GGCS) can communicate with all of the supported on-premise Oracle GoldenGate. Therefore, if you have Oracle GoldenGate on-premise installs, you can set up the replication with GGCS.