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.

Tuesday Jul 14, 2015

Partner Technical Training for In-Memory Database and Cloud PaaS

Please see below for local Technical Training for OPN member Partners only:

Oracle In-Memory Technical Workshop (2 days)

Oracle Database Cloud Service Technical Workshop (1 day)

Oracle Database Cloud Service Technical Workshop (extra content, 2 days)

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 

    Training for Oracle BI-Applications 11g with ODI 2-Day Master-class

    On Jul 29 - Jul 30, 2015: in London, UK. Free of charge to OPN member partners from any country.

    For details and to Register for Event click here

    You can attend this 2-day Oracle Business Intelligence Applications Master-class for existing BI-Apps 7.9.6 consultant specialists, covering the latest 11g version of BI-Apps which offers ODI for the ETL component.


    This training will provide attendees with an in-depth working understanding of the new BI-Apps 11g architecture, the technical and the functional content of the Oracle Business Intelligence Applications, whilst also providing an understanding of best practice for installation, configuration and extension.


    This Master-class is only for existing BI-Apps 7.9.6 consultants (with Informatica), with priority places for those with OPN Specialisation in BI-Apps. 

    For details and to Register for Event click here

    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

    BI, EPM & Big Data in Focus June 2015


    Enterprise Performance Management

    Big Data and Business Intelligence

    Wednesday Jun 10, 2015

    Partner Web-conference Update on What is New for BICS

    You can REPLAY this Conference by clicking on Replay Webcast (originally on 22/June, audio will play over your computer speakers or headset, but you have to login to Oracle first).

    This Partner Web-conference update was on what is new for BICS, where we showed some of the latest features such as Visual Analyzer and discussed some of the use-case study stories for the many customers who have already bought into the Oracle BI Cloud Service. We also confirm the partner resell and referral processes for you to earn your partner margin.

    If you need to catch up on the past announcements, try the links below:

    Friday May 29, 2015

    Enterprise Performance Reporting Cloud Tutorials

    Following last month’s announcement (New Oracle Enterprise Performance Reporting Cloud Service), here is a great set of video tutorials for EPRCS.

    2 minute Summary Video: Streamline your internal and external reporting processes, bringing together data plus narrative, in a single, secure, collaborative environment with Oracle Enterprise Performance Reporting Cloud.

    Find all these tutorials here:

    1. Creating Users and Assigning Roles for Oracle Enterprise Performance Reporting Cloud Service
    2. Importing Users and Roles for Oracle Enterprise Performance Reporting Cloud Service
    3. Application Overview for Oracle Enterprise Performance Reporting Cloud Service
    4. Authoring and Approving Doclets in Smart View
    5. Creating Advanced Ad Hoc Reports using Smart View
    6. Creating Basic Ad Hoc Reports using Smart View
    7. Creating Data Grants in Oracle Enterprise Performance Reporting Cloud Service
    8. Creating a Custom Application in Oracle Enterprise Performance Reporting Cloud Service
    9. Creating the Report Package Structure in Oracle Enterprise Performance Reporting Cloud Service
    10. Granting Access to Artifacts in Oracle Enterprise Performance Reporting Cloud Service
    11. Integrating Oracle Enterprise Performance Reporting Data with Microsoft Office Using Smart View
    12. Loading and Extracting Dimension Members in Oracle Enterprise Performance Reporting Cloud Service
    13. Managing Content in Report Packages in Oracle Enterprise Performance Reporting Cloud Service
    14. Managing Data in Oracle Enterprise Performance Reporting Cloud Service
    15. Managing Dimensions in Oracle Enterprise Performance Reporting Cloud Service
    16. Migrating Applications in Oracle Enterprise Performance Reporting Cloud Service
    17. Overview: Report Package Part 1 in Oracle Enterprise Performance Reporting Cloud Service
    18. Overview: Report Package Part 2 in Oracle Enterprise Performance Reporting Cloud Service
    19. Overview: Understanding Security in Oracle Enterprise Performance Reporting Cloud Service
    20. Overview: Understanding Style Samples in Oracle Enterprise Performance Reporting Cloud Service
    21. Overview: Using Smart View in Oracle Enterprise Performance Reporting Cloud Service
    22. Overview: Welcome to Enterprise Performance Reporting Cloud
    23. Reviewing Report Package Content in Smart View
    24. Setting Up Smart View for Oracle Enterprise Performance Reporting Cloud Service
    25. Signing off on Report Packages in Smart View

    BICS Partner Training 2-day Workshops

    These “PaaS to Extend SaaS - BI Cloud Service” BICS workshops consists of presentations, live demos, and hands-on laboratory exercises with the objective to help BI consultants learn how to implement Oracle BI Cloud Services for their clients.

    Start Dates

    Week days


    Country Contact



    IT, Milan.



    NL, Utrecht.



    CE, Prague.



    UK, Reading



    ES, Madrid.



    Remote Web-LVC


    To register, please provide the following information for all people from your company wishing to attend, to your local Oracle A&C channel manager contact: Workshop, Workshop date, Partner Company, Participant's name, Participant's Corporate Email. Participation instructions will be provided together with the confirmation email. If you do not know your local contact, then please address your registration request to the above country contact.

    Prerequisites - This workshop requires attendees to provide their own laptop. Students are expected to know the following before attending the training:

    Thursday May 28, 2015

    Understanding the Partner Opportunity in Oracle Cloud PaaS plus SaaS Combinations

    Please take advantage of these upcoming Oracle Cloud PaaS (Platforms as a Service) webcasts available for Oracle partners to learn about Oracle Cloud PaaS offerings such as BICS, and our strategy and roadmap. Oracle partners can take the opportunity to skill up in the latest Oracle PaaS technology and ask questions directly of Oracle PaaS specialists.




    Why should Oracle partners care about Oracle PaaS

    Wed 20 May @16:00 UK / 17:00


    Digital Mobile Cloud Business Opportunities for Partners

    Wed 3 June @16:00 UK / 17:00 CET


    Hybrid Cloud Integration Business Opportunities for Partners

    Thur 18 June @16:00 UK / 17:00 CET


    Oracle Integration Cloud Service (ICS) Technical Overview

    Thur 4 June @16:00 UK / 17:00 CET


    Oracle Document Cloud Service (DOCS) Technical Overview

    Wed 10 June @16:00 UK / 17:00 CET


    Process Cloud Service (PCS) Technical Overview

    Wed 24 June @16:00 UK / 17:00 CET


    Business Intelligence Cloud Service (BICS) Technical Overview

    Wed 1 July @16:00 UK / 17:00 CET


    Tuesday May 26, 2015

    Publish Your Apps and Services to Oracle Cloud Marketplace

    Partners can Advertise their Apps and services from Oracle Cloud Marketplace.

    Oracle Cloud Marketplace is an online store for our customers, dedicated to marketing cloud business apps and professional services offered by Oracle Cloud partners.

    Are you an independent software vendor or integrator ?

    Do you develop apps that work on, with or extend an existing Oracle Cloud solution (Paas or SaaS) ?

    Do you provide consulting, training, or integration services for Oracle Cloud ?

    You can take the next step and join us today to get access to the Partner Portal so you can showcase your apps or services on Oracle Cloud Marketplace (e.g. to work with BICS, PBCS or EPRCS).

    For example on our Business Intelligence Cloud, partner KPI has published their App, “KPI Cloud Analytics: Procurement and Spend Analytics for Oracle EBS”, so our clients can easily analyze their EBS procurement data using their app installed and running on the PaaS Oracle BI Cloud Service (BICS).

    • eBook: Customers - Discover Oracle Cloud Marketplace

    • eBook: Partners - Market Your Cloud Apps and Services

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



    « February 2016