Wednesday Oct 28, 2015

Predictive and Advanced Analytics with Oracle BI

Partners can differentiate their services by adding extra smart predictive and advanced analytics to Oracle BI deployment projects.  Indeed OBI 12c now includes some capabilities integrated into OBI: but there are many additional techniques and tools to provide “data science” integrating Oracle Database, OBI and Hadoop with Advanced Analytics.

The core database Oracle Advanced Analytics product consists of two components, and you can learn more of these from a series of on-demand free of charge tutorials:

And there is a more general introduction @ Video Lecture Series Data Science Boot-Camp Tutorials. To get some practice on getting this all to work together, you can download pre-packaged VMs from OTN all set up ready to work:

Oracle University also offers Data Mining Techniques, available as Training on Demand, which includes access to labs to do the practical - you can see a demo on this course hereThere is also the Oracle R Enterprise Essentials course available as a scheduled Live Virtual Class.

There are many more aspects to “Advanced Analytics” with Oracle, for example you can follow some articles @ advanced and @ and Among the other components critical to specific types of analytical problems are the Spatial and the RDF-Graph options which run in the Database and we now have Big Data Spatial and Graph Analytics for Hadoop.

Oracle can even provide Real-Time Decisions using machine learning to make optimal decisions in the circa 100ms timeframe; reacting to events such as fraud detection, machine failure or to increase revenue by improving the probability of click-to-buy on a web-commerce shopping cart.

Monday Oct 26, 2015

OBI 12c Major Release is Available

BI 12c is the strategic foundation of Oracle’s analytics platform, delivering significant new value and lower total cost of ownership to the many existing Oracle BI customers, as well as being a compelling analytics platform for new customers.  BI 12c is critical to Oracle’s hybrid strategy, complementing BI Cloud capabilities by making fast, friendly data visualization and managed, scalable enterprise-class analytics available on-premises.

The new Data Visualization offering appeals to a large set of existing Oracle BI users, as well as opening up expansion opportunities with new users.

What’s New

BI 12c delivers a major update to the Oracle BI platform, with enhancements across the entire platform, as well as new Data Visualization capabilities.  Highlights and benefits include:

Easy to upgrade:  BI 12c offers a radically simple and robust upgrade from 11g, saving customers time and effort in moving to the new version.  BI 12c includes a free utility to automate regression testing, the Baseline Validation Tool, which verifies data, visuals, catalog object metadata, and system-generated SQL across 11g and 12c releases.

More Visual:  A consistent set of Data Visualization capabilities are now available across Oracle BI Cloud Service and Oracle BI 12c, as well as the upcoming Oracle Data Visualization Cloud Service, offering customers a continuity of visual experience unmatched by our competitors.  Business users can point and click to upload personal data and blend it with IT-managed data in BI 12c, which automatically infers connections between data sets.  Visualizing data is as easy as dragging attributes onto the screen, with optimal visualizations automatically displayed – no modeling or upfront configuration required.  Related data is automatically connected, so highlighting data in one visual, highlights correlated data in every other visual, immediately showing patterns and revealing new insights.  These insights, along with narrative comments, can be shared as interactive visual stories, enabling seamless collaboration that drives fact-based decisions.

More Advanced Analytics:  Predictive analysis is more tightly integrated, enabling customers to more easily forecast future conditions based on existing data points, group elements that are statistically similar, and expose outliers.  BI 12c includes the ability to run the free Oracle R distribution on BI Server, and extend existing analytics with custom R scripts, which can point to any engine (R, Oracle Database, Spark, etc.) without needing to change the BI RPD to deliver results.

More Mobile:  Keyword search (“BI Ask”) empowers users to literally talk to their data, asking questions and having visualizations automatically created as responses, opening up an easy entry point for authoring.  Additionally, the interface for iOS has been completely redesigned; and Mobile BI for Android offers sharing and following for nearby devices, as well as the ability to project any dashboard or story to GoogleCast-enabled devices.

Faster:  Sophisticated in-memory processing includes BI Server optimizations and support for multiple in-memory data stores, while in-memory Essbase on Exalytics offers enhanced concurrency and scalability, as well as significant performance gains.

Friendlier:  Usability updates throughout BI 12c demonstrate Oracle’s continued commitment to making analytics as fast, flexible, and friendly as they are powerful and robust.  A new user interface simplifies the layout for the homepage, Answers, and Dashboards, making it easier for users to quickly see what’s important; HTML-5 graphics improve view rendering; and it’s easier for users to create new groups, calculations, and measures, for simpler, more direct interaction with results.

Bigger Data:  BI 12c enables customers to use new data, from local, Oracle, and Big Data sources, including personal files uploaded by users; direct access to data in Hyperion Financial Management and Hyperion Planning applications; and ODBC access to Cloudera Impala.

Higher ROI, Lower TCO:  Streamlined administration and life cycle management reduce the time and resources required to manage BI 12c, decreasing costs and increasing value for this and future releases.  Enhancements include separating metadata from configuration; simpler, more robust security; easier backup, restore, and disaster recovery; hot patching of metadata; and many more.

Oracle BI 12c is available for download from OTN


Tutorials -

Monday Oct 05, 2015

Answer Big Data Questions – Webinar Series from Rittman

Mark Rittman, ACE Director and all things analytics and big data guru, is running a series of live webinars to answer some Big Data Questions you may be wondering about:

  1. How to Extend and enhance your Data Warehouse to address Big Data? - Register for Extend Data Warehouse - Tuesday 3 November
  2. What is Big Data Discovery and how does it complement traditional Business Analytics? - Register for Discovery webinar - Tuesday 10 November
  3. How to Add Big Data to your Organization to create true 360-Degree Customer Insight? - Register for Customer Insight - Tuesday 24 November


Extending and enhancing your Data Warehouse to address Big Data

Organizations with data warehouses are increasingly looking at big data technologies to extend the capacity of their platform, offload simple ETL and data processing tasks and add new capabilities to store and process unstructured data along with their existing relational datasets. In this presentation we'll look at what's involved in adding Hadoop and other big data technologies to your data warehouse platform, see how tools such as Oracle Data Integrator and Oracle Business Intelligence can be used to process and analyze new "big data" data sources, and look at what's involved in creating a single query and metadata layer over both sources of data.

Tuesday 3rd November, 15:00 – 16:00 GMT / 16:00 – 17:00 CET – Register for Extend Data Warehouse

What is Big Data Discovery and how does it complement traditional Business Analytics?

Data Discovery is an analysis technique that complements traditional business analytics, and enables users to combine, explore and analyse disparate datasets to spot opportunities and patterns that lie hidden within your data. Oracle Big Data discovery takes this idea and applies it to your unstructured and big data datasets, giving users a way to catalogue, join and then analyse all types of data across your organization. At the same time Oracle Big Data Discovery reduces the dependency on expensive and often difficult to find Data Scientists, opening up many Big Data tasks to “Citizen” Data Scientists.

In this session we'll look at Oracle Big Data Discovery and how it provides a "visual face" to your big data initiatives, and how it complements and extends the work that you currently do using business analytics tools.

Tuesday 10th November, 15:00 – 16:00 GMT / 16:00 – 17:00 CET Register for Discovery webinar

Adding Big Data to your Organization to create true 360-Degree Customer Insight

Organisations are increasingly looking to "big data" to create a true, 360-degree view of their customer and market activity. Big data technologies such as Hadoop, NoSQL databases and predictive modelling make it possible now to bring highly granular data from all customer touch-points into a single repository and use that information to make better offers, create more relevant products and predict customer behaviour more accurately.

In this session we'll look at what's involved in creating a customer 360-degree view using big data technologies on the Oracle platform, see how unstructured and social media sources can be added to more traditional transactional and customer attribute data, and how machine learning and predictive modelling techniques can then be used to classify, cluster and predict customer behaviour.

Tuesday 24th November, 15:00 – 16:00 GMT / 16:00 – 17:00 CET – Register for Customer Insight

For any questions about these webinars please contact Mark Rittman

Tuesday Sep 15, 2015

Download VM Oracle Big Data Lite 4.2.1 Including Big Data Discovery

We just released Oracle Big Data Lite 4.2.1 VM.  This VM provides many of the key big data technologies that are part of Oracle's big data platform.  Along with all the great features of the previous version, Big Data Lite now adds Oracle Big Data Discovery 1.1

Then you can follow the tutorials at Getting Started with Oracle Big Data Discovery and in the Oracle Big Data Learning Library.

All of these products are pre-configured in the Big Data Lite 4.2.1 VM:

· Oracle Enterprise Linux 6.6

· Oracle Database 12c Release 1 Enterprise Edition ( - including Oracle Big Data SQL-enabled external tables, Oracle Multitenant, Oracle Advanced Analytics, Oracle OLAP, Oracle Partitioning, Oracle Spatial and Graph, and more.

· Cloudera Distribution including Apache Hadoop (CDH5.4.0)

· Cloudera Manager (5.4.0)

· Oracle Big Data Discovery 1.1

· Oracle Big Data Connectors 4.2

· Oracle SQL Connector for HDFS 3.3.0

· Oracle Loader for Hadoop 3.4.0

· Oracle Data Integrator 12c

· Oracle R Advanced Analytics for Hadoop 2.5.0

· Oracle XQuery for Hadoop 4.2.0

· Oracle NoSQL Database Enterprise Edition 12cR1 (3.3.4)

· Oracle Big Data Spatial and Graph 1.0

· Oracle JDeveloper 12c (12.1.3)

· Oracle SQL Developer and Data Modeler 4.1

· Oracle Data Integrator 12cR1 (

· Oracle GoldenGate 12c

· Oracle R Distribution 3.1.1

· Oracle Perfect Balance 2.4.0

· Oracle CopyToBDA 2.0 

Download it, and check out the tutorials and demos that are available from the Big Data Lite download page.

Tuesday Jun 16, 2015

Big Data Spatial and Graph Analytics for Hadoop

We have just added Oracle Big Data Spatial and Graph support for Hadoop and NoSQL database technologies.  For over a decade, Oracle has offered leading spatial and graph analytic technology for the Oracle Database: we have now applied this expertise to work with social network data and to exploit Big Data architectures.  

Oracle Big Data Spatial and Graph includes two main components:

  1. A distributed property graph database with 35 built-in graph analytics to discover graph patterns in big data, such as communities and influencers within a social graph
  2. A wide range of spatial analysis functions and services to evaluate data based on how near or far something is to one another, or whether something falls within a boundary or region

Property Graph Data Management and Analysis

Property graphs are commonly used to model and analyze relationships, such as communities, influencers and recommendations, and other patterns found in social networks, cyber security, utilities and telecommunications, life sciences and clinical data, and knowledge networks.  

Property graphs model the real-world as networks of linked data comprising vertices (entities), edges (relationships), and properties (attributes) for both. Property graphs are flexible and easy to evolve; metadata is stored as part of the graph and new relationships are added by simply adding an edge.

Oracle Big Data Graph provides an industry leading property graph capability on Apache HBase and Oracle NoSQL Database with a Groovy-based console; parallel bulk load from common graph file formats; text indexing and search; querying graphs in database and in memory; ease of development with open source Java APIs and popular scripting languages; and an in-memory, parallel, multi-user, graph analytics engine with 35 standard graph analytics.

Spatial Analysis and Services – Enrich and Categorize Your Big Data with Location

With the spatial capabilities, users can take data with any location information, enrich it, and use it to harmonize their data.  For example, Oracle Big Data Spatial can look at datasets like Twitter feeds that include a zip code or street address, and add or update city, state, and country information. These results can be visualized on a map with the included HTML5-based web mapping tool.  Location can be used as a universal key across disparate data commonly found in Hadoop-based analytic solutions. 

“Big Data systems are increasingly being used to process large volumes of data from a wide variety of sources. With the introduction of Oracle Big Data Spatial and Graph, Hadoop users will be able to enrich data based on location and use this to harmonize data for further correlation, categorization and analysis. For traditional geospatial workloads, it will provide value-added spatial processing and allow us to support customers with large vector and raster data sets on Hadoop systems.” - Steve Pierce, CEO, Think Huddle

Your Spatial & Graph specialist contact in EMEA is Hans Viehmann (

You can attend a live web-conference on Spatial & Graph on Tuesday, July 21st at 6:00 PM UK / 7:00 PM CET

Wednesday May 13, 2015

Information Management & Big Data Architecture Masterclass

Jun 17 - 10:00 am - 4:00 pm in London UK.

Get more information and to Register here: FREE of charge to OPN member Partners from any country.

Join our Information Management & Big Data Architecture Masterclass on 17th June 2015 where you'll learn how Oracle's information management approach can address business and IT issues in a timely, pragmatic and reliable way. Following great success of previous Master Classes on this subject, your presenters will follow a "free format" agenda using Whiteboards rather than formal presentations to allow as much interaction with you as possible.

Learn about the Big picture of information management, Staging and techniques for loading data, OLAP and Data Mining, Approaches to data modelling, Build vs buy, BI delivery, Operationalising BI, Security, ELT, ETL and data flows, Big Data, Performance, and Migrating to the reference architecture (customer examples).

Thursday Mar 12, 2015

Oracle Real Time Decisions hands-on Technical 2-Day Training Workshop

Apr 16 - Apr 17, 2015 in London, UK - Partners from all countries welcome.

This Oracle Real Time Decisions (RTD) hands-on technical 2-Day training course is designed for Partner individuals on the implementation team responsible for RTD installation and administration, to enable participants to perform tasks required to successfully configure and deploy RTD with their operational applications. Participants learn about various aspects of integration between RTD and target applications, including Siebel Call Center and E-Commerce, and are prepared to engage on RTD deployment projects at all levels of the project lifecycle, from gathering requirements to production rollout and monitoring.

The course introduces the RTD platform, describing its features, function, and capabilities. It also covers the RTD architecture, platform, and pre-built Base and Specialized solutions, including RTD for Intelligent Offer Generation and RTD for E-Commerce. The lesson topics are reinforced with structured hands-on practices during which participants create and deploy a fully functional inline service project from scratch.  This training is free of charge to OPN member partners.

Thursday Feb 26, 2015

EMEA Oracle Big Data Analytics Partner Forum 29th to 30th April 2015

For Partners in BI, Data Integration and Big Data - Partners from all countries welcome.

Big Data Analytics is gathering momentum and we would like to share with you the many Oracle Customer case studies that demonstrate why and how they are achieving great value for their organisations with Oracle Big Data Analytics.

Also get Hands-on experience with the game-changing new Big Data Discovery product.

29th -30th April, 2015 at the Hilton Madrid Airport, Spain - Register Now

This is your key annual event here in Europe to get the latest from Oracle to propel your business growth in Big Data Analytics. This event should appeal to Analytics, Big Data, Data Warehouse and Data Integration specialised Partners, Executives, Sales, Pre-sales and Solution consultants: with a choice of participation in the plenary day-1 and then two optional deep-dive sessions on day-2:

1. Big Data Discovery - Hands-on Technical Training

2. Big Data & Analytics Architecture Masterclass

Partners can attend to discover Oracle Big Data and Analytics from an initial client engagement perspective. See what is new in the latest version of Oracle Analytics and Big Data products and see how this translates into a cohesive solution architecture to support your projects and business transformation programmes. Understand how Analytics is positioned for the market opportunities from Big Data and greater business user demand for Self-service Visualisation and prototyping, as well as going deeper to support information discovery by Data Scientists.

There is no registration fee for OPN member partners for the conference which includes the plenary day, gala dinner, as well as any of the deeper dives and technical training, but you will be responsible for your own travel and hotel expenses.

Click here to Register Now and for more information. And check out these links:-

Session Guide:

29th April 2015: Day 1

Main Plenary Session
Full day - Registration 9.0 am, Dinner in the Evening

30th April 2015: Day 2

Big Data Discovery - Hands-on Technical Training
All day - starting 9.00 am

Big Data & Analytics Architecture Masterclass
All day - starting 9.00 am

Friday Feb 20, 2015

Oracle Big Data Discovery Now Available - The Visual Face of Hadoop

There has been a lot of excitement about Oracle Big Data Discovery, and it is now generally available to customers and partners and can be sold and installed now.

This is a stunningly visual, intuitive tool that enables you to leverage the power of Hadoop and turn raw data into business insight in minutes — without learning complex products or relying only on specialists.

From a partner perspective it is perfect for proof of concept work with your clients to reveal the value they can find in their large information reservoirs combining a variety of data and text sources; potentially leading to much more and deeper analysis as part of an overall big data information architecture.

To find out more see these videos:

Check out the Capabilities of Big Data Discovery to

  1. Easily find relevant data by browsing a rich, interactive catalog of all data in hadoop using familiar keyword search and guided navigation.
  2. Explore data to understand its’ potential by visualizing the shape and quality of unfamiliar data and combining attributes to uncover interesting relationships.
  3. Transform and enrich to make data better with intuitive, user-driven data wrangling.
  4. See rich, interactive visualizations that reveal new patterns by blending diverse data sets for deeper perspectives.

More Resources:

Thursday Feb 12, 2015

Take Mathematics to the Data with SAS High Performance Analytics on Oracle

Many Oracle partners have “Data Science” practices using SAS, who are one of our key ISV Partners in the statistical analytics space. Thousands of customers across every industry and public sector entrust their SAS deployments to Oracle databases, middleware, and systems infrastructure: and you and your clients can combine the power of SAS and Oracle as efficiently as possible by taking the mathematics to the data with SAS High Performance Analytics on Oracle Big Data Appliance and Exadata.

For example, see this 4 minute video discussion with Paul Kent, SAS VP - SAS Big Data Analytics on Oracle Engineered Systems.

Also download these papers and presentations:

Tuesday Dec 23, 2014

Big Data Analytics Sales and Solution Architecture 1-Day Workshop

February 17, 2015 – at the Oracle London Office, UK - Register for Event

OPN member partners from all EMEA countries are welcome to attend free of charge.

At this Big Data and Analytics Sales and Solution Architecture for Partners Workshop, partners can discover Oracle Big Data and Analytics from an initial client engagement perspective.

Walk away ready to talk confidently about Oracle Big Data, Real Time Decisioning, In-memory Analytics, OBI Foundation, Endeca and Private and Public Cloud solutions to your clients.

What we will cover

The agenda is aimed to deliver project-winning messages and high level demonstrations to everyone in the audience; recommending a process to engage with a client, to show business value and carry the client through a journey from discovering possibilities to completing a comprehensive information management and analytics architecture.

  • Winning new Big Data and Analytics projects with Oracle in 2015
  • Understand the Rise of the Data-Scientist and what has made Maths Cool
  • Solution Visualisation and prototyping techniques for Business Users and Data Scientists
  • Oracle on Oracle – Scale-able Servers for BI, In-Memory Analytics and Big Data
  • Oracle Big-Data and Analytics in the Cloud Services (PaaS)
  • A Transformational Architecture - Game changers for Big-Data Analytics and: the Opportunity for Oracle Partners
  • A Partners’ Get-Started-Kit for Oracle Big Data and Analytics and help for oracle partners to work with oracle sales.
  • Customer Value achieved in Case Studies of Big Data and Analytics Solutions

See what is new in the latest version of Oracle Analytics products and Big Data products and see how this translates into a cohesive solution architecture to support your projects and business transformation programmes. Understand how Analytics is positioned for the market opportunities from Big Data and greater business user demand for Self-service Visualisation and prototyping, as well as going deeper to support information discovery by Data Scientists. 

We will also introduce you to our “Hands-on Self-service Analytics Test Drives”. You as a partner, can then re-use our kits to run your own customer-facing Test Drive events to get their interest and build your sales pipeline – you do not need to be “technical” for this. 

Target Audience

Client executives, sales and solution architects from Oracle Partners will benefit from this event. Existing partners selling applications or technology or hardware will all benefit by being able to cross-sell Analytics and Big Data solutions to existing and new clients.

Tuesday Dec 02, 2014

Real-Time Decisions on Big Data

By continuously learning in real time, an adaptive solution can predict and optimize the outcome of each transaction, thereby improving the customer experience and maximising revenues. With increasing amounts and speeds of data acquisition, the solution needed for this must make many decisions automatically and very quickly (for example in less than a Tenth of a second for an effective eCommerce application) based on large amounts of data.

Many of our recent Big Data customer projects are driven by this need for high value real time decisions. As a Partners you can offer excellent ROI to you clients by deploying Oracle RTD (Real Time Decisions) to combine both rules and predictive analytics; instilling real-time intelligence into business processes or customer interactions as they happens.

Oracle Real-Time Decisions allows business users to adjust rules and predictive based decisions to optimize competing business goals, such as increasing revenue while decreasing servicing costs. Technically, RTD is based on an Open Service-Oriented J2EE Architecture - built on a service-oriented architecture (SOA) using industry-standard J2EE application servers (such as Oracle Application Server, BEA WebLogic and IBM WebSphere), and can be readily incorporated into many existing or new applications.

The Oracle Real-Time Decisions Base Application is a library of pre-configured components representing best practices for Decision Management implementations using Oracle Real-Time Decisions. The library contains two types of component: pre-configured Decision Services that can be used to implement specific decision patterns and Application Components that can be used by business users to support their decision management needs. The pre-configured Decision Services provide best practice patterns for E-Commerce and Customer Service interactions optimization, and contain hundreds of pre-built elements such as performance goals, data attributes, predictive models and reports. The pre-configured Application Components address the needs of business users in terms of content authoring, access and version control, search, collaboration and workflow integration.

These Application Components are then assembled together into a pre-configured Decision Management application for Marketing Optimization, a turn-key deployable solution for real-time inbound marketing optimization and collaborative decision management, now available as a component of the Oracle Real-Time Decisions Base Application.

For example, in the context of E-Commerce, the Oracle Real-Time Decisions Base Application provides a generalized Inline Service for the purpose of optimizing E-Commerce interactions for Oracle or non-Oracle E-Commerce systems, while Oracle Real-Time Decisions for Siebel E-Commerce is a pre-packaged version of the above mentioned Inline Service that has been tailored for the Siebel E-Commerce Application. Similarly, the Siebel Intelligent Offer Generation product (IOG) extends Siebel Marketing and Siebel Contact Center with RTD capabilities for Contact Call Centres.

For more information see RTD on OTN, and at

Thursday Nov 20, 2014

Partners’ Get-Started-Kit with Oracle Big Data and Analytics

If you are struggling with how (and why) to get started with “Big Data” and Hadoop based tools with Oracle and your Analytics practice, then see below for some resources and I will post some additional topics and hints on this theme in the next month. Especially start by trying the ETL tools (ODI & GoldenGate) on Hadoop as a lower cost ETL and staging platform for any data warehouse, and try out the new Oracle Big Data Discovery, Now Available - The Visual Face of Hadoop.

Hands-on Labs - Big Data and Analytics

There are several hands-on-labs available to help you get started with the platform which you can practice by downloading the pre-configured VM (Oracle Big Data Lite Virtual Machine):

Oracle Big Data Learning Library

Numerous hands on labs and videos for capabilities that span the Oracle Big Data platform.

Analyze All Your Data with Oracle Big Data SQL

Learn how to securely analyze all your data - across both Hadoop and Oracle Database 12c - using Oracle Big Data SQL

Access Data in Oracle NoSQL Database from Oracle Database

Access data in Oracle NoSQL Database from Oracle Database 12c using external tables.

Tame Big Data with Oracle Data Integration

Learn about how to design Hadoop data integration using Oracle Data Integrator and Oracle GoldenGate.

Integrate Hadoop Data with Oracle Database using Oracle Big Data Connectors

Use Oracle Loader for Hadoop to efficiently load data into the Oracle Database using MapReduce jobs. Access data in HDFS directly from the Oracle Database using Oracle SQL Connector for Hadoop.

Using SQL Pattern Matching

This series features both OBEs and recorded webcasts. Learn how to use SQL for Pattern Matching. Row pattern matching in native SQL improves application and development productivity and query efficiency for row-sequence analysis.

Oracle Data Mining 12c Tutorial Series

The OBE's in this series provide you with instructions on how to perform data mining with Oracle Database 12c, by using Oracle Data Miner 4.0. Oracle Data Miner 4.0 is included as an extension of Oracle SQL Developer, version 4.0.

Oracle R Enterprise v 1.4 - Tutorial Series

Oracle R Enterprise (ORE), a component of the Oracle Advanced Analytics Option, makes the open source R statistical programming language and environment ready for the enterprise and big data.

Introduction to Oracle NoSQL Database

Use Oracle NoSQL Database in the context of the Oracle MoviePlex application. Create schemas, load data and then utilize that data in the online movie application.

Oracle NoSQL Database - Installation/cluster topology deployment (pdf | scripts)

Learn how simple and intuitive it is to deploy a highly available (production ready) Oracle NoSQL Database cluster.

Data Manipulation with Hive and Pig (pdf  | script)

A Quick introduction to HDFS, Pig and Hive.

Oracle Big Data Lite Virtual Machine: Free Download (for testing, demo and educational purposes only)

This (version 4.0.1) provides an integrated environment to help you get started with Big Data. Many Oracle Big Data platform components have been installed and configured - allowing you to begin using the system right away, including:

  • Oracle Database 12c Release 1 Enterprise Edition (
  • Oracle Big Data SQL-enabled external tables
  • Cloudera Distribution including Apache Hadoop (CDH5.1.2)
  • Oracle Big Data Connectors 4.0
  • Oracle NoSQL Database Enterprise Edition 12cR1 (3.0.14)
  • Oracle JDeveloper 12c (12.1.3)
  • Oracle SQL Developer and Data Modeler 4.0.3
  • Oracle Data Integrator 12c R1 (12.1.3)
  • Oracle GoldenGate 12c
  • Oracle R Distribution 3.1.1

Thursday Oct 02, 2014

Big Data Discovery News from Oracle OpenWorld 2014

Thomas Kurian, Oracle’s executive vice president of product development, began his keynote speech at Oracle OpenWorld 2014 by discussing three major trends in business and culture—big data, mobility, and the cloud. He then detailed and demoed new products and services from Oracle that enhance customers’ ability to make use of all three.

Kurian introduced a new set of tools called Oracle Big Data Discovery, which allows database managers and engineers to work more effectively with Hadoop, as “the visual face of Hadoop”. Oracle Big Data Discovery lets users profile, explore, and analyze Hadoop data, and do prediction and correlation. “With Oracle Big Data Discovery, you will be able to explore and find patterns and problems with your data,” Kurian said. Find out what Information Week reported about this Hadoop Data Exploration Tool.

Oracle Big Data Discovery combined with Oracle Big Data SQL, a recently introduced toolset for working with data across relational and big data systems using Structured Query Language, represent a powerful combination of technologies for supporting a truly effective big data strategy.

Kurian also referenced several other technology developments by Oracle:

If you did not manage to visit Oracle OpenWorld 2014, then you can still find out about all of this news, in discussion with our Analytics development and strategy team here in Europe at the Oracle Business Analytics EMEA Partner Community Forum on 21st October to 24th October, 2014 in Utrecht, Netherlands.

Monday Jul 14, 2014

Managing Hierarchies in Financial Applications with DRM

Hierarchies and related links are fundamental to using financial, and indeed many other applications, for example:

  • When a new Chart of accounts is designed, linking an account to its parent is key for future aggregation of data.
  • When legal entities have to be sorted, hierarchies can be built according to dimensions such as geography or organizations.
  • In a General Ledger, every accounting flexible field is a potential analytical dimension.
  • Respecting relationships is also very important when reorganizing sales territories taking into account geography dimension, human resources, client or product information.

That’s why partners have a great opportunity to help their clients to better manage these hierarchies and relationships which are often used in EPM (Enterprise performance management) and Business intelligence. Financial Applications share entire or partial hierarchies with different levels of detail, different points of view. So, “Financial MDM” helps companies to be more efficient because hierarchies and their relationships are managed in a single place. Every modification impacts all applications at the same time. This increases consistency and data quality among all hierarchies.

Financial MDM has got the same DNA as other MDM domains and is a key tool to help partners implement new systems, upgrades and migrations for their clients because it accelerates deployment based on these coordinated and validated hierarchies. Financial MDM manages specific types of master data, such as:

  • Charts of accounts: consolidated, corporate or local. They can be different depending on application type. For instance, granularity is not the same for actual accounting or forecasting. They can be designed to meet different regulatory requirements: local, IFRS, GRI sustainability reporting or Solvency II in the insurance industry
  • Legal entities including different dimensions: geography, activities
  • Organizational dimensions : departments, business units, cost and profit centers
  • Analysis dimensions: using general ledger accounting flexible fields such as sales channels or projects
  • Reference data: time, currencies, taxes.

Financial master data needs to be quickly and easily adapted to business changes at the fast pace of business. Financial MDM is essential not only for minor modifications in day to day business, when creating a new cost centre or modifying an existing attribute for a legal entity, but also when making major changes such as mergers, acquisitions, reorganizations or regulatory changes.

Flexibility is the key to allow business users to easily make their own updates, plus these changes have to be part of a data governance process. A workflow is required to define roles and responsibilities.

Five reasons to invest in a Financial MDM

  1. Empower financial business users
  2. Ensure consistency in business hierarchies and related links
  3. Link local needs to corporate standards and consolidate all lines of business
  4. Accelerate Mergers & Acquisitions
  5. Analyze your master data across heterogeneous environments

See more at:



« November 2015