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 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 (hans.viehmann@oracle.com).

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

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:

Tuesday May 19, 2015

OBI 11g Release 11.1.1.9 Now Available

This new release of Oracle Business Intelligence v.11.1.1.9, 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:

Friday May 08, 2015

New Oracle Enterprise Performance Reporting Cloud Service (EPRCS)

Introducing the new Oracle Hyperion EPM cloud approach for secure, collaborative, and process driven reporting. On the Oracle public cloud customers can now buy the new Enterprise Performance Reporting Cloud Service (EPRCS).

  • You can listen to an explanation of this new service on our live EPRCS Webcast on Thursday, May 21, 2015 6:00 pm UK / 7:00 pm CET.

Oracle Enterprise Performance Reporting Cloud is a purpose-built solution in the Cloud for management and narrative reporting. It provides a secure, collaborative, process-driven approach for defining, authoring, reviewing, and publishing financial and management report packages for internal and external stakeholders.

Corporate and management reporting is experiencing significant change in today’s digital age. As reported earnings become more volatile, corporate guidance—and the ability of management to clearly explain the quality and sustainability of corporate performance—is more important than ever.

The current integration of narrative into performance-reporting processes is often manual, ad hoc, and highly prone to error. New cloud-based solutions, such as Oracle Enterprise Performance Reporting Cloud, enable organizations to streamline internal and external reporting processes, combining data plus narrative in a single, secure, collaborative environment.

Read more @ the EPM blog on Enterprise Performance Clearly Explained With a Collaborative, Intuitive, Reporting Solution.

Resources:

 

What is New in Oracle BI Cloud Service (BICS)

Anyone who subscribes to Oracle BI Cloud Service receives automatic upgrades as soon as new features become available. You don't need to request an upgrade or take any actions yourself. Go here to keep up to date with an overview of new features and enhancements added recently, for example in April 2015:

Explore data using Visual Analyzer

Visual Analyzer provides self-service analysis, seamlessly transitioning you between all phases of the analysis lifecycle: data staging, analysis, composition, and consumption. See Getting Started with Visual Analyzer, and Oracle Visual Analyzer is now Available with Demonstrations for Partners .

Manage access to Visual Analyzer through a new application role called BIDiscoveryContentAuthor. See Application Roles Predefined in Oracle BI Cloud Service.

Integrate with Oracle Database Cloud Service (Database as a Service)

Connect Oracle BI Cloud Service to any Oracle Database Cloud Service (Database as a Service) instance. See Changing the Database Connection.

Upload data models from a file

If you’ve modelled your data with Oracle Business Intelligence Enterprise Edition, then you don't need to start from scratch in Oracle BI Cloud Service. Simply upload your on-premises data model file (.rpd) to Oracle BI Cloud Service and start exploring your data through visualizations, reports, and dashboards. See Uploading Data Models from a File (.rpd).

Add your own data to analyses

You can add data from an external source to an analysis in Oracle BI Cloud Service. Adding your own data is sometimes referred to as “mash-up.” See Adding Data from External Sources to Analyses.

Oracle BICS Data Sync version 1

Oracle Business Intelligence Cloud Service Data Sync supports the load of on-premises data residing in one or more relational or comma-separated value file sources into the schema provisioned on Oracle Business Intelligence Cloud Service:

Thursday Apr 02, 2015

Cumulative Feature Tool for Oracle EPM Versions

Please try out this new web-based Cumulative Feature Overview Tool for Oracle EPM products. 

This web based Tool provides concise descriptions of new and enhanced features and functionality available between a user-selected starting and target releases.  You can also download the report output to various formats such as PDF and Excel, and it includes links to video feature overviews.  Feel free to pass this on to your customers.



Monday Mar 16, 2015

Oracle BI Applications 11.1.1.9.1 with Cloud Application Sources for Hybrid Analytics

Oracle Business Intelligence (BI) Applications 11.1.1.9.1, for installation ‘on-premise’, is now available on the Oracle Software Delivery Cloud, and on the Oracle BI Applications OTN page. This release is certified with the latest version of Oracle BI Foundation 11.1.1.7

New Oracle Cloud Application Sources for Hybrid Analytics

  • With the continued move to the Cloud, Oracle BI Applications has introduced support for the following Oracle Application Cloud sources: Oracle Sales Cloud, Oracle HCM Cloud, Oracle Financial Cloud, Oracle Procurement Cloud, and Oracle Project Cloud, to download cloud data to BI-Applications ‘on-premise’.

New Content Enhancements: Additional content improves existing Oracle BI Applications including:

  • Oracle Financial Analytics provides a new Essbase GL Balances model for improved EBS Financial Service Generator (FSG) Reporting and Hierarchy navigation, including support of ragged hierarchies for GL segment dimensions.
  • Oracle Project Analytics expands project-based insight with new Construction in Process (CIP) support, providing visibility for Project Stakeholders into in-progress costs, expensed costs since project inception and across organizations.
  • Oracle Procurement and Spend Analytics delivers new capabilities for Fusion Procurement, including Supply Chain Financial orchestration, negotiation and award approvals, and Buyer assignment controls.
  • Oracle Supply Chain & Order Management Analytics introduces new Inventory module support for PeopleSoft, including visibility into inventory balances, aging, transactions and valuation.
  • Oracle Student Information Analytics provides new subject area coverage for Student Financials Billing Summary and Transactions, with visibility to billing and transaction information by student or external organization.
  • Oracle Human Resources Analytics expands analysis on HR programs and workforce performance for Fusion HCM with support of Talent Management Analysis.
  • Oracle Sales Analytics introduces new subject areas for Activity Analytics, with support for Activity contact, resource and sales subject areas from Fusion Sales.

 

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

Hyperion Financial Management and Oracle EPM system New Version 11.1.2.4

A great service opportunity to partners offering upgrades and modernisation to their Hyperion clients, Oracle has just announced the new Oracle Enterprise Performance Management (EPM) System Release v 11.1.2.4. This new release incorporates key updates to the entire portfolio of EPM applications that enable organizations to engineer predictable performance, connect the enterprise, and further improve decision-making. See the press release here.

Oracle EPM System Release 11.1.2.4 includes a major update to Oracle Hyperion Financial Management (HFM) that delivers significant performance improvements as well as simplicity of administration with an all-unix-based deployment capability. HFM is now also available on Oracle Exalytics In-Memory Machine. With this addition, the entire Oracle Hyperion Financial Close Suite and Oracle Hyperion Planning is available on Oracle Exalytics (along with OBI Foundation, Endeca and In-Memory DB), offering simplified deployment, reduced total cost of ownership, and improved performance.

“With Oracle Hyperion Financial Management 11.1.2.4 we saw dramatic improvements in financial consolidation times. Executing a consolidation on our main organizational structure went from three hours to 15 minutes,” said Diane Ferry, administrator at Emerson for Oracle Hyperion Financial Management. “As we have many alternate organizational structures, the savings in consolidation times will allow us to have the application ready for our users more quickly. It will also allow our users to more quickly analyze their results.”

For more information:

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 Oracle.com.

Wednesday Nov 26, 2014

Oracle Enterprise Metadata Management 12c for Big Data and Analytics

One of the best reasons for introducing Hadoop into your clients is as a lower cost ETL and staging platform for any data warehouse... the so called “Data Lake” Concept. But as discussed by Gartner “Beware of the Data Lake Fallacy”... this still needs governance: “Without descriptive metadata and a mechanism to maintain it, the data lake risks turning into a data swamp.”

So, as a follow on to my last blog ( Partners’ Get-Started-Kit with Oracle Big Data and Analytics ), let’s now explore how you can help your clients to better govern and manage a cost effective data lake that delivers additional value to their data warehouse.

Oracle has expanded its Oracle Data Integration portfolio with the addition of Oracle Enterprise Metadata Management 12c, a comprehensive platform that helps reduce compliance risks and ensure the success of governance programs within organizations by providing much-needed business and data transparency (read the Press Release). Together with Oracle Enterprise Data Quality, Oracle Big Data SQL, and Oracle Database security you can manage and control all aspects of big data stewardship, lifecycle management, data protection, auditing, security, and compliance.

To find out more, start with these two webcasts:

Data Quality and Metadata Management for Big Data Governance webcast:
  • Understand how data governance can be applied to big data
  • Explore new Oracle Enterprise Metadata Management technology
  • Learn how data quality is integral to any data governance initiative

Big Data Integration for the Big Data Reservoir webcast:

  • Keep big data reservoirs accurate and real-time using Oracle Data Integrator and Oracle GoldenGate
  • Leverage Hadoop and Data Integration technologies across heterogeneous environments
  • Implement best practices using big data reservoirs to unlock the most value from your enterprise big data

Then try the Tutorial @ Tame Big Data with Oracle Data Integration

And Download a full version of Oracle Enterprise Metadata Management 12c software and documentation.

Thursday Nov 20, 2014

Real-time Big Data with Oracle GoldenGate 12c

Oracle recently announced the enhanced version of Oracle GoldenGate 12c with expanded support for heterogeneous databases and big data solutions, improved manageability, and support for hybrid cloud environments.

Oracle GoldenGate 12c provides best-of-breed, real-time data integration and heterogeneous database replication. Among many new features, is better support for Big Data with Oracle GoldenGate Adapter for Java enabling integration with Oracle NoSQL, Apache Hadoop, Apache HDFS, Apache HBase, Apache Storm, Apache Flume, Apache Kafka, and others which allows real-time, noninvasive data streaming into big data targets to give customers new insights into business and improve the customer experience.

Oracle GoldenGate is part of the industry-leading Oracle Data Integration portfolio, which includes real-time and bulk data movement, transformations, data governance, data virtualization, data quality and meta-data management. Oracle Data Integration has also gained notable industry recognition, with Gartner, Inc. naming Oracle a Leader in its July 24, 2014 Magic Quadrant for Data Integration Tools and Database Trends and Applications naming Oracle GoldenGate 12c a winner in the “Best Data Replication Solution” category of its 2014 Readers’ Choice Awards.

“Before embarking on a big data or cloud journey, enterprises need to ensure that they are not creating any more data silos – disjointed analytics leads to partial insights,” said Surya Mukherjee, senior analyst, Information Management at Ovum. “Oracle GoldenGate 12c is a step in the right direction; its new features allow real-time data integration across their diverse data platforms, so that enterprises can build strategies for their data and application universe, whether it be in the cloud, on-premises,  structured, or semi-structured.

For more information, see:

Wednesday Oct 29, 2014

New Model Exalytics In-Memory Machine X4-4

Oracle announced at OpenWorld, the availability of the new model Exalytics In-Memory Machine X4-4 to dramatically increase performance and capacity; leveraging the Oracle Database In-Memory option for faster data driven insights.

The latest refresh of Oracle Exalytics In-Memory Machine includes Intel Xeon processors customized for Oracle business analytics workloads, supporting 50 percent faster clock speed, 50 percent more processing cores and 50 percent more memory compared to the previous generation. The X4-4 model still sells at the same list price as the prior X4-2 of $175,000 for the 2Tb model: additional RAM can be added.

Oracle also announced certification of Oracle Database In-Memory for the Oracle Exalytics In-Memory Machine, expanding the scope of in-memory analytics to include the full capabilities of the Oracle Database, as well as continueing support for Times Ten.

Oracle continues to invest in Exalytics In-Memory Software, including several Oracle Essbase in-memory features, such as patented lockless algorithms, Oracle Exalytics-specific thread pool and resource management, and background multiuser write that help to improve dramatically overall Oracle Essbase performance and scalability.

The Exalytics X4-4 is engineered to support the widest range of reporting and analytics capabilities, out of the box, with support for new releases of Oracle Endeca Information Discovery, Oracle Business Intelligence Foundation Suite, Oracle Business Intelligence Applications, Oracle Real-Time Decisions, Oracle TimesTen In-Memory Database and Oracle Hyperion Enterprise Performance Management, speeding time-to-value.

For more information see:

Thursday Oct 23, 2014

Skanska - Oracle BI Cloud Service - Customer Video

Skanska discusses how the Oracle BI Cloud Service (BICS) gives their users self-service capabilities with a secure, reliable platform. Watch the 3-minute video on YouTube @ Skanska Explores Oracle BI Cloud Service.

See here, to find out more about how partners can work with Oracle Business Intelligence Cloud Service.

About



Search

Archives
« July 2015
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
7
8
10
11
12
13
16
17
18
19
21
22
23
24
25
26
27
28
29
30
31
 
       
Today