Replicating between Cloud and On-Premises using Oracle GoldenGate
- by Ananth R. Tiru
Do you have applications running on the cloud that you need to
connect with the on premises systems. The most likely answer to this question
is an astounding YES! If so, then you
understand the importance of keep the data fresh at all times across the cloud
and on-premises environments. This is also one of the key focus areas for the
new GoldenGate
12c release which we announced couple of week ago via a press release.
Most enterprises have
spent years avoiding the data “silos” that inhibit productivity. For example,
an enterprise which has adopted a CRM strategy could be relying on an
on-premises based marketing application used for developing and nurturing leads.
At the same time it could be using a SaaS based Sales application to create
opportunities and quotes. The sales and
the marketing teams which use these systems need to be able to access and share
the data in a reliable and cohesive way. This example can be extended to other applications areas such as HR,
Supply Chain, and Finance and the demands the users place on getting a
consistent view of the data.
When
it comes to moving data in hybrid environments some of the key requirements include
minimal latency, reliability and security:
Data
must remain fresh. As data ages it becomes less relevant and less
valuable—day-old data is often insufficient in today’s competitive landscape.
Reliability
must be guaranteed despite system or connectivity issues that can occur between
the cloud and on-premises instances.
Security is a key concern
when replicating between cloud and on-premises instances. There are several options
to consider when replicating between the cloud and on-premises instances.
Option 1 – Secured network established between the
cloud and on-premises
A secured network is
established between the cloud and on-premises which enables the applications (including
replication software) running on the cloud and on-premises to have seamless
connectivity to other applications irrespective of where they are physically
located.
Option 2 – Restricted network established between the
cloud and on-premises
A restricted network is
established between the cloud and on-premises instances which enable certain
ports (required by replication) be opened on both the cloud and on the
on-premises instances and white lists the IP addresses of the cloud and
on-premises instances.
Option 3 – Restricted network access from on-premises
and cloud through HTTP proxy
This option can be considered when the ports required by the
applications (including replication software) are not open and the cloud
instance is not white listed on the on-premises instance. This option of tunneling through HTTP proxy
may be only considered when proper security exceptions are obtained.
Oracle GoldenGate
Oracle GoldenGate is used for major Fortune 500 companies
and other industry leaders worldwide to support mission-critical systems for
data availability and integration. Oracle GoldenGate addresses the requirements
for ensuring data consistency between cloud and on-premises instances, thus
facilitating the business process to run effectively and reliably. The
architecture diagram below illustrates the scenario where the cloud and the
on-premises instance are connected using GoldenGate through a secured network
In the above scenario, Oracle
GoldenGate is installed and configured on both the cloud and the on-premises
instances. On the cloud instance Oracle
GoldenGate is installed and configured on the machine where the database
instance can be accessed. Oracle
GoldenGate can be configured for unidirectional or bi-directional replication
between the cloud and on premises instances.
The
specific configuration details of Oracle GoldenGate processes will depend upon
the option selected for establishing connectivity between the cloud and
on-premises instances. The knowledge
article (ID - 1588484.1) titled '
Replicating between Cloud and On-Premises using Oracle GoldenGate'
discusses in detail the options for replicating between the cloud and
on-premises instances. The article can
be found on My Oracle Support.
To learn more about Oracle GoldenGate 12c register for our launch webcast where we will go into these new features in more detail. You may
also want to download our white paper "Oracle
GoldenGate 12c Release 1 New Features Overview"
I would love to hear your requirements for replicating
between on-premises and cloud instances, as well as your comments about the strategy
discussed in the knowledge article to address your needs. Please post your
comments in this blog or in the Oracle GoldenGate public forum - https://forums.oracle.com/community/developer/english/business_intelligence/system_management_and_integration/goldengate