By Joe deBuzna, Director, Oracle Data Integration Product
Fix your out of sync data with a single click using the new
Oracle GoldenGate Veridata 12.3 heterogeneous data repair feature!
I am so happy to finally be typing that sentence because I
get asked about the Veridata Repair feature all the time. So YES, it’s really here!
Call me biased, but this is one of the most highly sought after, killer
features in the Oracle Data Integration product line, if not all of Oracle Fusion
Middleware. And while it’s part of the Oracle GoldenGate product suite, it can compare
and fix data between any
two databases regardless of how you’re moving the data around: Oracle GoldenGate, Oracle Data Integrator, Oracle Streams, Logical Data Guard, Oracle
Advanced Replication, SQL scripts, custom batch jobs, SQL*Loader – it does not
matter! As long as Veridata has the right database connection permissions and
supports the platform, you’re good to go.
And why does data go out of sync? Let me count the main
ones, so we can keep this post short and sweet. The big ones we see include bad
source data (e.g. out of bounds characters from wrong NLS settings and bad
dates) got inserted or updated, no logging source operations caused data gaps
in logical replication products, and bulk data loads/copies into target systems
were timed incorrectly (improperly “instantiated” for replication). And here’s
the one we don’t like to talk about: we work in extremely complicated IT environments
and sometimes people just make mistakes. Sometimes we inherit those mistakes.
And it’s ok to have mistakes. But far
better if you can quickly identify them and it is absolutely crucial to fix them
as soon as possible to avoid domino effects of inconsistent data.
So don’t just hope your data is in sync, prove it and have confidence knowing it. Have confidence when you’re about to pull the switch on
your cloud migration or failover; have confidence looking your CEO in the eye
telling him that his “single source of truth” still is; have confidence that
complex, multi-master conflict detection and resolution setup you designed, or
inherited, is actually keeping everything in sync.
You can learn more about the repair feature via a few new
resources we have for you below. Take a look and see how you can pick and
chose only which tables and specific rows you want to repair; what we did to
make this feature fast and secure; how we can suppress target triggers; and
You can also watch a half hour video of me talking about and
giving a demo of both Oracle GoldenGate Veridata and Monitor 12.1.3 here:
For Oracle GoldenGate Veridata 12.1.3 we now include in a single download Oracle
GoldenGate Veridata Server, Veridata Java agents, Oracle GoldenGate Monitor
Server, and Oracle GoldenGate Monitor agents. This single download can be found
on eDelivery.oracle.com and on our Oracle Technology Network page.
And since we’re now based on Oracle Weblogic Server 12.1.3,
you’ll need to also download the Oracle Application Development Runtime
To see which platforms are supported, you can click on the
Certifications tab in My Oracle Support, or download the spreadsheet “System
Requirements and Supported Platforms for Oracle Fusion Middleware 12c (12.1.3)”.
Finally, please feel free to leave comments and feedback
below. For those willing to share, I’m always looking for interesting stories
on how you’ve seen data going out of sync and how you ended up fixing it.