Monday Apr 29, 2013

Monitoring Oracle GoldenGate 11g Release 2

One of the key improvements in Oracle GoldenGate 11g Release 2 is in the monitoring area. This release brought  integration with Oracle Enterprise Manager 12c, as well as a new product dedicated for monitoring Oracle GoldenGate, called Oracle GoldenGate Monitor.  This new product is included in the Management Pack for Oracle GoldenGate and offers GUI-based solution for end-to-end, real-time visibility into Oracle GoldenGate implementations across the enterprise. GoldenGate Monitor increases IT productivity by offering consolidated information for multiple instances of Oracle GoldenGate and via its comprehensive e-mail, SNMP and CLI alert capabilities, among many other features.

We have a new screencast that presents Oracle GoldenGate  Monitor's features and architecture, along with a product demonstration. If you have a GoldenGate solution or plan to deploy one, I highly recommend watching this screencast here or via the embedded video below to learn about monitoring GoldenGate processes via this simple but powerful GUI-based product.

For more information on Oracle GoldenGate 11g Release 2, please check out our free resources.

Monday Apr 22, 2013

Enterprise Data Quality: A Key Requirement for Data Integration and Beyond...

If you've been following the recent Oracle Data Integration blogs, then you're no stranger to our latest paper on the five key data integration requirements. Yet, what we haven't mentioned yet is the importance of data quality.  Enterprise data is changing constantly, take a look at the graphic below and you will see what I  mean.  Data degrades at a rapid fire pace and an enterprise-level data quality solution is key to maintaining the trustworthiness as well as reliability in order to make sound business decisions from it. 

As a key component of Oracle Data Integration product family, Oracle Enterprise Data Quality complements Oracle's integration technologies by providing the key steps around cleansing, standardizing, governing and matching information.  In addition, Enterprise Data Quality works with Oracle Master Data Management to help ensure that information inserted into multi-domain hubs is relevant, analyzed and accurate.  One of the key features of Enterprise Data Quality is its on-going governance capabilties, bolstered by case management and dashboards for auditing, profiling, and parsing information - across customer and product data.  The benefits of these features are that users have access to analyze data quality trends over time, continuous monitoring (user established) and rapid discovery of data faults.  Oracle Enterprise Data Quality provides a manageable footprint in the enterprise for both MDM and data integration initiatives.. It acts as as the perfect starting point for understanding the current state of data.  For more information on Oracle Enterprise Data Quality click here

Tuesday Apr 16, 2013

ODI - Integrating social data from Facebook Graph API in 0 to 60

I'm always on the lookout for enabling technology to push the envelope. Here is a viewlet illustrating how to integrate Facebook  data into your flow. It uses a preprocessor that will help you integrate JSON in general into your data integration world.

There are a few pieces to the jigsaw. ODI provides an XML driver that can be used to process XML data from the filesystem, http or ftp for example. ODI has improved this greatly by leveraging Oracle standard XML schema and parsing components. Transforming JSON to XML is one approach which is convenient for when you already have XML based tools or utilities. With this utility you can load JSON data into your data integration flows and in the process understand more about the data (when we reverse engineer the JSON we get a schema). Using this we can integrate arbitrary JSON data such as social data feeds from Twitter, Facebook, Google, and aggregators like Datasift among many others.

Watch the viewlet to see it in action.

Active-Active Database Replication with Conflict Detection and Resolution

[Read More]

Thursday Apr 11, 2013

Why Real Time?

Continuing on the five key data integration requirements topic, this time we focus on real-time data for decision making. 

[Read More]

Tuesday Apr 02, 2013

Starwood Hotels Presents in Customer Success Forum on April 11th

Register before April 5th for the online Customer Success Forum with Starwood Hotels and Resorts (April 11th 11am ET), and ask questions about how they used Oracle Exadata, Oracle GoldenGate, and Oracle Data Integrator for data warehousing and operational reporting.[Read More]

Monday Apr 01, 2013

ODI - Tip of the day, Connect/Disconnect call outs

The connect/disconnect call outs are a useful mechanism for executing code at the start and end of connections - you can write SQL, PLSQL and all sorts through this callout. The code is useful for example for recording your own additional audit information. The code is executed using the execute function call via the java driver for your system. This lets you execute arbitrary valid calls for your driver. For Oracle this can include anonymous PLSQL blocks of code which can contain many statements including SQL and PLSQL. You can also use odiRef APIs so you can generate the code to be executed in the context of where it is executed.

To illustrate if I want to record the session ID in my own audit/trace table I can define an on-connect block of code to be executed. You also define which ODI transactions the code is pertinent to. So for example below I have defined an anonymous PLSQL block of code for on connect applicable to transaction 1 - this is the transaction referenced from the KMs I am using, on the right you can see the IKM SQL Control Append is 'Transaction 1'.

Notice how I can use the odiRef calls to get the session id and add it into my block of code. I have also used the commit option to save the details. When an interface or scenario is executed that uses this data server the code will be executed and can be inspected from the ODI operator under the Command On Connect node in the tree;

Again, the code is executed through the java jdbc driver so it must be of the technology that the data server is, but this is a useful exit/call out point for invoking code. You can even use variables within this block to add another level of flexibility.

Oracle Releases Oracle Data Integrator

Oracle has announced the release of Oracle Data Integrator  This release introduces several exciting new features such as:

  • IBM WebSphere support for the ODI JEE components including Agents
  • The OdiEnterpriseData Quality tool which integrates Oracle Data Integrator and Oracle Enterprise Data Quality is now provided as an ODI tool
  • XML enhancements such as the inclusion of the Oracle XML Developer’s Kit (XDK) parser

For more information about each new feature, downloads and documentation for Oracle Data Integrator, please visit the Oracle Data Integrator page on OTN.


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


« April 2013 »