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

Business Analytics EPM and Big Data Product Strategy Event for Partners in Europe, Middle East & Africa

November 11, 2015 9:00am – 5:30pm

Radisson Blu Edwardian Hotel at Heathrow
140 Bath Rd, Hayes
London UB3 5AW
United Kingdom

Register for London Event

November 15, 2015 9:00am – 5:30pm

JW Marriott Marquis Hotel Dubai
Sheikh Zayed Road
Business Bay Dubai 121000
United Arab Emirates

Register for Dubai Event

We are doing exclusive briefings in London and Dubai for EMEA Partners, on the latest Product updates for Oracle Business Analytics, EPM, Big Data and Data Integration.

If you missed out on Oracle OpenWorld this year, you have another chance with Matt Bradley (SVP of Development for Business Analytics) and his management team to hear about the latest developments, innovations and enhancements that have been added to the Oracle Business Intelligence, Big Data Analytics, Data Integration and Enterprise Performance Management product portfolio.

Detailed sessions will include roadmap updates on the following topics:

Ø Evolving trends in the Analytics space such as cloud and mobile

Ø Self- Service Analytics

Ø OBI 12c, BI Ask & Visual Analyzer

Ø The Value of Big Data and Data Discovery

Ø Data Integration and Governance for Big Data and Business Analytics

Ø Hyperion Financial Planning & Budgeting and Planning & Budgeting in the Cloud

Ø Financial Close

Ø Enterprise Performance Management Reporting Cloud Service

The forum agenda splits into two tracks, one for Analytics and Big Data, and the other for EPM, and you can find more information by clicking the Register for London Event / Register for Dubai Event links.

There will also be a dinner held on the evenings of the 11th & 15th November from 6:30pm, where you will be able to mix with the presenters and a selection of customers who will attend a similar product strategy update on the following day.

Please note that spaces for this event are limited and as such will be allocated with priority to OPN member specialist partners, with a maximum of 2 representatives per company & country (per track) – Please do not book travel until your place has been confirmed.

Tuesday Sep 15, 2015

BI, EPM & Big Data in Focus September 2015


Enterprise Performance Management

Big Data and Business Intelligence

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.

Wednesday Aug 19, 2015

Oracle Big Data Discovery Version 1.1

Partners and customers can replay our webcast with Cloudera, Unlock Your Analytic Talent with the Visual Face of Hadoop (originally on August 29).

Oracle Big Data Discovery version 1.1 is now available. This release extends Oracle’s innovation in Big Data Analytics by bringing together the best open-source and Oracle technologies, enabling you to reach more of the market and address more of your clients’ analytics challenges.

  • Big Data Discovery now runs on Hortonworks HDP 2.2.4+, in addition to Cloudera CDH 5.3+.  That makes BDD the first Spark-based big data analytics product to run on the top two Hadoop distributions, significantly expanding your market opportunity.
  • Customers can now access enterprise data sources via JDBC, making it easy to mash up trusted corporate data with big data in Hadoop.  BDD 1.1 elegantly handles changes across all this data, enabling full refreshes, incremental updates, and easy sample expansions.  All data is live, which means changes are reflected automatically in visualizations, transformations, enrichments, and joins.
  • Dynamic visualizations fuel discovery – but no product can include every visualization out-of-the-box.  This release includes a custom visualization framework that allows customers and partners to create and publish any visual and have it behave like it is native to BDD.  Combined with new visualizations and simpler configuration, this streamlines the creation of discovery dashboards and rich, reusable discovery applications.
  • Big Data Discovery is unique in allowing partners and customers to find, explore, transform, and analyze big data all within a single product.  This release significantly extends BDD Transform, making it both easier and more powerful.  New UIs make it easy to derive structure from messy Hadoop sources, guiding users through common functions, like extracting entities and locations, without writing code.  Transformation scripts can be shared and published, driving collaboration, and scripts can be scheduled, automating enrichment.  Transform also includes a redesigned custom transformation experience and the ability to call external functions (such as R scripts), providing increased support for sophisticated users. 
  • BDD 1.1 supports Kerberos for authentication (both MIT and Microsoft versions); enabling authorization via Studio (including integration with LDAP) to support Single Sign-on (SSO); and providing security at both project and dataset levels.   These options allow customers to leverage their existing security and extend fine-grained control to big data analytics, ensuring people see exactly what they should.

Also see “Big Data Discovery” Hosted Demonstration Instances for Partners.

And if you wish to deep dive into Spark (although to use BDD, this is not needed), I suggest you check out the Cloudera Developer Training for Apache Spark.

Tuesday Aug 04, 2015

BI, EPM & Big Data in Focus August 2015


Enterprise Performance Management

Big Data and Business Intelligence

Monday Jul 20, 2015

“Big Data Discovery” Hosted Demonstration Instances for Partners

Partners can now access Oracle Big Data Lite with Big Data Discovery on the Oracle hosted “GSE” system (Global Sales Engineering) @

If you are familiar with the Big Data Lite 4.2 virtual machine, we have taken that and hosted it in GSE, and added Big Data Discovery 1.0 as well. Therefore this demo platform provides an integrated environment to help you get started with the Oracle Big Data platform components – including Oracle Big Data Discovery, Cloudera, Oracle NoSQL, Oracle Big Data Connectors, Oracle Data Integrator, and many more. The demo is hosted and with internet facing access allows you to easily customize your demo: although you can only make bookings for this demo instance on a temporary basis.

However, prior to making a request, a partner must register with GSE for access to the demo systems as previously explained here at Demonstration Systems for Partners.

In summary, OPN Member Partners can Learn more and Apply for Access to GSE ( ... and follow the link CLICK HERE for On Premise Demonstration Environments ), and once approved, can access the link to book and run “On Premise” Big Data, OBI and BICS cloud demos @

Wednesday Jul 15, 2015

OBI11g Analyses Hadoop data directly (without ETL) using Oracle Big Data SQL

You may have noticed that OBI can now analyse Hadoop data directly (without ETL) using Oracle Big Data SQL for Data Access (or Cloudera’s Impala), and can easily join it with other OBI data sources onto one dashboard. To find out more you can review the Big Data documentation below, and try it for yourself by downloading the Demonstration VM for OBI 11g SampleApp v506 including Cloudera and Big Data SQL.

Oracle Big Data Appliance Software User's Guide

1 Introducing Oracle Big Data Appliance

2 Administering Oracle Big Data Appliance

3 Supporting User Access to Oracle Big Data Appliance

4 Configuring Oracle Exadata Database Machine for Use with Oracle Big Data Appliance

5 Optimizing MapReduce Jobs Using Perfect Balance

6 Using Oracle Big Data SQL for Data Access

7 Oracle Big Data SQL Reference

Essentially, Oracle Big Data SQL accesses Hadoop via external tables to:

  • ORACLE_HIVE: Enables you to create Oracle external tables over Apache Hive data sources. Use this access driver when you already have Hive tables defined for your HDFS data sources. ORACLE_HIVE can also access data stored in other locations, such as HBase, that have Hive tables defined for them. The DBMS_HADOOP PL/SQL package contains a function named CREATE_EXTDDL_FOR_HIVE. It returns the data dictionary language (DDL) to create an external table for accessing a Hive table.
  • ORACLE_HDFS: Enables you to create Oracle external tables directly over files stored in HDFS. This access driver uses Hive syntax to describe a data source, assigning default column names of COL_1, COL_2, and so forth. You do not need to create a Hive table manually as a separate step: you can just define the record format of text data, or you can specify a SerDe for a particular data format.

External tables do not have traditional indexes, so that queries against them typically require a full table scan. However, Oracle Big Data SQL extends SmartScan capabilities, such as filter-predicate offloads, to Oracle external tables with the installation of Exadata storage server software onto an Oracle Big Data Appliance. This technology enables the Oracle Big Data Appliance to discard a huge portion of irrelevant data—often up to 99 percent of the total—and return much smaller result sets to the Oracle Exadata Database Machine. Therefore, End users obtain the results of their queries significantly faster, as the direct result of a reduced load on Oracle Database and reduced traffic on the network.

Note that alternatively, and similarly, Oracle SQL Connector for HDFS provides access to Hadoop data for all Oracle Big Data Appliance racks, including those that are not connected to Oracle Exadata Database Machine. However, it does not offer the performance benefits of Oracle Big Data SQL: see Oracle Big Data Connectors User's Guide.

Thursday Jul 09, 2015

BI, EPM & Big Data in Focus July 2015


Enterprise Performance Management

Big Data and Business Intelligence

Download Demonstration VM for OBI 11g SampleApp v506 with Big Data

The OBIEE SampleApp v506 virtual box appliance is now available for public download by customers and partners. The image and deployment documentation can be downloaded from OTN at the OBIEE SampleApp page.

The v506 image content demonstrates capabilities of the v11.1.1.9 OBIEE stack, Oracle DB In-Memory and v12.1.0.2 database and several other OBIEE functional integrations, such as OBI accessing Hadoop data (Cloudera CDH 5.1.2) via both Impala and Big Data SQL.

  • A “What’s-new” pdf is available here for an overview of new content on v506
  • This YouTube playlist here includes a few view-lets about major new content areas
  • NOTE: You need 130 Gb of free disk to install and 16Gb of RAM to use this SampleApp v506 

    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

    Tuesday May 19, 2015

    OBI 11g Release Now Available

    This new release of Oracle Business Intelligence v., includes a number of new features and a focus on overall quality improvement. Significant new features and enhancements include:

    Expanded Data Source Support, including support for Cloudera Impala and Hive2.  Users can also access information directly from their Hyperion Planning applications to build and deliver analytical content with OBI. Integration with the Oracle 12c database has been enhanced with support for compression, Exadata Hybrid Columnar Compression (EHCC), and in-memory Oracle database features.

    Improved User Experience, including a new Tree Map visualization. Subject area search makes it easier to locate elements to add to an analysis. Users can now save and re-use custom column definitions.  More options are available to users when exporting content.  Customers can now take advantage of HTML5 for rendering charts.

    New Capabilities for Exalytics, including support for count distinct aggregations.  Aggregations for levels with non-unique level keys, ragged and skip level hierarchies, and time levels with no chronological keys are also supported.  A new Summary Advisor command line utility is available to assist with scripting maintenance tasks.

    New Capabilities for Administration, including Mobile App Designer installed by default.  A database policy store is available for security administration.

    BI Publisher Integration with WebCenter Content: This integration will enable customers to deliver BI Publisher output directly to WebCenter Content.

    More information:

    Monday May 18, 2015

    Cloudera is Hadoop Market Leader

    Have you connected with Cloudera ? – are you one of their partners yet, because this is a win-win for us all.

     - REPLAY the Oracle & Cloudera webcast (from Friday, May 29 ) - Rapidly Unlock the Value of Big Data for your Organisation

    Oracle has a close partnership with Cloudera in that we resell their Hadoop version on our engineered platform, the Big Data Appliance. Additionally we obviously therefore target our big data software stack (e.g. Big Data Discovery, Big Data SQL, Connectors, ODI, ...) to run on Cloudera, as well as on Apache Hadoop and some of the other vendors.

    If you had not noticed yet, Hadoop is growing really fast, and Cloudera has the lion’s share of this market: e.g. read this analyst report, saying:

    “According to Cloudera’s CEO, Tom Reilly, Cloudera’s strategic decision to provide proprietary solutions in an open-source market paid off when Cloudera earned more than $100 million in revenues in 2014, which is more than double the revenues of Hortonworks and MapR.”

    You may also have noticed that Intel announced a substantial equity investment in Cloudera ($740 million): and Intel works closely with Oracle on our engineered platforms, including the Big Data Appliance.

    Training your people in Hadoop is critical to our combined success in this market, and Cloudera leads the market in high quality Hadoop courses, plus see the Cloudera Product Webinars tutorials and Training Webinars. Oracle will of course invest in training our partners on our specific product offerings for Big Data, but for a generic understanding of the base platform, I suggest you plug into Cloudera’s education programmes. They also have a certification programme so you can Become a Cloudera Certified Big Data Professional.

    If you need an introduction, please contact me ( ) or Cloudera’s EMEA Partner Director, Jonathan Cooper @

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



    « October 2015