Wednesday Oct 17, 2012

And the Winners of Fusion Middleware Innovation Awards in Data Integration are…

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.

Raymond James 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.

Friday Feb 17, 2012

Oracle Business Intelligence Applications for SAP with ODI is now available

Oracle recently announced the release of Oracle Business Intelligence Applications for SAP which extends the BI Applications for SAP with new modules such as Oracle Procurement & Spend Analytics for SAP and Oracle Supply Chain & Order Management Analytics for SAP.

This is an exciting news as this BI Applications release leverages Oracle Business Intelligence Enterprise Edition and Oracle Data Integrator with its specialized ABAP Knowledge Modules for SAP.

Here are some highlights from this new release:

  • Oracle Financial Analytics for SAP provides deep insights into SAP customers Financial Accounting (FI) related information, including: AP, AR and GL.
  • Oracle Procurement & Spend Analytics for SAP enables analysis into SAP customers Materials Management (MM) related information, including: Supplier Performance, Spend Optimization and Procurement Performance
  • Oracle Supply Chain & Order Management Analytics for SAP provides customers with enhanced visibility into SAP customers Sales & Distribution (SD) related information, including: Order Management, Order Fulfillment and Inventory

The following links will give you more information about the ODI Knowledge Modules for SAP:

Friday May 13, 2011

Data-Driven Decision Making Enables Increased Productivity

We all talk about how much more data there is out there now and how much more there will be in the coming years. There are many discussions how this trend creates a major challenge for the data management infrastructure and which technologies are a good fit to address them. How about discussing what type of opportunity this trend creates for organizations? Fortunately a new research study and its results were announced recently on this topic.

Erik Brynjolfsson, an economist at the Sloan School of Management at the Massachusetts Institute of Technology, Lorin Hitt— a professor at the Wharton School of the University of Pennsylvania— and Heekyung Kim, a graduate student at M.I.T., studied 179 large companies to research how data-driven decision making impacts organizations. “Data-driven decision making” was defined primarily by how they collect data across the enterprise, and how it is used in making business decisions. They assess organizations’ ability to make decisions based on data and analysis, and how this practice impacted their business.

The study concluded that organizations that employ data driven decision making achieve 5-6 percent increase in output and productivity. These results are impressive, however, to me, not surprising at all based on what we hear from Oracle Data Integration and Oracle Business Intelligence customers. For example, one telecommunication customer that uses Oracle GoldenGate for real-time data integration along with Oracle Business Intelligence EE in their call center reports that they decreased average response times, and now achieve faster call resolution. Other customers report that leveraging analysis with timely data helped them increase their up-sell and cross-sell rates when they run “smarter” campaigns to their customers. These are real-life examples how data can turn into asset and information overload can bring concrete opportunities to help achieve business goals.


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


« July 2016