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.

Tuesday Dec 31, 2013

New Version Oracle Data Integrator and GoldenGate 12c

Oracle recently announced Major Updates to its Data Integration Portfolio. Oracle Data Integrator 12c and Oracle GoldenGate 12c were both released, plus the availability of the Oracle Warehouse Builder to Oracle Data Integrator Migration Utility, all tightly integrated with Oracle Database 12c and Oracle Applications.

See here this interview with Mark Rittman commenting on these updates in a video: Rittman Mead Evaluates Oracle Data Integrator 12c

We are also delighted to invite EMEA OPN partners to the first Oracle Data Integration (“DIS”) EMEA Partner Community Forum on 11th - 12th February 2014 in Prague, Czech Republic.

Oracle DIS is easy to position, learn and implement. Existing and new partners have experienced quick returns very soon after investing into our products and solutions. Within DIS projects, there is traditionally a high ratio of services revenue vs. license revenue.

REGISTER here NOW

· Hear about the latest news on Oracle DIS v 12c and benefit from gaining insight into Oracle’s business and technology strategy.

· Meet and interact with the Oracle EMEA DIS field operations and corporate product management executives and explore more on a strategic partnership for joint go-to-market. This event also provides dedicated time for one-to-one meetings.

Thursday Oct 13, 2011

OBI-Applications data sources, ETL Data Lineage and KPI variables

Occasionally I am asked about where to find better documentation for the BI-Apps data sources.  If you need this, then this is available via the Metalink note (ID 1274680.1), that provides a link to an Excel spreadsheet documenting the data “lineage” of the information found in the BI Apps data warehouse: it is almost 8 MB, in a zip file online link.

Also you may be interested in the Metalink note (ID 846917.1) that contains a link to the Business Analytics Metric Reference Guide.  This contains information on the KPIs and on how certain variables are calculated. 

Hope this helps you in your BI-Apps engagements.

Short-cuts to the download links, so you don’t have to read the entire Metalink notes:

BI_Apps_7.9.6.2_7.9.6.3_DL.zip (7,991.54 KB)

Metrics Reference guide for 796 (7,754.88 KB)

Oracle Business Intelligence Applications ETL Data Lineage Guide Release 7.9.6.2 and 7.9.6.3 [Article ID 1274680.1]

Oracle Business Intelligence Applications Metrics Reference Guide Release 7.9.6,7.9.6.1 [ID 846917.1]

Oracle Business Intelligence Applications Content Guide Release 7.9.6.2 [ID 1264878.1]

Oracle Business Analytics Warehouse Data Model Reference Version 7.9.6, 7.9.6.1 and 7.9.6.2 [ID 819373.1]

About



Search

Archives
« May 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