Databases Reference
In-Depth Information
Table 3-2
Sample Technology Inventory Matrix
FINANCIAL
CORPORATE MARKETING
TECHNICAL
SALES DATA
REPORTING
CAMPAIGN
>
COMPONENT
MART
SYSTEM
MANAGEMENT
Data Modeling
Tool
ER-Win
None
None
Data Extract
Tool
Informatica
Informatica
SAS Programs
Transformation
Tool
Informatica
Informatica
SAS Programs
Data Movement
Informatica
Informatica
SAS
Data Cleansing
NA
NA
NA
DBMS
Oracle
Oracle
Essbase
Database Load
Oracle
Informatica
Essbase
End User Data
Access
Business Objects
Cognos
Essbase
Data Dictionary
Internal Data
Dictionary
Internal Data
Dictionary
CRM Data Dictionary
DOCUMENT WHAT YOU LEARN
Going through the exercise of finding and learning about the many reporting
environments across the enterprise is challenging and enlightening; but in
order to leverage what is learned, the findings must be documented! Taking
notes is not enough. Can others find your notes? Can anyone else read your
writing? Taking the time to document what you learn ensures that the details
are available even when you are not. Large, complex organizations have too
many systems to keep track of unless you carefully document each one.
This should not be an effort that takes months— spending an hour or two to
summarize the findings of each system is invaluable. Organize the findings and
publish them for the benefit of the entire organization. You should plan to
document the following:
■
A brief summary of each reporting environment, which includes a short
abstract of the system's purpose and contact information if someone
wants to learn more. This can include the technical findings too.
(continued)
