Posts

Are data professionals enabling agility for the business?

Every few years, a word or phrase becomes so commonly used in the language of business that it loses its effect. I remember when “strategic” meant something very specific about competitive advantage. “Quality” and “customer-centric” were rally points for corporate culture. “Innovation” (after a round of “ideation” of course) would almost guarantee a slice of the investment pie. Even “differentiation” meant significant separation from the pack. Read more

What is the Value of Building a Data Warehouse?

QUESTION: What is the value of building a data warehouse?

ANSWER: This is a common question, especially for customers who have used NoetixViews (sometimes for many years) to meet their reporting needs. Although real-time operational reporting is important and valuable, there are several benefits provided by a data warehouse: Read more

ETL for Data Warehousing is the new COBOL

I remember when I started my career in tech, many of my customers were moving away from mainframes to distributed computing for those applications that required more human involvement. As a percentage, traditional mainframe programs shrunk and the skills necessary to maintain them became scarce. I vividly recall a conversation with my customer at the time, Citibank, who shared their concern about updating a particularly important COBOL program because “the guy who wrote it is dead and the guy maintaining it is holding a gun to our head”. Read more

Building Data Cathedrals

On a recent trip to Barcelona, I did an exceedingly rare thing for a business trip: I went sight-seeing. The top of my list was Sagrada Familia, a gigantic modern cathedral designed by eccentric Spanish architect Antoni Gaudí. After standing in line for nearly an hour to get in, I was fully prepared to be underwhelmed: these touristy “must-sees” have a way of disappointing me. But that time it was different. I was blown away. Read more

What does Noetix mean by upgrade protection?

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!

 

Organizational Structure Underpins Data Governance

Several years ago, I spent a wonderful week in São Paulo to help a customer answer a simple question: three data warehouses, or one? Read more

Summing up Kalido announcements at Teradata PARTNERS 2010

Kalido made a number of announcements at the Teradata PARTNERS 2010 Conference this week. I’ve talked to several attendees in our booth and in private meetings with industry analysts, and the response has been great! Read more

How to Keep the Enterprise Data Warehouse Relevant

Last week, a data architect from a large pharma asked me: “Should we build an enterprise data warehouse given that we want to harmonize business processes globally?” My first reaction was: it’s been a while since I heard anyone wanting to build a true EDW. Read more

Announcing The Cascaded Data Warehouse

Today we made an announcement about a very cool new capability in the Kalido Information Engine that we call a “cascaded data warehouse.” This new capability delivers a no compromise approach to getting BOTH fast data loads AND fast query response to users. The result is greater flexibility, faster speed and much stronger performance for customers. Read more

Make your data warehouse built to last

When you hear something is built to last, what do you think? You might think of it as sturdy, solid and holds up to wear and tear. Those are great attributes for a building or a truck. But are those the attributes you want to think about when you want a data warehouse that is built to last? Read more