This research (sponsored by Noetix, BTW) shows high value
from pre-configured mapping of transactional sources.
Transactional systems, both enterprise resource planning (ERP) and
customer relationship management (CRM) software, have complex data schemas
that span multiple functional modules and utilize thousands of relational tables.
In addition, the names that commercial vendors use for tables and columns in their
transactional systems often are cryptic and make it difficult to decipher
what data a table contains unless the user is familiar with that particular
Further complicating the mapping process is the fact that each vendor has a
proprietary application programming interface (API) that must be used to access
the security mechanisms and business logic of the transactional system.
The thrust of this article is that Application BI simplifies this onerous process
with preconfigured tools and functionality for transactional systems from vendors
such as Oracle, PeopleSoft, SAP and Siebel.