Are you planning an upgrade from a previous OBIA release or are you implementing net new and would like to understand what changed from the old release to the new one? This multi-part blog will be addressing the differences between ODI, assist customers that are on OBIA with Informatica (version 7.9.6.x), and finally help those that are upgrading to OBIA with ODI (version 126.96.36.199. x/188.8.131.52.x).
With OBIA 184.108.40.206.1, Oracle has introduced several new features that enhance the capabilities of OBIA significantly. The major change however is the replacement of Informatica as ETL tool by Oracle Data Integrator (ODI). In this two-part blog I will provide a quick glance to all the new features and changes in the latest release, along with some specifics around ODI. Keep in mind that at the time of writing this blog, Oracle has not released any migration utility for migrating OBIA 7.9.6.x to OBIA 220.127.116.11.x. Primary reason for this is the ETL platform change. I don’t believe Oracle will release any migration utility for converting Informatica ETLs to ODI, as they are based on very different technology (ETL vs, ELT).
So if you are thinking of upgrading your current OBIA environment from 7.9.6 to 11.1.1.x, plan for a net new install for 11.1.1.x version.
ODI vs. Informatica:
Although changing the ETL platform for OBIA means re doing every customization done in previous version, I think this work is worth the effort. There are several advantages of using ODI over Informatica with OBIA:
- BI Applications are completely re-architected leveraging Oracle Data Integrator, Oracle Golden Gate and new setup and configuration utilities, the applications can be implemented faster, with reduced costs and improved real-time reporting.
- Oracle Data Integrator (ODI) delivers unique next-generation, Extract Load and Transform (ELT) technology that improves performance and reduces data integration costs—even across heterogeneous systems, and improves productivity.
Benefits of leveraging ODI architecture:
- ELT Transformation vs. ETL - leverages the efficiency of the Oracle database engine rather than Informatica’s ETL hub that can be a performance bottleneck
- ODI is considered as best in class for Performance, Scalability, Availability
- Lightweight Deployment for Lowering Total Cost of Ownership (TCO)
- Faster time-to-value through Declarative Design
- Heterogeneous, Open and Standards-based
- ODI includes BIACM, a web based tool built around Oracle Fusion Middleware, replacing Informatica DAC thin client for ETL orchestration.
A new optional pre-packaged solution that leverages GoldenGate eliminates the need for an ETL batch window and minimizes the impact on OLTP systems, while providing near real-time reporting and enabling more reliable change data capture and delete support. This in my opinion is one of the biggest improvements in new OBIA release. Now you can have real-time reporting done via OBIA as well. In fact we have recently implemented Golden Gate with OBIA at a client, enabling them to mesh real time data with historical data for better trend analysis and real-time analysis with virtually no delay in data refresh.
If implemented correctly, the current stack of Oracle BI technology is a true enterprise reporting solution offering:
- Functional Setup Manager (in BIACM) provides a Web based Administrative User Interface to track and manage implementation projects and their required functional setup steps
- Configuration Manager (in BIACM) provides a centralized Web based administrative user interface to simplify the setup and maintenance of Oracle Business Intelligence Applications
- ODI integrates with Oracle’s data quality, change data capture and SOA messaging technologies
- Visualization Enhancements and User Interaction Improvements
With ODI, now Oracle has released new Data Lineage Tool (Subject Area) which allows customers and implementers to track lineage from source to target - improving information transparency across their enterprise.
Fact Partitioning IKMs:
Fact Partitioning IKMs and Parallel Index Builds are key performance Innovations introduced with this OBIA 18.104.22.168.1 release:
- Fact Partitioning IKMs enables a feature that tags partitions so that only the indexes that need to be re-built during incremental loads are executed
- Parallel Index Builds uses ODI parallel process so that Indexes can be built using multiple session (faster than and in addition to DB parallel)
These are just a few highlights of OBI features with ODI. Keep in mind there are several new features, like memory analytics and BI Mobile HD, which I will address in my next installment.
Reach out to us if you have any concerns about your planned upgrade.