Thursday Apr 10, 2014

Introducing Mobile App for Oracle EPM

Play this short video ~ 3 minutes ~ to get an Introduction to Mobile for Oracle EPM.

This video gives you a quick introduction to Oracle's EPM Mobile App using sample data. EPM Mobile enables on-the-go approvals and workflow across Hyperion Planning, Hyperion Financial Management, and Hyperion Tax Provision.

To check out the App, you can download EPM Mobile on your phone with these links:

- Android at Google Play: https://play.google.com/store/apps/details?id=oracle.epm.mobile.OracleEPM
- Apple app store: https://itunes.apple.com/us/app/oracle-enterprise-performance/id845082117

After downloading the App, you can view the video, the overview tour and the sample application.

For more information see:

 

  • Oracle.Com Product Page: Oracle EPM Mobile App (link)
  • Oracle EPM Mobile Solution Brief (link)
  • Oracle EPM Mobile Data Sheets for Oracle Hyperion Planning, Oracle Hyperion Financial Management and Oracle Hyperion Tax Provisioning (link)

Monday Feb 03, 2014

Demonstration VM “BigDataLite 2.4.1” Available on OTN

The Demonstration VM “BigDataLite 2.4.1” is now available for download from OTN.  Now, customers and partners can have easy access to many of our big data software products - all configured in an integrated VirtualBox environment.

“BigDataLite” is an Oracle VM VirtualBox that contains many key components of Oracle's big data platform, including:

  • Cloudera Distribution including Apache Hadoop
  • Oracle Database 12c Enterprise Edition
  • Oracle Advanced Analytics and "R"
  • Oracle Data Integrator 12c, Oracle Big Data Connectors
  • Oracle NoSQL Database, and more....

It's been configured to run on at least two cores and about +5Gb memory (so this means that your computer should have at least 8Gb total memory). With BigDataLite, you can develop your big data applications and then deploy them to any compatible hardware including the Oracle Big Data Appliance.

To expand this demonstration platform to include OBI and Endeca, you then also download these VMs and inter-connect them. For this you will likely need +16Gb of RAM and at least 4 cores to get them all running. This is targeted at “BIG data analytics”, so giving this integrated platform set +32Gb of RAM and more cores will help you to show it in its’ best light.

Thursday Jan 23, 2014

Endeca Information Discovery 3.1 VM Download

The current version 3.1 of Endeca Information Discovery can now be downloaded from OTN as a self-contained VM appliance providing a VM (virtual machine) image containing a full installation of Oracle Endeca Information Discovery, including:

  • Endeca Server
  • Studio
  • Provisioning Service

The primary objective of this image is to demonstrate the Endeca Information Discovery self-service use case, allowing end users to immediately log in, upload an Excel file, and customize the resulting application within minutes.

While this image can also be used in conjunction with Endeca Information Discovery Integrator, note that Integrator does not come installed by default on the image. Connecting to this image via Integrator from an outside source (host machine or 3rd party machine) also requires some modifications to the image's default network configuration. See the "Loading Data via Integrator" section in this README doc for details.

PLEASE NOTE that this appliance is for testing purposes only. As such, it is unsupported, and should not be used in a production environment.

You can also “Test Drive” Endeca 3.1 on our hosted system @ http://slc02oku.oracle.com:7101/eid/web/home/index. Note that this is shared across different public users, and self-provisioning is disabled. Use Logon ID: publicuser@oracle.com / Admin123.

Tuesday Jan 21, 2014

Big Data Analytics is Big News

From our BI partner Forum last week in London focusing on Big Data Analytics, I think the messages coming through from the discussions with partners and clients can be distilled into a few points:

1. Find Value = Organisations are more successful in finding value from potential Big Data Analytics projects when they combine data from “Hadoopable” sources with their traditional Oracle databases: for example merging social sentiment information with existing customer loyalty and product revenue data. Hadoop projects in isolation are struggling to complete the business case.

2. Oracle+Hadoop = Open source Hadoop and “R”-analytics are very complimentary to the Oracle stack, and indeed are greatly strengthened by Oracle’s software distribution and connectivity options – notably with OBI, Endeca, ODI, SQL, and the Oracle Big-data-Connectors for Hadoop.

3. Interconnect = Any Oracle partner can get going with this by downloading the software onto a relatively modest server, where they can interconnect the complete platform, and quickly get to grips with it: see below.

a. You can directly access data from Hadoop to analyse, visualise, and assess its’ value, and join it to Oracle DB data within OBI and Endeca and R.

b. If and as needed, data in Hadoop can be economically selected, processed, and enriched with familiar tools like ODI, and then moved with the Connectors into an Oracle database at very high speed transfer rates, within your data governance model (e.g. see the Oracle's Information Management Masterclass Tutorials).

4. Start Smaller = Of course, an Oracle Big Data Appliance plus the Exalytics and Exadata engineered systems are the ultimate solution for this, but all of the software platform from Oracle runs very well with Hadoop on smaller commodity servers. The choice of scale depends on your client’s needs – this is not a constraint on getting value from the integrated software stack. Projects can start relatively “small”; with one commentator suggesting the median deployment is around 10 Tb, and only very few are in the Petabyte range).

5. Enterprise-grade = For the successful Enterprise-grade projects, the Oracle tooling that connects with Hadoop and R provide the security, speed and reliability needed to de-risk the project and surface the value. These familiar tools (OBI, ODI, SQL, Big-data-Connectors) also minimise the skills gap and cost otherwise needed for extensive Java and MapReduce programming.

6. Hadoop is not Big Data = The key to value is using the right set of tools for the job: this may or may not include Hadoop.

This is a recent customer story where the full architecture is being put to broad use:

CaixaBank deploys new big data infrastructure on Oracle - Enables the Spanish Bank to Develop Better Customer Services, Integrating Data Created Across All Its Channels.

Interconnect the complete platform

Partners can assemble a complete platform from these VMs. These pull together a large set of tools, and so I recommend you put this on a server with 32Gb RAM.  You can also get some hints @ Oracle BI Partners Get to Grips with Big Data Analytics

Find out more @ Oracle's Information Management Masterclass Tutorials

and White-paper @ Information Management and Big Data Reference Architecture

Monday Nov 25, 2013

Try out Latest Version of Oracle Endeca Information Discovery (OEID)

You can get a quick introduction to the new 3.1 version of Endeca Information Discovery (OEID) from these videos which run from 3 to 10 minutes each: and then try out this latest version on our hosted system (details below), where you can test and build your own applications.

New Oracle Endeca Information Discovery (OEID) 3.1 Videos on YouTube

OEID for Voice of the Consumer

Oracle Endeca Information Discovery for Voice of the Consumer provides deeper analytics by combining new insights found in diverse and unstructured data sources.

OEID 3.1 Voice of the Consumer Self-Service Build Demo

Start with an IT-controlled data warehouse, then add social media JSON. Use EID's self-service, in-app data enrichment to derive structured data from Tweet text--which you can then use to mash up the two data sets and figure out how social media comments are causing sales to decline.

OEID 3.1 Workforce End-User Demo

Oracle Endeca Information Discovery for workforce provides deeper analytics by combining new insights found in diverse and unstructured data sources.

OEID for Crime Incidents

Oracle Endeca Information Discovery on crime incident data obtained from the City of Chicago public data download site (https://data.cityofchicago.org/).

OEID 3.1 Warranty Self-Service Demo

Using Endeca Information Discovery 3.1, we turn a spreadsheet on our desktop into a full-featured enterprise discovery application in just a few minutes, then share our findings with the rest of our organization.

For you to try out Endeca 3.1 as a user and self-service dashboard builder, there is a publicly accessible oracle-hosted demonstration URL available with Endeca 3.1, here at:

You can use this URL to directly demo EID 3.1 on your browser. But please be aware that the system and content may be refreshed without notice, and we may change the URL: if we do, I will re-post the new access URL to this blog.

Monday Oct 28, 2013

Demonstration VM BIC2g 2013-10 Partner Edition for Download

UPDATED ! The “BIC2g” demo VM (now version 2013-10) is downloadable from our BIC2g Beehive Online Workspace portal for OPN member partners. Compared to the prior version, Bic2g 2013-04, the new Bic2g 2013-10 has:

  • OBIEE was upgraded from 11.1.1.7.0 to 11.1.1.7.1. with BI Mobile Application Designer (BIMAD) added.
  • TimesTen was upgraded from 11.2.2.3.0 to 11.2.2.5.0
  • ODI Client 11.1.1.7.0 was installed, including a Standalone agent and empty repositories, and the BI Applications 11g ODI Repositories were included (BIAPPS_11g)
  • Informatica and DAC were removed from image
  • There are additional demos for BI-Apps and for Endeca.
  • The compact deployment of EPM is installed and configured, including: Hyperion Foundation, Essbase, Essbase Studio, Essbase Administration Services, Provider Services, Calculation Manager, Planning, Reporting and Analysis, Financial Reporting, Web Analysis, and Workspace.

The access details, for OPN member partners only, to get added to the BIC2G Beehive Online Workspace portal are shown from this page @ BI Solutions Engineering Partner Portal.

This Oracle Business Intelligence Linux VM virtual appliance (“BIC2g”) was developed to support Oracle OBI, BI-Apps and EPM Hyperion sales and Oracle partners in product demonstrations, training activities and POC activities.  If you do not need BI-Apps, then there is a slightly smaller VM OBI Sample-App you can get from OTN: see @ Oracle BI and EPM Demonstration SampleApp V309 on OTN.

Oracle Big Data Software Downloads

Companies have been making business decisions for decades based on transactional data stored in relational databases. Beyond that critical data, is a potential treasure trove of less structured data: weblogs, social media, email, sensors, and photographs that can be mined for useful information.

Oracle offers a broad integrated portfolio of products to help you acquire and organize these diverse data sources and analyze them alongside your existing data to find new insights and capitalize on hidden relationships.  The Big Data Connector software can run on any supported hardware, e.g. the Linux based Sun X4-2 servers you can find on the Oracle Store: this software is not restricted to only the Oracle Big Data Appliance (although on the Big Data Appliance, we do include ODI - restricted to BDA Hadoop sources - for no extra license fee).

Oracle Big Data Connectors Downloads here, includes:

  • Oracle SQL Connector for Hadoop Distributed File System Release 2.1.0

  • Oracle Loader for Hadoop Release 2.1.0

  • Oracle Data Integrator Companion 11g

  • Oracle R Connector for Hadoop v 2.1

Oracle Big Data Documentation

The Oracle Big Data solution offers an integrated portfolio of products to help you organize and analyze your diverse data sources alongside your existing data to find new insights and capitalize on hidden relationships.

Oracle Big Data, Release 2.2.0 - E41604_01 zip (27.4 MB)

Integrated Software and Big Data Connectors User's Guide HTML PDF


Oracle Data Integrator (ODI) Application Adapter for Hadoop

Apache Hadoop is designed to handle and process data that is typically from data sources that are non-relational and data volumes that are beyond what is handled by relational databases. Typical processing in Hadoop includes data validation and transformations that are programmed as MapReduce jobs.

Designing and implementing a MapReduce job usually requires expert programming knowledge. However, when you use Oracle Data Integrator with the Application Adapter for Hadoop, you do not need to write MapReduce jobs. Oracle Data Integrator uses Hive and the Hive Query Language (HiveQL), a SQL-like language for implementing MapReduce jobs. Employing familiar and easy-to-use tools and pre-configured knowledge modules (KMs), the application adapter provides the following capabilities:

  • Loading data into Hadoop from the local file system and HDFS

  • Performing validation and transformation of data within Hadoop

  • Loading processed data from Hadoop to an Oracle database for further processing and generating reports


Oracle Database Loader for Hadoop

Oracle Loader for Hadoop is an efficient and high-performance loader for fast movement of data from a Hadoop cluster into a table in an Oracle database. It pre-partitions the data if necessary and transforms it into a database-ready format. Oracle Loader for Hadoop is a Java MapReduce application that balances the data across reducers to help maximize performance.


Oracle R Connector for Hadoop

Oracle R Connector for Hadoop is a collection of R packages that provide:

  • Interfaces to work with Hive tables, the Apache Hadoop compute infrastructure, the local R environment, and Oracle database tables

  • Predictive analytic techniques, written in R or Java as Hadoop MapReduce jobs, that can be applied to data in HDFS files

  • You install and load this package as you would any other R package. Using simple R functions, you can perform tasks such as:

    • Access and transform HDFS data using a Hive-enabled transparency layer

    • Use the R language for writing mappers and reducers

    • Copy data between R memory, the local file system, HDFS, Hive, and Oracle databases

    • Schedule R programs to execute as Hadoop MapReduce jobs and return the results to any of those locations


Oracle SQL Connector for Hadoop Distributed File System

Using Oracle SQL Connector for HDFS, you can use an Oracle Database to access and analyze data residing in Hadoop in these formats:

  • Data Pump files in HDFS

  • Delimited text files in HDFS

  • Hive tables

For other file formats, such as JSON files, you can stage the input in Hive tables before using Oracle SQL Connector for HDFS. Oracle SQL Connector for HDFS uses external tables to provide Oracle Database with read access to Hive tables, and to delimited text files and Data Pump files in HDFS.


Related Documentation

  • Cloudera's Distribution Including Apache Hadoop Library HTML

  • Oracle R Enterprise HTML

  • Oracle NoSQL Database HTML


Recent Blog Posts



Tuesday Oct 15, 2013

Test Drive the New BI Mobile Application Designer

Build your own new BI Mobile App, and try it on your smart-phone, or tablet, or desk-top, and the apps others have put into the test Apps-library. BIMAD is pretty simple to use to build apps that analyse data from an up-loadable spread-sheet, or directly from the existing (e.g. here the sample) centralised OBI presentation data model: and just to help you along, here is a step-by-step guide to how you can test drive a specific BIMAD example from the hosted server.

Oracle’s BI Mobile Application Designer (BIMAD) allows you to quickly create great looking interactive reports and dashboard-apps to view across multiple mobile and PC devices. There are three ways you as Partners and your customers can try these out:

  1. Connect to the Oracle-hosted OBI-server, and use it now, both to build and to run these

    BI Mobile Apps. Use your PC-browser to navigate to http://slc02okx.oracle.com:7780/analytics to build the app, and then either scan the QR code it generates into your mobile device to run it, or put the app into the library on the BI-Server, and access them all @ http://slc02okx.oracle.com:7780/mobile/appstore


  2. Get the latest OBI EE sample install including BIMAD within a downloadable VM, and run the entire environment on your own laptop or server. See this @ Oracle BI and EPM Demonstration SampleApp V309 on OTN.


  3. Download the BIMAD install as an add-on to your existing 11.1.1.7.1 OBI installation.

Thursday Oct 10, 2013

Oracle BI and EPM Demonstration SampleApp V309 on OTN

The latest new version “SampleApp” V309R2 BI and EPM VM is now available for download by partners from OTN here. This includes a wealth of examples and how-to demonstrations, as well as examples for the new BI Mobile Application Designer, 19 “Apps” and more local data-models.

This server image is based on the standard OBIEE 11.1.1.7.1 install within a VirtualBox image, including the new Mobile App Designer and Oracle Database 12c; and will run on a 64 bit pc/laptop with => 8Gb Ram, and ~ 90 Gb disk. There is also an optional download for users who require a full standalone EPM deployment.

See also the Oracle BI Tech Demos YouTube Channel & Video: How to download all image files at once and:-

File

Description

Download Deployment Guide

Step-by-step instructions for download and deployment

Download User Guide

User Guide for SampleApp and related contents

Download What's New in V309R2

New content highlights in SampleAppV309 R2

The SampleApp V309 R2 image includes following preconfigured and integrated software:

  • Oracle Linux 5.9 (el5PAE )
  • OBIEE 11.1.1.7.1 (including Mobile App Designer, OBIEE-EPM Suite)
  • Oracle Loader for Hadoop 2.2.0, Oracle SQL Connector for HDFS 2.2.0
  • Essbase 11.1.2.3
  • Oracle Database 12c
  • Oracle TimesTen 11.2.2.5.1
  • Endeca Server 7.5.1, Endeca Studio 3.0, Endeca Integrator 3.0
  • Oracle Application Express 4.2, APEX Listener 2.0.1
  • R-2.15.1, Oracle R-Enterprise 1.3
  • Java SE Development Kit 7u17, JROCKIT 1.6.0.37
  • Oracle SQL Developer 3.2.20
  • EPM 11.1.2.2 Standalone (Offered as a separate add-on download)

 The SampleApp does not include BI-Apps: for these see the Demonstration VM BIC2g Partner Edition.

Friday Aug 02, 2013

Demonstration VM BIC2g 2013-04 Partner Edition

UPDATED !  The “BIC2g” demo VM (version 2013-04) is now available through our BIC2g Beehive Online Workspace portal for OPN member partners.

This updates the June 2013 article "New Version Demonstration VM BIC2g 2013-04 Partner Edition".

The access details are shown from this page @ BI Solutions Engineering Partner Portal.

About



Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
5
6
7
8
9
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today