GoldenGate Supported Platforms
Oracle GoldenGate heterogeneity aims to support major
database management systems. Depending on the database type,
support for capture and apply is determined, and whether the
change data capture is log-based. Table 1.1 lists the
current supported database platforms by Oracle GoldenGate
11g and higher.
Database
Platform
|
Log-based
Capture
|
Delivery
|
Oracle Database
|
þ
|
þ
|
Microsoft SQL Server
|
þ
|
þ
|
Oracle MySQL
|
þ
|
þ
|
IBM DB2 for Linux, UNIX and Windows
|
þ
|
þ
|
IBM DB2 for i
|
þ
|
þ
|
IBM DB2 for z/OS
|
þ
|
þ
|
Sybase
|
þ
|
þ
|
SQL/MX
|
þ
|
þ
|
Teradata
|
|
þ
|
Oracle TimesTen
|
|
þ
|
HP Neoview
|
|
þ
|
Netezza
|
|
þ
|
ETL products
|
|
þ
|
JMS message queues
|
|
þ
|
Table 1.1:
Oracle GoldenGate supported databases
The vast majority of database capture method are log-based,
and translated to low-impact, high-performance on the source
database system. The log-based capture technology is a key
differentiator of Oracle GoldenGate.
By comparison, other extraction tools adapt queuing
technology, that highly impact the source database system
performance.
Oracle GoldenGate 12c supports two forms of log-based
capture:
1.
Classic capture.
2.
Integrated capture.
Migration from classic capture to integrated capture is
recommended. Refer to chapter 10 to learn more about
integrated capture.
Supported Operating Systems
On every conceivable platform from a PC to a mainframe,
Oracle GoldenGate offers a foundation for comprehensive
integration environments. Oracle GoldenGate 11g and higher
supports all of the operating systems, as seen in Table 1.2.
Operating system
|
Version
|
Hardware
|
AIX
|
5.1, 5.2 and 5.3
|
IBM PowerPC
|
HP Nonstop
|
D46, D47, D48, G06 and H06
|
NSK
|
HP-UX
|
11.11, 11.23 and 11.31
|
HP Intel IA64 and HP PA-RISC
|
Oracle Linux
|
3.0, 4.0, 5.0 and 6.0
|
AMD/Intel x64, Intel x86 and Intel IA64
|
RedHat AS
|
2.1, 3.0, 4.0 and 5.0
|
AMD/Intel x64, Intel x86 and Intel IA64
|
Solaris
|
8, 9 and 10
|
Sun SPARC
|
SuSE
|
9 and 10
|
Opteron and Intel x86
|
Tru64
|
5.1
|
HP OSF
|
Windows
|
2000, 2003, 2015 and XP
|
AMD/Intel x64, Intel x86 and Intel IA64
|
z/OS
|
1.04 and 1.06
|
Mainframe
|
Table 1.2:
Operating systems support