Tuesday Jul 08, 2014

Oracle GoldenGate Veridata Repair is here!

By Joe deBuzna, Director, Oracle Data Integration Product Management

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 more:

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:

Oracle University Learning Stream video for Oracle GoldenGate Monitor and Oracle GoldenGate Veridata.

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 Infrastructure.

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.


Friday Aug 23, 2013

Ensuring Data Consistency with Oracle GoldenGate Veridata

Today’s 24/7/365, fast-paced world brought the need for high data availability and with that came redundant distributed copies of the data. In our complex IT environment, maintaining data consistency across these distributed systems is not a trivial task unfortunately. Data discrepancy occurs for many reasons, including database configuration differences between source and target, configuration errors during data migration, user errors, gaps in data replication or replication lags. Even when using products that replicate data reliably, such as Oracle GoldenGate, there remain potential causes of data discrepancy.

When data discrepancies occur, businesses can see its impact in the form of incorrect decision-making; failed service-level agreements; and ultimately, operational, financial, and legal risk.

Oracle GoldenGate Veridata helps companies avoid these risks and operate their redundant systems with high confidence knowing that their backup systems, reporting databases, multi-master replication environments have consistency. Oracle GoldenGate Veridata provides an easy-to-use yet powerful solution for identifying out-of-synch data before it negatively impacts the business.

Deployed together with the Oracle GoldenGate real-time data replication  product or separately, Oracle GoldenGate Veridata ensures data consistency is maintained across databases. The software enables periodic checks—as frequently as desired—between heterogeneous source and the target databases without taking either system offline.

Some of the benefits of the product include:

  • Reduced risk exposure. Knowing about data inconsistencies can help address issues before they impact business operations. Oracle GoldenGate Veridata identifies data discrepancies so that corrective measures can be quickly taken.
  • Improve IT Productivity. Oracle GoldenGate Veridata's automated data comparison capabilities reduces the time and resources required for data validation Graphical illustrations and detailed reports clearly convey the key results and specific data disparities so that IT can take immediate corrective action. If there are no inconsistencies, users can document the accuracy of their data for regulatory compliance reporting needs.
  • Continuous operation during validation. With its ability to compare in-flight transactions, Oracle GoldenGate Veridata supports databases that are in use without interrupting business operations. Combining a light footprint and groundbreaking technology, the application imposes minimal impact on technology infrastructure.

If your organization has strict requirements to keep redundant systems consistent, I highly recommend reading more about Oracle GoldenGate Veridata product via our new white paper: Ensuring Data Consistency with Oracle GoldenGate Veridata.

You can also find out best practices on installation and configuration in the Oracle GoldenGate Veridata Handbook on My Oracle Support (Knowledge ID 1583563.1.)

About

Learn the latest trends, use cases, product updates, and customer success examples for Oracle's data integration products-- including Oracle Data Integrator, Oracle GoldenGate and Oracle Enterprise Data Quality

Search

Archives
« July 2015
SunMonTueWedThuFriSat
   
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 
       
Today