Tuesday Nov 03, 2015

BI, EPM & Big Data in Focus November 2015


Enterprise Performance Management

Big Data and Business Intelligence

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 @ https://blogs.oracle.com/R/ and https://blogs.oracle.com/datamining/. 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

Oracle Big Data Discovery 2-day Training Workshop

Nov 18 - Nov 19, 2015 - Register Now

This 2-days workshop, FREE to OPN member partners in EMEA, provides attendees with hands-on experience using Big Data Discovery version 1.1

In this workshop, you will start with a visual catalog of data in Hadoop to quickly see data sets, then explore it visually to understand its shape, quality and overall potential. You will be able to transform and enrich data in Hadoop, without complicated modeling or programming, simplifying prep and making the data better for future projects. And of course the discovery interface will make it easy for you to combine data sets and search, navigate and visualize new insights, then share results by collaborating within the tool and also publishing results back to Hadoop.

Nov 18 - Nov 19, 2015 – For more information and to Register Click Here

Oracle Office Reading, Oracle Thames Valley Park

Oracle Parkway, Reading RG6 1RA

United Kingdom

Tuesday Oct 20, 2015

Oracle Red Radio Discusses Big Data

Oracle Red Radio is the new weekly show exclusively for partners to hear insights from senior Oracle and Partner executives on what is relevant to you, our Partners.

On Friday 20th November at 17:00 the show will be discussing Big Data in the company of Mike Connaughton, Oracle Big Data Leader for EMEA.

Tune in to hear:

  • The size of the opportunity and how we can jointly work together to maximize revenues in this exciting market place
  • What’s Big Data means, what’s going on in the industry and why customers are adopting Big Data
  • Oracle’s solutions for Big Data and how we’re positioning them to customers


With news, sport and weather updates and our guest quiz it promises to be a compelling and entertaining show.

Join us here, and find prior recordings for replay: http://feeds.feedburner.com/OracleRedRadioShow

Monday Oct 12, 2015

BI, EPM & Big Data in Focus October 2015




Enterprise Performance Management


Big Data and Business Intelligence


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) @ https://demo.oracle.com

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 @ https://demo.oracle.com.

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 



    « November 2015