Accessing data in Oracle Fusion Applications Cloud for Analytics

The following diagram shows the high-level options to access data within Oracle Fusion Applications (FA) Cloud for Analytical purposes:

Please note: that this diagram is of April 2018 and may not apply in full in future.

For more details on how to connect to Oracle Fusion Applications (FA) Cloud using Visual Analyzer (VA) and DV Desktop (DVD), please reference the previous article.

The details for connecting to FA using ODI (with BI Applications) or BI Data-sync will be described in future articles.

Advertisements

ODI 12c: Upgrade Benchmarks

Please find below some Upgrade Benchmarks for upgrading the (Database) Repository for Oracle ODI 11g to ODI 12c using the ODI Upgrade Assistant which performs all necessary steps to convert the Repository e.g. upgrading the 11g interface to 12c mapping concept, as seen in below step:

image

Below is a table with the benchmarks for the respective Repositories:

Repository Repository Size in MB (measured by XML export size) Time duration
MASTER 150 33 Minuets
WORK REPO 1 250 15 Hours
WORK REPO 2 150 15 Hours

The Oracle support also features a Technote containing some tips to improve the process:

ODI Upgrade Hangs With Upgrade Progress Stucks at x% (Doc ID 1664300.1)