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.

Oracle Endeca Information Discovery Learning Library

Back in May 2014 I introduced you to how to Get Started and Learn More about Endeca Information Discovery 3.1. We have created a learning library page dedicated to Endeca Information Discovery training assets on the Oracle Learning Library @: A portal of training offerings for Endeca v3.1.

We have continued to add to this, as more content is developed, and some more titles you may like to learn about include:

Title

Release Date

Duration

Configuring Studio to Use a Production Quality Database

This helps you to store Endeca Studio metadata such as configurations, user permissions and system settings in a “production database”, such as my.sql or an Oracle db.

17-Jun-14

20 mins

Choosing Text Enrichment Options in Integrator ETL

24-Apr-14

5 mins

Displaying and refining by date/time subsets in Studio

10-Apr-14

6 mins

Creating a Studio chart using data from multiple views

27-Feb-14

9 mins

Introduction to 'Create your own Discovery Application using Endeca Information Discovery' course

28-Feb-14

3 mins

About



Search

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