At OpenWorld, we announced the winners of
Fusion Middleware Innovation Awards 2012. Raymond James and Morrison Supermarkets were
selected for the data integration category for their innovative use of Oracle’s
data integration products and the great results they have achieved.
In this blog I would
like to briefly introduce you to these award winning projects.
is a diversified financial services company, which provides
financial planning, wealth management, investment banking, and asset
management. They are using Oracle
GoldenGate and Oracle Data Integrator to feed their operational data store (ODS),
which supports application services across the enterprise. A major requirement for their project was low data latency, as key decisions are
made based on the data in the ODS. They were able to fulfill this requirement
due to the Oracle Data Integrator’s integrated solution with Oracle GoldenGate.
Oracle GoldenGate captures changed data from
different systems including Oracle Database, HP NonStop and Microsoft SQL Server
into a single data store on SQL Server 2008. Oracle Data Integrator provides data transformations for the ODS. Leveraging ODI’s integration with GoldenGate,
Raymond James now sees a 9 second median latency (from source commit
to ODS target commit).
The ODS solution delivers high quality,
accurate data for consuming applications such as Raymond James’ next generation
client and portfolio management systems as well as real-time operational reporting. It enables
timely information for making better decisions.
There are more benefits Raymond James
achieved with this implementation of Oracle’s data integration solution. The software developers and architects of
this solution, Tim Garrod and Ryan Fonnett, have told us during their
presentation at OpenWorld that they also reduced application complexity
significantly while improving developer productivity through trusted
operational services. They were able to utilize CDC to generate
alerts for business users, and for applications (for example for cache
hydration mechanisms). One
cool innovation example among many in this project is that using ODI's flexible architecture, Tim and Ryan could build
24/7 self-healing processes. And these processes have hardly failed. Integration process fixes the errors
itself. Pretty amazing; and a great solution for environments that need such reliability and availability. (You can see Tim and
Ryan’s photo with the Innovation Awards trophy above.)
The other winner of this year in the data
integration category, Morrison
Supermarkets, is the UK’s 4th largest grocery retailer. The company has been migrating all their
legacy applications on to a new-world application set based on Oracle and
consolidating all BI on to a single
Oracle platform. The company recently implemented Oracle Exadata as the data
warehouse engine and uses Oracle Business Intelligence EE.
Their goal with deploying GoldenGate and ODI was to provide BI data to the enterprise in a
way that it also supports operational decision making requirements from a wide
range of Oracle based ERP applications such as E-Business Suite, PeopleSoft,
Oracle Retail Suite. They
use GoldenGate’s log-based change data capture capabilities and Oracle Data
Integrator to populate the Oracle Retail Data Model. The electronic point of sale (EPOS)
integration solution they built processes over 80 million transactions/day at
busy periods in near real time (15 mins). It provides
valuable insight to Retail and Commercial teams for both intra-day and
historical trend analysis.
As I mentioned in yesterday’s blog, the right data integration platform
can transform the business. Here is another example: The point-of-sale
integration enabled the grocery chain to optimize its stock management, leading
to another award: Morrisons won the Grocer
33 award in 2012 - beating all other major UK supermarkets in product
availability. Congratulations, Morrisons,on another award!
Celebrating the innovation and the success of our customers with Oracle’s
data integration products was definitely a highlight of Oracle OpenWorld for
me. I look forward to hearing more from Raymond James, Morrisons, and the other
customers that presented their data integration projects at OpenWorld, on how
they are creating more value for their organizations.