Tuesday Jun 21, 2016

Oracle Data Integrator (ODI) 12.2.1.1.0 Now Available

Oracle Data Integrator 12.2.1.1.0 is now available! Please visit the ODI OTN page for downloads, documentation, related collateral and other useful links.

Take a look here for the latest details of this release – and read on for some highlights:

Hyperion Essbase and Hyperion Planning Knowledge Modules

Hyperion Essbase and Hyperion Planning Knowledge Modules have been made available out of the box with Oracle Data integrator and support the latest version (11.1.2.4) of these Hyperion Applications.

Integrated Capture/Delivery support in GoldenGate Knowledge Modules

The GoldenGate Journalization Knowledge Modules (JKMs) for Oracle databases have been updated and now support Integrated Capture and Delivery. This updated functionality can improve performance and provides better scalability and load balancing.

Support for Cubes and Dimensions
Core ETL – ELT enhancements have been made; where ODI now provides support for two types of dimensional objects: Cubes and Dimensions. Users can create and use Cubes and Dimensions objects directly in Mappings to improve developer productivity with out of the box patterns that automate the loading of dimensional objects. This also allows for improved Type 2 Slowly Changing Dimensions and brand new Type 3 Slowly Changing Dimensions support with ODI.


Big Data Configuration Wizard
A brand new Big Data Configuration wizard is now available in the ODI Studio Gallery and provides a single entry point to configure the Topology objects for Hadoop technologies such as Hadoop, Hive, Spark, Pig, Oozie, etc.

Let us know how you are using ODI – and try out this new version to keep up with what’s current!

Thursday May 12, 2016

Looking for Cutting-Edge Data Integration & Governance Solutions: Nominate NOW for the 2016 Excellence Awards

It is nomination time!!!

This year's Oracle Cloud Platform Innovation – Excellence Awards will honor customers and partners who are creatively using Oracle products. Think you have something unique and innovative with Oracle Data Integration & Governance products?

We'd love to hear from you! Please submit today in the Data Integration & Governance category. This year’s nomination process is a little bit different in the sense that the forms are fully online.

The deadline for the nomination is Monday, June 20, 2016. Win a free pass to Oracle OpenWorld 2016!

Let’s reminisce a little…

For details on the 2015 Big Data, Business Analytics, and Data Integration Winners: amazon.com, Caixa Bank, Serta Simmons Bedding, Skanska, Scottish & Southern Energy and Tampa International Airport, check out this blog post.

For details on the 2014 Data Integration Winners: NET Serviços and Griffith University, check out this blog post.

For details on the 2013 Data Integration Winners: Royal Bank of Scotland’s Market and International Banking and The Yalumba Wine Company, check out this blog post.

For details on the 2012 Data Integration Winners: Raymond James Financial and Morrisons Supermarkets, check out this blog post.

We hope to honor you!

Click here to submit your nomination today – scroll to the bottom of the page and select the appropriate category. And just a reminder: the deadline to submit a nomination is 5pm Pacific Time on June 20th, 2016.


Monday Mar 28, 2016

Leveraging Oracle Data Integrator (ODI) with the Amazon Elastic MapReduce (EMR) Cloud Service

Another interesting article from our A-Team – read on!

Benjamin Perez-Goytia recently published Using Oracle Data Integrator (ODI) with Amazon Elastic MapReduce (EMR). He provides details on how to use Oracle Data Integrator (ODI) with the Amazon Elastic MapReduce (EMR) cloud service.  Amazon EMR is a big data cloud service and a member of the Amazon Web Services (AWS) cloud computing services, offered by Amazon.com.

Thanks Benjamin!

Tuesday Feb 02, 2016

A-Team Article: Integrating Oracle Data Integrator (ODI) On-Premise with Cloud Services

Benjamin Perez-Goytia of the Data Integration Solutions A-Team provides a very matter of fact summary regarding Cloud Integration with Oracle Data Integrator (ODI). For all the details: Integrating Oracle Data Integrator (ODI) On-Premise with Cloud Services.

The blog post details how to integrate Oracle Data Integrator (ODI) on-premise with cloud services.  Cloud computing is a service or utility in high demand and enterprises find themselves with a mix of on-premise data sources and cloud services.  Ben describes how Oracle Data Integrator (ODI) on-premise can enable the integration of both on-promise data sources and cloud services.

Happy reading! For more A-Team reads on ODI, browse through the A-Team Chronicles.

Tuesday Jan 26, 2016

ODI 12c KMs are now available for Oracle Hyperion Planning and Essbase

Oracle Essbase and Oracle Hyperion Planning Knowledge Modules (KMs) are now available for Oracle Data Integrator 12.2.1. The patches containing the KMs are available for download on My Oracle Support. Patch# 20109114 contains Oracle Essbase KMs and Patch# 21903914 has Oracle Hyperion Planning KMs. The KMs support latest version (11.1.2.4) of these Hyperion Applications.  All the features available in their corresponding 11g KMs are available in these 12c KMs as well.

Friday Nov 13, 2015

2015 Oracle Excellence Awards… and the Winners for the Big Data, Business Analytics and Data Integration Category are…

Every year at OpenWorld, Oracle announces the winners to its most prestigious awards, the Oracle Excellence Awards. This year, as we have in previous years, we celebrated in style! In an Oscars-like ceremony on Tuesday, October 27th, customers were highlighted for their innovative solutions. Congratulations to all winners!

Let me introduce this year’s 2015 Big Data, Business Analytics and Data Integration category winners:

Amazon.com, an American electronic commerce and cloud computing company, is the largest Internet-based retailer in the United States.

During its growth over the years, Amazon never invested in back office systems and processes believing that they could scale without impact to their business. After almost 15 years of exponential growth into a multi-national and diverse business, Amazon recognized that they needed to address improve their ability to manage financial reporting.

Together with The Hackett Group, they built an EPM and BI solution to ensure they could deliver automated financial reporting and analytics to over 1,000 stakeholders across the company. Using Oracle Data Integrator Enterprise Edition, Application Adaptors for Data Integration, Oracle BI Enterprise Edition, Oracle Essbase, and various Hyperion products – the solution yields huge benefits:

· 100% Positive Feedback from user community, leadership claiming First Successful Financial Systems Implementation

50% + Reduction in Time to Complete Close Process from 10+ days to 5 days

1,000s of Hours Saved per Month across 1,000 users in data analysis & mining

The automation of reporting that the reports and analytic capabilities are correct has truly provided the confidence Amazon.com desired in moving forward and providing modernization and agility in future business decisions.


CaixaBank is a leading Spanish retail bank and insurer. Centering on delivering customer service through innovation and technology, CaixaBank is regarded as a leading financial institution in global innovation and has pioneered the development of new means of payment.

They set out to become a data-driven company using Big Data architecture using Business Analytics tools by: Democratizing use of data for Reporting, Dashboarding and Analysis, Empowering end-user by allowing combine data for discovering Business patterns and niches and Blending Structured and Non-Structured information. Built on top of Exadata and Exalytics, and leveraging Oracle Business Intelligence, Oracle Big Data Analytics, and Oracle Data Integration tools, CaixaBank’s solution:

Enabled 360°Understanding of Customers to offer tailored, on-demand banking and insurance solutions

50,000+ hours saved/year on Big Data Project Development versus previous methods

75 Big Data projects - 16% drives increased economic margin, 14% addresses cost reduction, 27% improves process and saves time – generating 5 Million+ Euros

Their initial success is driving CaixaBank to transition towards a real time driven organization, enabling the monetization of their data relative to business targets.


Serta is the #1 mattress manufacturer in the United States and one of the most recognized home furnishing brands in the marketplace. In an effort to modernize the antiquated and inefficient ERP system to service financial reporting, and provide IPO readiness, they quickly implemented a scalable solution across the enterprise leveraging Oracle BI Foundation Suite, Oracle Endeca Information Discovery, various Hyperion products, Essbase Analytics Link for Hyperion Financial Management, Oracle Data Relationship Management, and Oracle Data Relationship Governance.

Together with Grant Thornton, the solution took 7 months, and yields:

Scalable, integrated platform delivered improved system stability thanks to consolidated, standardized, data acquisition and better quality data

Which in turn, improved the reliability and confidence in self service analytics

90% faster to produce Standardized Reporting - 9 business days saved per month

275% improvement in availability of data, allowing users to access and provide timely analysis of the data

This solution has provided Serta Simmons some truly amazing results, where the overhead cost reduction is in the millions due to higher quality speedier information, providing a strong foundation for future expansion of this solution.


Skanska AB, founded in 1887, is one of the world’s leading project development and construction groups, with expertise in commercial and residential projects and public-private partnerships. Skanska creates sustainable solutions and aims to be a leader in quality, green construction, work safety, and business ethics

Skanska needed to optimize its monthly management reporting – including shipping data to a 3rd party for augmenting. They wanted to simplify development and testing of new information solutions and reports, and ensure that users could quickly and easily adapt the collection and analysis of information to meet new requirements.

In a centralized, single cloud environment for management reporting worldwide, Skanska is using Oracle BI Cloud Service. The solution benefits include:

Full data load to “ready to analyze” in < 5 minutes

17 days to implement

Oracle BI Cloud Service is proving reliable, being constantly accessible to 60K users via mobile devices in this global organization.


Scottish and Southern Energy, SSE is involved in producing, distributing and supplying electricity and gas and other energy related services. Within the UK, the focus on energy companies and power generation industry is in the spotlight, with growing regulation and joint assessment of competition in the energy market. To ensure that Scottish & Southern Energy (SSE) and subsequently, the SSE Generation directorate, can continue to operate in this ever changing environment, whilst developing and retaining a competitive edge over its market rivals, data on its entire business, and the way it manages and uses that data will need to be a key focus.

SSE was looking for an agile and rapid delivery of mobile accessible BI dashboards which otherwise would have taken their internal IT teams a considerable amount of on premise infrastructure design and provisioning. The Oracle BI Cloud enabled functionality to be surfaced in an extremely short amount of time using real Generation business data to present to senior executives.

SEE found:

Cloud Infrastructure is more Cost and Time effective; 6 weeks of work compared to 6 months

Increased confidence within internal SSE business community for delivering right solution

Management Dashboard key enabler for more effective and quicker decisions by leadership team

The advantages that are available to SSE in utilizing ‘Cloud’ based solutions in regards to speed, flexibility and agility in conjunction with the on premises solutions. SSE finds it is able to integrate data from multiple sources into “Single Source of Truth” and in turn make long term informed decisions vital for the future sustainability of SSE.


Tampa International Airport is one of the region's most significant economic engines, with a total economic output of more than $7 billion. The airport and its tenants employ more than 7,500 people on the airport campus and support more than 81,000 jobs in the community.

Tampa International Airport set out to modernize their infrastructure and data acquisition strategy knowing better data integration and business analytics would strengthen their business and customer loyalty. Sitting on top of Exadata, Exalogic, and Exalytics, Tampa International Airport combined Oracle Data Integrator and Oracle GoldenGate with Oracle BI Foundation Suite for better analytics around passengers, parking, concessions, baggage claim, etc. In 6 months, the completed project yields major benefits:

With better analysis helping them add new routes, they have seen a 6.7% Yearly Passenger Increase, the largest in year-over-year growth in a decade, with international traffic increasing by more than 14%

4.6% increase in revenues driven by greater analysis of the Authority’s parking, concessions and rental car businesses resulting in greater spend per passenger

150% reduction in Time to Complete Planning & Forecasting Process via more efficient resource and people management

The success has provided Tampa International Airport sets a shift in paradigm – for a more proactive, strategic and operational excellence – all in an effort to better serve their customers.

CONGRATULATIONS to our Big Data, Business Analytics and Data Integration category winners!

Monday Oct 12, 2015

Featuring Big Data Sessions at Oracle OpenWorld 2015

Oracle OpenWorld is only a few days away now and Big Data will be front and center again this year! Many of our Oracle Data Integration sessions will speak to your Big Data needs, we hope you will come and meet us to hear how Oracle Data Integration helps everyone by simplifying access to Big Data and introducing real time capabilities to Big Data.

I would recommend attending the following 2 key sessions on Oracle Data Integration with Big Data:

  • Enabling Real-Time Data Integration with Big Data [CON9724]
    In this session Chai Pydimukkala from the Oracle Data Integration Product Management team will discuss GoldenGate's offering for big data environments. With Chai, Janardh Bantupalli from LinkedIn, will present their solution that uses Oracle GoldenGate for Big Data to optimize the data warehousing environment and achieve operational insights with lower costs.
  • Oracle Data Integration Product Family: a Cornerstone for Big Data [CON9609]
    In this session Alex Kotopoulis from the Oracle Data Integration Product Management team and Mark Rittman Chief Technical Officer at Rittman Mead will describe how our Data Integration platform uses a metadata-based approach to hide the complexity of the various big data technologies such as Hive, Pig, and Spark, and delivers a simplified and future-proofed investment in big data technologies.

There are many more Big Data related sessions I’d also recommend to attend:

In addition we will be running several Hands on Labs covering Oracle Big Data Preparation Cloud Service, Oracle Data Integrator and Oracle GoldenGate. Space is limited and they usually fill up quickly so make sure to register!

Please also come to visit us at our various demo pods in Moscone South:

  • Oracle Big Data Preparation Cloud Service: Get Your Big Data Ready to Use
    Workstation ID: SBD-022 / Venue: Moscone South, Upper Right, Big Data Showcase
  • Oracle Big Data Preparation Cloud Service
    Workstation ID: SPI-023 / Venue: Moscone South, Oracle Cloud Platform and Infrastructure Showcase
  • Oracle Data Integrator Enterprise Edition and Big Data Option: High-Performance Data Integration
    Workstation ID: SLM-022 / Venue: Moscone South, Lower Left, Middleware
  • Oracle GoldenGate: Real-Time Data Integration for Heterogeneous and Big Data Environments
    Workstation ID: SLM-035 / Venue: Moscone South, Lower Left, Middleware
  • Tame Big Data with Oracle Data Integration
    Workstation ID: SBD-023 / Venue: Moscone South, Upper Right, Big Data Showcase

We hope you will join a few! Don’t forget to view the Focus on Data Integration – for a full review of Data Integration Sessions during OpenWorld. See you there!

Thursday Oct 08, 2015

Featuring Big Data Preparation Cloud Service and other Cloud Data Integration Sessions at Oracle OpenWorld 2015

Oracle OpenWorld is almost upon us! We are excited to be sharing with you some previews of what will be seen and discussed in just a few weeks in San Francisco!

One of the highlights is Oracle’s new Cloud Based Data Preparation Solution, Oracle Big Data Preparation Cloud Service, also known as BDP.  This new service will revolutionize the process of importing, preparing and publishing your complex business data and getting it ready for use allowing you to spend more time analyzing data rather than preparing data for analysis. Users are guided through the process with intuitive recommendation driven interfaces. The system also provides various ways to automate and operationalize the entire data preparation pipeline via the built in scheduler or via a rich set of RESTful API’s.

During OpenWorld, Oracle’s Luis Rivas, alongside Blue Cloud Innovations’ Vinay Kumar and Pythian’s Alex Gorbachev will discuss and demonstrate how big data promises many game-changing capabilities if tackled efficiently! You will discover how Oracle Big Data Preparation Cloud Service takes “noisy” data from a broad variety of sources in many different formats, both structured and unstructured, and uses sophisticated and unique blend of machine learning and Natural Language Processing based on a vast set of linked open reference data that provide a powerful way to ingest, prepare, enrich, and publish it into useful data streams, ready for further discovery, analysis, and reporting. Don’t miss it:

CON9615 Solving the “Dirty Secret” of Big Data with Oracle Big Data Preparation Cloud Service

Tuesday, Oct 27, 5:15 p.m. | Moscone South—310

Curious to find out more about BDP before the conference? Take a look here and view a short video: Chalk Talk: Oracle Big Data Preparation Cloud Service!

Since we are on the topic of Data Integration and the Cloud – I will also take a quick moment to remind everyone about Oracle Data Integrator’s (ODI) integration relative to the Oracle Storage Cloud Service as well for example. But that’s not all – here is a view into the Data Integration sessions that relate to the Cloud – in chronological order:

CON3506 Into the Cloud and Back with Oracle Data Integrator 12c

Monday, Oct 26, 5:15 p.m. | Moscone West—2022

*****

CON9614 Oracle Data Integration Solutions: the Foundation for Cloud Integration

Wednesday, Oct 28, 11:00 a.m. | Moscone South—274

*****

CON9717 Accelerate Cloud Onboarding Using Oracle GoldenGate Cloud Service

Wednesday, Oct 28, 3:00 p.m. | Moscone West—2022

*****

CON9595 Cloud Data Quality: Lessons Learned from Oracle’s Journey to the Sales Cloud

Thursday, Oct 29, 12:00 p.m. | Moscone West—2022

*****

CON9612 Oracle Enterprise Metadata Management and the Cloud

Thursday, Oct 29, 1:15 p.m. | Marriott Marquis—Salon 4/5/6


We hope you will join a few! Don’t forget to view the Focus on Data Integration – for a full review of Data Integration Sessions during OpenWorld. See you there!

Tuesday Oct 06, 2015

Catch Up on Oracle GoldenGate at Oracle OpenWorld

This year Oracle OpenWorld brings many opportunities for Oracle GoldenGate users to learn the latest features and best practices. If you will be at OpenWorld later this month, I recommend you check out the following key Oracle GoldenGate sessions:

On Monday October 26th, Chai Pydimukkala from the GoldenGate product management team will present Oracle GoldenGate Product Update and Strategy (CON9720) session and share the new features of Oracle GoldenGate and its strategic direction. Along with Chai, Eric Schneider and Andrew Yee from our customer TicketMaster will present their GoldenGate deployment and best practices

On Tuesday Oct 27th, in the Enabling Real-Time Data Integration with Big Data (CON9724) Chai will discuss GoldenGate's offering for big data environments. With Chai,  Janardh Bantupalli from LinkedIn, will present their solution that uses Oracle GoldenGate for Big Data to optimize the data warehousing environment and achieve operational insights with lower costs.

On Wednesday October 28th you can get a preview to the anticipated Oracle GoldenGate Cloud Service by attending Accelerate Cloud On-Boarding using GoldenGate Cloud Service (CON9717). You will also learn about using GoldenGate in public, private, and hybrid cloud deployment and hear from Michael Pape, CTO Database Operations for Intuit, talk about their GoldenGate best practices.  

Other key GoldenGate sessions to attend:

You can find the full list of Oracle GoldenGate and Oracle Data Integration sessions in our Focus On Document, and use the Schedule Builder to build your personal schedule for OpenWorld. While at OpenWorld, follow us via @OracleDI and @ORACLEBigData and using the hashtags #ODI12c,#OGG12c, #OEMM, #OEDQ and #OBDPCS to join the conversation.

Wednesday Aug 05, 2015

Chalk Talk Video: Oracle Big Data Preparation Cloud Service

We continue our Oracle Data Integration chalk talk video series, with an overview of Oracle Big Data Preparation Cloud Service (BDP). BDP allows users to unlock the potential of their data with a non-technical, web-based tool that minimizes data preparation time. BDP provides an interactive set of services that automate, streamline, and guide the process of data ingestion, preparation, enrichment, and governance without costly manual intervention.

View this video to learn more: Chalk Talk: Oracle Big Data Preparation Cloud Service

For additional information – visit the Oracle Big Data Preparation Cloud Service page.


Tuesday Jul 07, 2015

Chalk Talk Video: Kick-Start Big Data Integration with Oracle

Next in the series for Oracle Data Integration chalk talk videos, we speak to Oracle Data Integrator (ODI) for big data. ODI allows you to become a big data developer without learning to code Java and Map Reduce! ODI generates the code and optimizes it with support for Hive, Spark, Oozie, and Pig.

View this video to learn more: Chalk Talk: Kick-Start Big Data Integration with Oracle.

For additional information on Oracle Data Integrator, visit the ODI homepage and the ODI for Big Data page. This blog can be very handy also: Announcing Oracle Data Integrator for Big Data.

Thursday Jul 02, 2015

Chalk Talk Video: How to Raise Trust and Transparency in Big Data with Oracle Metadata Management

Some fun new videos are available; we call the series ‘Chalk Talk’!

The first in the series that we will share with you around Oracle Data Integration speaks to raising trust and transparency within big data. It is known that crucial big data projects often fail due to a lack in the overall trust of the data. Data is not always transparent, and governing it can become a costly overhead. Oracle Metadata Management assists in the governance and trust across all data with the enterprise, Oracle and 3rd party.

View this video to learn more: Chalk Talk: How to Raise Trust and Transparency in Big Data.

For additional information on Oracle Metadata Management, visit the OEMM homepage.

Wednesday Jul 01, 2015

ODI - Integration with Oracle Storage Cloud Service

Oracle Data Integrator’s open tool framework can be leveraged to quickly get access to the Oracle Storage Cloud Service, which is gradually becoming an essential part for integrating on premise data to many cloud services. The reference implementation of an open tool for Oracle Storage Cloud is now available on the Data Integration project on Java.net: ODI OpenTool for Oracle Storage Cloud which can be used and modified as per your integration needs. [Read More]