Oracle Business Analytics Update

Last week I visited the Oracle Business Analytics Partner Update at Oracle NL in Utrecht, the Netherlands. The NL (Pre-) Sales gave us an update of the Oracle Analytics Roadmap. There is a lot of movement in the world of Oracle Analytics. I have written about the publications during Oracle Open World 2014. When we look back at 2014; “Year in Review – Oracle Business Analytics in 2014“, we can see that there are a few subjects key; Big Data, Cloud.

Oracle Business Analytics Strategy

The Oracle Business Analytics Strategy can be captured in one picture.

Oracle Business Analytics Strategy - 2014

The Oracle Business Analytics Strategy consists of Six Design Goals.

Oracle Business Analytics Strategy - Six Design Goals

1. Solutions – “To see more Patterns”

  • OBIEE
    • 12 C
    • R Integration
    • Interactive Dashboards
    • Voice & Word Recognition (BIAsk)
    • Data Mashups
  • Endeca Information Discovery

2. Mobile – “A Secure and Simple Experience”

Oracle has two options for a Mobile Experience.

  • Oracle BI Mobile HD
  • Oracle BI Mobile App Designer

3. More Answers – “In Context”

  • Oracle BI Applications (On Premise)
  • OTBI Saas (Embedded in Oracle Cloud Applications)
  • OTBI Enterprise (HCM, CRM, ERP, etc.)

4. Most Complet – “Cloud Capabilities”

Oracle has introduced new Cloud Services. The Oracle Analytics Cloud delivers Business Intelligence  & Analytics for Traditional Data and Big Data; Oracle Business Intelligence Cloud Service

There already is a lot of information to be found about the Oracle BICS offering;

If you like there is also a possibility to Try it Live.

5. Engineered – “Systems that Scale Operations”

Larry Ellison announced the Next Generation of Oracle Engineered Systems. See the Press Release here.

 

Check here for more video’s about Oracle’s X5 Engineered Systems Launch Event.

6. Faster – “Innovation Cycles”

Oracle introduces; Oracle Big Data Discovery – The Visual Face of Hadoop. With this new tool you should be able to spend more time on analyzing your data instead of prepping it. Check here what Oracle has to say about it.

Sounds like enough to try to keep up with!

Hadoop and Oracle Technologies on BI Projects

Last night I attended an event powered by oGH and OBUG. Mark Rittman was invited to talk about; ‘Hadoop and Oracle Technologies on BI Projects’. This event has been organized to inform us about Hadoop combined with Oracle Technologies. Next to that the event was also meant as a start up of a BI / Warehousing SIG.

Last May I visited the Rittman Mead BI Forum in Brighton. I attended a Cloudera Hadoop Masterclass. Mark extended this Masterclass where he integrated Hadoop into the (traditional) Oracle BI world. It was a very interesting session. Check a blogpost form Jan Karremans for a summary.

Although a lot of my current clients are still struggling with their (Operational) BI, it’s very interesting to see how Oracle responds to the Digitization & Datafication of the world.

Oracle Data Warehousing Platform - 2014

The Oracle BI Community is a very vivid and lively (Online) Community. There are a lot of offline (partly) Oracle BI related events around the globe. Sadly there is not much offline activity (yet) in the Benelux. It’s good to hear that the oGH and OBUG seem to join forces to setup a BI / Warehousing SIG. Mark proved with his session that there is a lot to talk about as we see that the worlds of traditional Data Warehousing and Hadoop & NoSQL (Data Reservoir) are colliding.

Check out Mark’s Slideshare for his presentation. For those interested in the BI / Warehousing SIG, please watch the OBUG-site. There is a new session planned for 3 march 2015.

Where is the online Oracle BI SampleApp V406?

For those of you who are familiar with the Oracle BI SampleApp V406, it might not be a secret. The online version has been offline since a couple of weeks / months. This due to the fact that the online SampleApp has to comply with Oracle Security Rules.

I found out that one of the Oracle Urls came back up a few weeks ago.

This has been for a very short period. I checked with Philippe Lions this week. It seemed that for Oracle OpenWorld 2014 the SampleApp was allowed to be back online for a short period. It’s back offline now. They are still working on a solution. Of course I didn’t get an official timeline. Somewhere in the (near) future. That can be weeks, that can be months. We all just have to be patient.

You can still download the VM if you want. Thanks to Robin for pointing out how to run the SampleApp in the Cloud. That way you can launch your own online SampleApp. Check Youtube if you want to have a quick visual.

Oracle OpenWorld 2014 is over – What’s next?

Last week Oracle OpenWorld 2014 took place in San Francisco. I did not have the pleasure to attend this event. thanks to the Social Media and the World Wide Web you could be able to follow the highlights. If we check out the Keynote of Thomas Kurian, we can learn that there are three Major Trends;

  • Big Data
  • Mobility
  • Cloud

I have looked at these Trends earlier.

Big Data

Just before Oracle OpenWorld 2014, the new updated Oracle Big Data Information Management Reference Architecture has been released. This updated Reference Architecture should place all the (new) technologies in context and next to that it should provide insight into a real, implementable Architecture.

Oracle offers new Big Data capabilities via;

Mobility

One of the introductions during Oracle Open World is the; Oracle Mobile Cloud, an end-to-end Mobile Development Framework;

On top of that Oracle has enhanced the integration between Oracle Mobile Application Framework and Oracle Mobile Security Suite. Oracle says the deeper integration makes it easier for mobile front-end developers to secure their applications.

For more details, please check;

Cloud

Oracle will introduce new Cloud Services. Check the Official Press Release for more details. The Oracle Analytics Cloud delivers Business Intelligence  & Analytics for Traditional Data and Big Data. 

There already is a lot of information to be found about the Oracle BICS offering;

Apart from the above there are a few more ‘Introductions’ & News facts:

  • OBI 12c
  • Oracle BI Applications
    • There will be no more upgrades on Oracle BIA 7.9.x (Informatica release). A few months ago there was a rumor that there would come an Oracle BIA 11g (Informatica release). This is not going to happen. Existing customers have to move over to the Oracle BIA 11g (ODI release)
  • Introducing Oracle Alta UI (Renewed Cross-platform User Experience)
  • Oracle Data Integrator will play a Key Role in binding the Applications, moving Data and simplifying access to Big Data (check these recaps – day 1, 2, 3 & day 4 – from the Oracle Data Integration team).

Trying to understand the Oracle Reference Architecture for Information Management

Last month I have been attending the RittmanMead BI Forum 2014. In the wrap-up I mentioned a presentation by Andrew Bond & Stewart Bryson. They had a very nice presentation about the Oracle Information Management Reference Architecture. This needed some further investigation from my part.

This blogpost is a first summary of the information I found online so far.

There is a complete reference library of IT Strategies from Oracle. Pay extra attention to the following docs:

  • Oracle Reference Architecture Information Management
  • Oracle Reference Architecture Business Analytics Foundation
  • Oracle Reference Architecture Business Analytics Infrastructure
  • Oracle Reference Architecture Service Orientation
  • Oracle Reference Architecture Security
  • Oracle Reference Architecture Engineered Systems

IT Strategies from Oracle

Next to that, Oracle has a few White Papers focussing on Information Management (Big Data & Analytics):

Oracle Information Management – Logical View

Let’s take a closer look, see the picture below. This picture has been copied from; the Oracle Information Management Reference Architecture. presentation I mentioned above. There are a few major components in the Reference Architecture

  • Data Sources
  • Information Provisioning
    • Data Ingestion
    • Logical Data Warehouse
  • Information Delivery

While putting together this blog post, Mark Rittman posted the following article(s); “Introducing the Updated Oracle / Rittman Mead Information Management Reference Architecture – Pt1. Information Architecture and the “Data Factory” & Pt2. – Delivering the Data Factory” on the RM Blog.

Oracle Information Management – Logical View

Data Sources

Within this Reference Architecture Oracle should be able to handle all sorts of data:

  • Traditional Enterprise Data (ERP, CRM, etc.)
  • Machine-generated /Sensor Data (Smart Meters, Equipment Logs, etc.)
  • Social Data (Twitter, Facebook, etc.)

Any Data - Any Source - Any Format - Different Data

The last couple of years / decades, Data has changed. We (as BI/DW-Consultants) have always looked at data in a Traditional (Structured) way. Now Oracle provides an Architecture to combine the old Data with the new (Big) Data. Whether there are 3, 4, 5, or whatever number of V’s, the most important thing is that you get value from your Data!

Data Ingestion (Loading)

Oracle provides / supports tools to perform Batch or (Near) Real-Time Data Ingestion.

Oracle GoldenGate & Oracle Data Integrator

Michael Rainey is writing an excellent series on how to load the Raw Data Reservoir (Staging Layer) and the Foundation Layer; Oracle GoldenGate and Oracle Data Integrator – A Perfect Match in 12c.

Cloudera Distribution including Apache Hadoop (CDH)

Hadoop is Open Source and Apache licensed. Cloudera provides an Open Source Distribution ( Cloudera CDH – Cloudera Enterprise Data Hub).

Oracle Event Processing (OEP)

OEP is a complete solution for building applications to filter, correlate and process events in real-time. Check the Data Sheet here.

Logical Data Warehouse

There are a few different Layers:

  • Raw Data Reservoir (Staging Layer)
  • Foundation Layer
  • Access and Perfomance Layer

Depending on the requirements and the tooling one can decide to skip or combine the different Layers. Oracle has the tooling to load the various Layers directly (GoldenGate).

The data is no longer only stored in the Oracle Database. The ‘new’ types of data require ‘new’ types of storage. There are different Data Stores for different purposes.

The Oracle Big Data Connectors can be used to integrate Apache Hadoop with Oracle Database Software.

Processing the data could be either In-Database (Oracle Database Options –  Advanced Analytics, OLAP) or In-Memory (Oracle TimesTen).

Information Delivery

Oracle is able to support proven answers to known questions via Oracle BI. Fast answers to new questions are provided by Oracle Endeca Information Discovery.

“The Oracle BI Foundation Suite provides comprehensive capabilities for business intelligence, including enterprise reporting, dashboards, ad-hoc analysis, multi-dimensional OLAP, scorecards, and predictive analytics on an integrated platform”

Oracle BI Foundation - Front-End

OBIEE makes it possible (Logical Layer) to skip the ‘Access and Perfomance Layer’ and source directly form the ‘Foundation Layer’. There are some very interesting presentations online around this subject.

“Oracle Endeca Information Discovery is a complete enterprise data discovery platform that combines information of any type, from any source, empowering business user independence in balance with IT governance. Now organizations can access the information they need, when they need it, to make business decisions they can trust.”

There is still a lot more to investigate, but for me this gives a little bit more guidance.