Handouts – Introducing Oracle’s Information Management Reference Architecture

One of the great things of working in the Oracle Business Analytics industry is the fact that there is a very active community. Both online as well as offline. Oracle supports these activities where possible. Last week I attended an offline session at Oracle HQ in the Netherlands. This session was a event organized by the oGH and the OBUG (the SIG BIWA). Marti Koppelmans provided an Introduction into Oracle’s Information Management Reference Architecture. As promised he has posted some of his material on the oGH side. If you are interested, have a look at the following;

Although the titles are in Dutch, the contents are in English.

I will try to leave my notes here whit in a few days

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!

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).

Oracle Big Data Information Management Reference Architecture

A few months ago I wrote a blogpost about the Oracle Reference Architecture for Information Management. There is a new Oracle Big Data Information Management Reference Architecture online now.

If you want to find out more about Oracle’s Big Data Information Management Reference Architecture please check the below links:

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.

Big Data and Analytics Top Ten Trends for 2014

Oracle recently published their view on the; Top Ten Trends “Big Data” & “Analytics” for 2014. Find the list below:

1. Business Users Get Hooked on Mobile Analytics –> Oracle Business Intelligence Mobile App Designer

2. Analytics Take to the Cloud –> Oracle Applications Cloud

3. Hadoop-Based Data Reservoirs Unite with Data Warehouses –> Your Data Warehouse and Hadoop – Better Together Featuring Cloudera Webcast

4. New Skills Bolster Big Data Investments –> In search of Insight and Foresight – Getting more out of Big Data

5. Big Data Discovery is the Secret to Workforce Success for HCM –> Harnessing the Power of Employee Sentiment

6. Predictive Analytics Lend Fresh Insight into Big Data Strategies –> Oracle Advanced Analytics Option

7. Predictive Analytics Bring New Insight to Old Business Processes –> Big Data @ work – Real-Time Fraud Detection and Prevention

  • White Paper Big Data Analytics: Advanced Analytics in Oracle Database
  • White Paper Bringing R to the Enterprise
  • White Paper Oracle Engineered Systems – Engineered for Extreme Performance

8. Decision Optimization Technologies Enhance Human Intuition –> Oracle Real-Time Decisions Review by James Taylor

9. Business Leaders Embrace Packaged Analytics –> Packaged Analytic Applications: Accelerating Time and Value

10. New Skills Launch New Horizons of Analysis –> Oracle Training

If you are interested in; Succeeding with Enterprise Performance Management in 2014, please check here.

Check it out yourself

Check here for the Pre-Built Developer VMs (for Oracle VM VirtualBox). Pay special attention to the ‘SampleApp V309’ (Oracle BI Foundation) and the ‘BigDataLite 2.5’. If you are interested in Endeca, you might want to download an Endeca Virtual Machine here.

There are also some hosted environments online for Oracle BI (prodney / Admin123) and Endeca (publicuser@oracle.com / Admin123)

If you would like some guidance, you might want to check out the Oracle Learning Library (OLL).

RM BI Forum 2013 – Day Two

Check out my RittmanMead BI Forum 2013, Day Two Notes

Adam Seed & Charles Elliot – Oracle Endeca looking beyond the general demos

Oracle Endeca 3.0 Difficult to install into Weblogic

Endeca Portal – repository
Endeca Server
Endeca Provisioning for uploading Excelsheet
Endeca Integrator – client

Collaboration of Software
Liferay – Endeca Studio
Oracle MDEX Server
Clover ETL (Integrator)
Lexalytics – Text Enrichment

Configuration Load –> Getting Started
Row Level Security
GEO Mapping – Google Maps

OBIEE as a Datasource using Integratorion
BI Publisher Datamodel Integration
Catalog Search

Edelweiss Kammermann – integrating Oracle BI, BPM and BAM, the complete cycle of Information

Oracle BPM – Business Process Management
Oracle BAM – Business Activity Monitoring

Oracle BI Webservice or Analyse
Process Cubes
Oracle ADF

Same Framework
More Insight
Automation and Interaction

Mike Durran – Virtualize Exalytics
Oracle VM – Smaller licenses – Trusted partitioning to run a subset of the 40 cores
RAID-1 for the OS (Oracle Linux)
RAID-5
OCFS – Oracle Clustered Filesystem

Big Data – Hype or Future

This is a very difficult discussion. First of all, what is the definition of Big Data? I liked the ‘definition’ of Peter Scott; If you do not care about a single row, you refer to Big Data. Sounds plausible. Is Big Data about tools (Hadoop vs. Oracle Database)? Is Big Data about the difference between structured and unstructured data? In a way all data can be referred to as structured. There is a whole new source of (Social) Data which didn’t exist before. Is that Big Data?

All in all one essential question is; what are you going to do with the data? Just collecting data, because everybody does it would be useless.

Making decisions on data which is only for 95% correct is whole new way of thinking as opposed to traditional (Financial) DWH-systems. I guess (almost) everybody agreed on that.