Tag Archives: Oracle Data Integrator (ODI)

Oracle Essbase On-Premise versus Oracle Essbase Cloud Service

October 4, 2017

Author: Andrew Tauro, Performance Architects By now you have most likely seen a lot of material (including posts on our blog ) regarding how Essbase has moved to the cloud as Essbase Cloud Service (ESSCS) , which is part of the new Oracle Analytics Cloud (OAC). You may still be wondering how the feature sets between the two versions of Essbase…   Read More


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

How to Implement Slowly Changing Dimensions (SCD) Type 2 in Oracle Data Integrator (ODI) 12c

March 2, 2017

Author: Margaret Motsi, Performance Architects Tracking historical changes in data (slowly changing dimensions) is a very common Oracle Data Integrator (ODI) task since many industries require the ability to monitor changes and to be able to report on historical data accurately at a point in time. Implementing slowly changing dimensions (SCD) in ODI 12c is relatively easier than in…   Read More


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Evolving Data Integration with Oracle Planning and Budgeting Cloud Service (PBCS)

October 26, 2016

Author: Rich Pallotta, Performance Architects Oracle’s Planning and Budgeting Cloud Service (PBCS) is a significant advancement in the Oracle EPM (Hyperion) product suite’s steady evolution and, like biological evolution itself, it seems we’re in one of those “fits-and-starts” phases. In the big picture, PBCS is doing great, but now that we’ve made that leap to the cloud, you may have noticed the…   Read More


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Data Integration in Oracle Planning and Budgeting Cloud Service (PBCS)

January 14, 2016

Author: Tom Blakeley, Performance Architects In the past year, we have all watched the explosive growth in cloud offerings from Oracle – starting with Planning and Budgeting Cloud Service (PBCS) and most recently with the release of Enterprise Performance Reporting Cloud Service (EPRC). These are attractive offerings for organizations looking to reduce infrastructure costs, simplify the technology stack, and provide users with robust performance management tools….   Read More


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Oracle Data Integrator (ODI) Load Parameters for Oracle Business Intelligence Applications (OBIA)

May 22, 2015

Oracle Business Intelligence Applications (OBIA) use substitution variables which control the way data is loaded.  These variables must always be configured during an implementation of BI Applications.  The most important of these are the extract dates – which control the timeframe of data to be loaded into the system. During the initial phases of a BI Apps project you would…   Read More


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Demystifying Oracle’s Data Integration Offerings: DRM, EPMA, FDMEE, GoldenGate, & ODI

August 27, 2014

With all of the current data integration offerings available from Oracle, it’s important to understand the strengths of each, what they accomplish, and how they might fit into your existing technology landscape. Read on to learn a few facts about each of these tools. Data Relationship Management (DRM) is Oracle’s “enterprise-wide” analytic master data management utility used to maintain…   Read More


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.

Outcomes from Oracle Developer Tools User Group (ODTUG) Kscope14: Put All Your Eggs in the Oracle Hyperion FDMEE Basket!

July 2, 2014

As an Oracle EPM (Hyperion) implementer, one of the biggest highlights for me at Oracle Developer Tools User Group (ODTUG)’s annual Kscope14 conference is the EPM Sunday Symposium , where product experts from Oracle provide roadmap information on future releases. Mobile technology and cloud computing owned the day at this year’s Symposium…however, Oracle’s product management team revealed another item that stole the show (well, at least for me)….   Read More


© Performance Architects, Inc. and Performance Architects Blog, 2006 - present. Unauthorized use and/or duplication of this material without express and written permission from this blog's author and/or owner is strictly prohibited. Excerpts and links may be used, provided that full and clear credit is given to Performance Architects, Inc. and Performance Architects Blog with appropriate and specific direction to the original content.