Thursday Nov 20, 2014

Partners’ Get-Started-Kit with Oracle Big Data and Analytics

If you are struggling with how (and why) to get started with “Big Data” and Hadoop based tools with Oracle and your Analytics practice, then see below for some resources and I will post some additional topics and hints on this theme in the next month. Especially start by trying the ETL tools (ODI & GoldenGate) on Hadoop as a lower cost ETL and staging platform for any data warehouse, and try out the new Oracle Big Data Discovery, Now Available - The Visual Face of Hadoop.

Hands-on Labs - Big Data and Analytics

There are several hands-on-labs available to help you get started with the platform which you can practice by downloading the pre-configured VM (Oracle Big Data Lite Virtual Machine):

Oracle Big Data Learning Library

Numerous hands on labs and videos for capabilities that span the Oracle Big Data platform.

Analyze All Your Data with Oracle Big Data SQL

Learn how to securely analyze all your data - across both Hadoop and Oracle Database 12c - using Oracle Big Data SQL

Access Data in Oracle NoSQL Database from Oracle Database

Access data in Oracle NoSQL Database from Oracle Database 12c using external tables.

Tame Big Data with Oracle Data Integration

Learn about how to design Hadoop data integration using Oracle Data Integrator and Oracle GoldenGate.

Integrate Hadoop Data with Oracle Database using Oracle Big Data Connectors

Use Oracle Loader for Hadoop to efficiently load data into the Oracle Database using MapReduce jobs. Access data in HDFS directly from the Oracle Database using Oracle SQL Connector for Hadoop.

Using SQL Pattern Matching

This series features both OBEs and recorded webcasts. Learn how to use SQL for Pattern Matching. Row pattern matching in native SQL improves application and development productivity and query efficiency for row-sequence analysis.

Oracle Data Mining 12c Tutorial Series

The OBE's in this series provide you with instructions on how to perform data mining with Oracle Database 12c, by using Oracle Data Miner 4.0. Oracle Data Miner 4.0 is included as an extension of Oracle SQL Developer, version 4.0.

Oracle R Enterprise v 1.4 - Tutorial Series

Oracle R Enterprise (ORE), a component of the Oracle Advanced Analytics Option, makes the open source R statistical programming language and environment ready for the enterprise and big data.

Introduction to Oracle NoSQL Database

Use Oracle NoSQL Database in the context of the Oracle MoviePlex application. Create schemas, load data and then utilize that data in the online movie application.

Oracle NoSQL Database - Installation/cluster topology deployment (pdf | scripts)

Learn how simple and intuitive it is to deploy a highly available (production ready) Oracle NoSQL Database cluster.

Data Manipulation with Hive and Pig (pdf  | script)

A Quick introduction to HDFS, Pig and Hive.

Oracle Big Data Lite Virtual Machine: Free Download (for testing, demo and educational purposes only)

This (version 4.0.1) provides an integrated environment to help you get started with Big Data. Many Oracle Big Data platform components have been installed and configured - allowing you to begin using the system right away, including:

  • Oracle Database 12c Release 1 Enterprise Edition (12.1.0.2)
  • Oracle Big Data SQL-enabled external tables
  • Cloudera Distribution including Apache Hadoop (CDH5.1.2)
  • Oracle Big Data Connectors 4.0
  • Oracle NoSQL Database Enterprise Edition 12cR1 (3.0.14)
  • Oracle JDeveloper 12c (12.1.3)
  • Oracle SQL Developer and Data Modeler 4.0.3
  • Oracle Data Integrator 12c R1 (12.1.3)
  • Oracle GoldenGate 12c
  • Oracle R Distribution 3.1.1

Tuesday Aug 05, 2014

OBI Foundation Demonstration Systems for Partners

If you need to get access to a demonstration environment, hosted by Oracle, then the current version of OBI Foundation is available for partners to book and use to show to your clients. This demonstration covers all the modules in the OBIEE Sample Application v406 which provides a comprehensive out-of-the-box collection of examples and integrations designed to demonstrate Oracle BI capabilities, product integrations, and design best practice. 

Highlights of SampleApp v406 include:

  • Showcases mapviewer HTML 5 Integration examples
  • Showcases latest Mobile Application Designer (MAD) v2
  • Internet Accessible – VPN is NOT required to demonstrate SampleApp functionality (although VPN is required for the native Mobile HD client).
  • Showcases ADF visualization & dense visualization examples
  • Essbase integration
  • Advanced Analytics (R and Data mining) integration
  • Endeca Information Discovery 3.1 with integration to OBI11g

OPN Member Partners can Learn more and Apply for Access to GSE, and once approved can access the link to book and run demos @ Access Demonstration Systems. These Oracle Demonstration Services are run by the Oracle Global Sales Engineering team (“GSE”). GSE provides a platform to demo Oracle products in an enterprise setting in the way Oracle is meant to be used. We provide demos that are easily accessible and fast performing, consistent with product strategy and sales needs. 

Tuesday Jul 15, 2014

Try It Live Oracle BI Demonstration SampleApp V406

Further to the previous Blog post Oracle BI Demonstration with BIMAD2 SampleApp V406 on OTN which provides information for downloading the Sample App, you can now access this software hosted on an Oracle server via the "TRY IT LIVE" option.

This is a great resource if you just need quick and easy access across the internet to OBI11g and all the great examples in the SampleApp.

To access the OBIEE Sample App V406, visit Oracle Technology Network (OTN) @ OBIEE Samples and select the "Try It Live" icon.... then enter the User ID and Password as detailed on the OBI log-In screen. Note that the SampleApp contents, its code and the Try It Live are distributed free for demonstration purposes only: it is neither maintained nor supported by Oracle as a licensed product or service.

Tuesday Jul 01, 2014

ODI12c ETL on Hadoop and Oracle Big Data Appliance

One of the best reasons to start using Hadoop, is to off-load ETL processing away from a potentially higher cost “Data Warehouse staging system” and deploy it onto a platform with a better performance-to-cost ratio for this ETL load.

If you do this, you will likely still want high productivity ETL tools such as Oracle Data Integrator (ODI12c), and if you are handling large volumes of data in a limited batch window, you need fast processing and most importantly high speed loading into the Data Warehouse.

ODI12c on Hadoop gives you this, when combined with the Oracle Big Data Connectors. This works especially well on our engineered systems (Big Data Appliance to Exadata), but is still also the best solution for any ETL work from Hadoop to an Oracle database, even on so called “commodity hardware”.

Mark installed all the software elements directly, but if you need to get going quickly, you may be able to use our downloadable VM ( Demonstration VM “BigDataLite 2.4.1” Available on OTN ... although this is now updated to version 3.0) which works on non-BDA hardware.

Friday Jun 20, 2014

Oracle BI Demonstration with BIMAD2 SampleApp V406 on OTN

The latest new version “SampleApp” V406 BI 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 V2.

This server image is based on the standard OBIEE 11.1.1.7.1 install within a VirtualBox image 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 and BI-Apps deployment.

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

· Oracle Enterprise Linux 6.5 x64

· Oracle Business Intelligence EE 11.1.1.7.1401527

· Mobile Application Designer V2

· Essbase Server 11.1.2.3, Essbase Studio,FR

· Sample Application Content

· Oracle Endeca Information Discovery 3.1

· Endeca Server 7.6.1,Studio 3.1

· Oracle MapViewer Version 11g ps6 (11.1.1.7.2)

· Oracle Database 12c 12.1.0.1.0

· R 3.0 & ORE 1.4

· Oracle APEX 4.2.0.0.27, Listener 2.0.1

· SQL Developer 4.0.2

· TimesTen 11.2.2.6

· Standalone EPM 11.1.2.3 Suite (plug and play add-on)

· BIApps 11g (plug and play add-on)

Friday Apr 25, 2014

Hyperion Demonstration Systems for Partners

If you need to get access to a demonstration environment, hosted by Oracle, then the current version of the Hyperion EPM Applications v11.1.2.3 are available for partners to book and use to show to their clients. This demonstration covers all the modules including HFM, Planning and Tax provisioning: and there is a demo image which is the same as the PBCS Planning in the Cloud version.

These Oracle Demonstration Services are run by the Oracle Global Sales Engineering team (“GSE”).

OPN Member Partners can Learn more and Apply for Access to GSE, and once approved can access the link to book and run demos @ Access Demonstration Systems.

GSE provides a platform to demo Oracle products in an enterprise setting in the way Oracle is meant to be used. We provide demos that are easily accessible and fast performing, consistent with product strategy and sales needs.  See specifically the notes for PBCS @ How to Access and Use Planning & Budgeting Cloud Services Environments.

Tuesday Apr 22, 2014

UPDATED Demonstration VM for BI Partners (BIC2g 2014-03 Download)

Most of this Demo VM is now very similar to the OTN SampleApp V309, but BIC2g has BI-Apps (with ODI) with all the extra Vision-demo data, plus it has Endeca v3.1 (the SampleApp is still v3.0 Endeca), and it includes the standard Test-Drive kits.

Compared to the prior version, the new BIC2g 2014-03 has:

Ø Updates to the Executive Vision Demo (EVD).

Ø Merged SampleApp content with both EVD and BI Apps 11g rpd/webcats.

Ø Test-drive customer workshops:

o BI Apps

o BI Foundation

o Endeca Information Discovery 3.1

Ø Updates to BI Apps 11g Demos

o New OM and Projects Mobile demo scripts

o New 11g DW for future demo script development

Ø Updated demo process control features

The OBIEE installed is 11.1.1.7.1. with BI Mobile Application Designer (BIMAD) added.

The “BIC2g” demo VM is downloadable from our BIC2G Beehive Online Workspace portal for OPN member partners.

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 Essbase sales and Oracle partners in product demonstrations, training activities and POC activities.  If you do not need BI-Apps, or everything combined, then there is a smaller VM OBI Sample-App you can get from OTN: see @ Oracle BI and EPM Demonstration SampleApp V309 on OTN.

  • Join this live WEBCAST to learn more about the BIC2G 2014-03 Partner Edition – on Thursday, May 22nd, 2014 at 5.0 pm UK / 6.0 pm CET @ WebConference URL    ( Meeting Number: 597 781 081 / Passcode: Oracle123 ).

For Endeca 3.1 only, you can also get this @ Endeca Information Discovery 3.1 VM Download

While for a “Big Data” demo setup including Hadoop, see @ Demonstration VM “BigDataLite 2.4.1” Available on OTN

If you are new to them, the Test-drive customer workshops use a ‘seeing is believing’ approach with real world data that everyone can related to, and provide an opportunity for partners to invite their customers to interact with the solutions and with you, the BI experts. See here for more on Test Drives.


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://slc02okj.oracle.com:8001/eid/web. Note that this is shared across different public users, and self-provisioning is disabled. Use Logon ID:  prodney@oracle.com / Admin123.

Tuesday Jan 21, 2014

Planning and Budgeting Cloud Service Demos

For Finance executives who are drowning in spreadsheets or strapped to legacy applications, a cloud-based performance management solution offers an easy on-ramp, lower IT resource requirements and accelerated time to value.

You can now see this set of Enterprise Planning Demos and Videos on cloud.oracle.com

On 30 January 2014, at 14:00 h GMT/ 15:00 h CET we will also be starting a series of webcasts on “Profitable Growth with Oracle Planning and Budgeting Cloud Service – for this you can Register Now.

Otherwise, right now you can see the Planning and Budgeting Cloud Service - Partner Webcast Replay.

For more information see on Oracle.com @

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://slc02ojr.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://slc02ojr.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.

About



Search

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