QUESTION: What does Noetix mean by upgrade protection?
ANSWER: Both NoetixViews and Noetix Analytics provide a level of insulation from database structural changes inherent with Oracle EBS upgrades. Because of that insulation, reports, queries, and ETL maps that are based on NoetixViews and Noetix Analytics are protected – they’ll continue to work even after you’ve gone through that application upgrade.
How does that work? It’s a little bit different for NoetixViews and Noetix Analytics, so let’s look at each separately.
In NoetixViews, each view joins together a collection of EBS tables. Users build reports and queries using those views. If Oracle changes the database schema, moving the data to new EBS tables, Noetix provides views that join together the new EBS tables, so those reports and queries continue to work. For example, in Release 12, Oracle moved information about Suppliers, Supplier Sites, and Contacts out of Purchasing tables into tables used by Trading Community Architecture (TCA). Consequently, several Noetix views, spanning Purchasing, Assets, and HR, were enhanced to work with the new version of Oracle, using these new tables so that the database schema changes were invisible to users who had built reports on Noetix views.
In Noetix Analytics, upgrade protection is provided in two forms. The ETL architecture maps that extract data from the EBS database use a layer of database views to access that data. These views shield the ETL maps from changes in the database tables introduced by new EBS releases. The extraction views can also be modified to include additional columns from Oracle EBS base tables via metadata. These customizations are also protected during upgrades. If you modify the Noetix ETL maps (or write your own), you can use that same layer of database views. When you upgrade to a new version of EBS, Noetix Analytics provides a version of those database views to match the new EBS database schema. The views will “look the same” to the ETL maps, so those ETL maps will continue to work.
The second form of upgrade protection with Noetix Analytics involves the data models of the Noetix Analytics data warehouse. Noetix commits that those data models – both for the Operational Data Store and the star schema Data Marts – will remain consistent across upgrades. Noetix may add facts, dimensions, attributes, and relationship sets to the model, but won’t change the ones that are already there. As a result, reports, queries, and dashboards that you build with Noetix Analytics will continue to work after you upgrade.
Why does all of this matter? Noetix makes your EBS upgrade easier, because it protects your Oracle reporting environment. You save time, you save money, and you reduce the risk of errors.
Submit a question to Noetix and check back for the answer in an upcoming blog post!