Integrated Metadata

ASG-Rochade® Management Solution

Business and IT professionals in today’s complex and dynamic business Features

environments demand information accessibility, accountability and
ÙÙImproves application availability
transparency. Their businesses’ success depends on decisions based on this
data. However, for the majority of enterprises, vast amounts of corporate ÙÙAutomates and delivers end-to-
data have accumulated for years, often in redundant pockets of disparate end data lineage with subsequent
transformation rule reports,
information storage containers. impact analysis, and scoping
queries
Locating, understanding, and re-using the data presents a huge challenge—
as does ensuring the data’s reliability. Time and energy is exhausted revisiting ÙÙProvides a centralized storage
past decisions and interpretations of how the data was used and the impact container for all business and
technical metadata enterprise-
of proposed changes is unclear. wide
ASG-Rochade® is a high performance, robust, and flexible database designed to store and maintain
ÙÙReduces risk for non-compliant
enterprise information for any range of implementation that gives customers the ability to deploy
regulatory adherences with
a solution targeted to a specific need, then scale to incorporate global implementations that
governed definitions and data
expand outside of traditional metadata deployments. ASG-Rochade provides support for traditional
lineage
knowledge bases that incorporate data warehousing, data dictionary, portfolio management,
and logical/physical relationship solutions as well as extending and federating to configuration ÙÙAligns business processes, KPI’s,
management, web services, and data governance solutions. and business terms with IT assets

ASG-Rochade’s broad set of tool-agnostic interfaces for information exchange don’t depend on third ÙÙEliminates time and costs
party vendors for upgrade support. The database is extremely portable, open and provides an ODBC associated with redundant pockets
connection as well as federation capabilities. Due to the increasing demand for business metadata of information storage containers
support, ASG-Rochade also includes an easy-to-understand user-interface for non-technical business (spreadsheets, glossaries, Visio
users. flows, databases, etc.)

ÙÙProvides a go-to place for audits

Optimize the Value of Business-critical Data
ÙÙIncreases decision making agility
ASG-Rochade is a powerful metadata management system that supports both business and
by having readily available and
technical metadata throughout the enterprise. It provides a common user interface semantically
current information

ASG-Rochade® provides online capabilities such as “select dataflows” to

highlight the flow of complex lineage and transformations
geared towards the language of your organization and is to verify the lineage and accuracy of their financial statement
supported by an integrated database of information systematically information. Regulatory and compliance constituencies demand
gathered and synchronized from source and target systems that reports and data be understood and used cohesively by
throughout the enterprise. Powerful core features target the various business lines, but inaccuracies can occur when the same
consumption of logical and physical information and relate these data is stored and used differently across the enterprise.
elements to business glossaries, KPI’s, and data privacy rules.
ASG-Rochade establishes the framework to centralize and support this
At the heart of ASG-Rochade is a common Repository Information cohesiveness of data and helps avoid conflicting meanings and usages
Model (RIM). This model is unique in its ability to support any of data across disparate systems by defining information according to
data type and relate anything-to-anything, which is particularly enterprise governed standards and providing a view as to where the
important in metadata management environments where information is sourced and how it is transformed and provisioned.
recursive relationships between objects need to be understood
from a variety of perspectives. This common model is an integral Impact Analysis
force in relating and integrating information consumed from a
As enterprises experience continuous change, ASG-Rochade
variety of tools and systems across diverse vendor platforms.
helps quickly determine the impact of changes as they potentially
ripple through the metadata management environment,
Data Warehouse Management allowing easy maintenance of the environment. When changes
Many organizations struggle with challenges that can are requested, architects can perform impact analysis of the
significantly undermine their investments in enterprise data repository contents to determine the scope of the change
warehouse technology and prevent them from realizing true and then automatically send generated messages to the
value from these deployments. The key challenges include owners or stewards of the potentially impacted objects.
maintaining a high quality of data and the lack of a viable way
to track information end to end which can lead to decreased Technical Specifications
confidence and even disuse of the data warehouse altogether. ASG-Rochade is tool agnostic and works with a variety
ASG-Rochade supports data warehouse management by of databases, languages and other tools.
providing functionality to help understand and manage data and
Metadata Interfaces
interdependencies within the environment of the data warehousing
process. This includes data navigation and reporting tools that • Databases: IMS, DB2, DB2 UDB Oracle, Sybase, SQL Server,
allow users to investigate and present metadata structures and Teradata, Informix, Netezza
interdependencies, trace data lineage, and perform impact
analysis—and to do this in a structured and transparent manner. • Languages: WSDL*, Java, XML, Cobol, PL/I, Assembler, EasyTrieve
MVS/JCL, BS2000/JCL, Focus*
Data Governance • BI Tools: Cognos, Business Objects/Crystal Reports, WebFocus,
ASG-Rochade supports the rationalization and standardization of Microsoft SSAS/SSRS
corporate data assets. The rationalization of the contextual nature
• ETL Tools: Informatica PowerCenter, DataStage, Oracle Data
of data elements is native to the Rochade repository environment, Integrator*,Oracle Warehouse Builder, ODI/Sunopsis, PL/SQL,
illuminating how data is used independent of the many storage Teradata BTEQ, ETI, Microsoft SSIS, SAS, Business Objects Data
containers like applications, ETL, models, and BI reports. This Integrator*
information is augmented with localized table and column
descriptions that identify the common meaning for that environment. • EA/Modeling Tools: ARIS, BPWIN, Borland CaliberRM*,
Casewise Corporate Modeler , Erwin, ERStudio, Oracle Designer,
As corporate governance programs mature, definitions and rules are PowerDesigner, Metastorm ProVision, IBM/Rational Rose/RDA/
collaboratively defined and managed according to best practices at RSA/RSM/XDE, Systems Engineer, System Architect, Borland
the enterprise level, producing a common go-forward definition. Together ControlCenter, case/4/0- Advantage: Gen

• Less Structured: CSV, XLS

Regulatory Compliance
* Field Developed Interfaces (FDI)
Data validation and traceability is now mandatory under regulations
like Sarbanes-Oxley and Basel II that require public companies

About ASG | [Link] ASG provides software solutions to over 85 percent of the world’s largest companies. Through its comprehensive solution ,
ASG’s Business Service Portfolio™ (BSP), ASG is an established Business Service Management (BSM) provider with a strong heritage in in information management,
applications management, infrastructure and operations management, and service and support technologies. ASG enables clients to reduce costs, improve
business-service delivery, and reduce risks. Founded in 1986, ASG is a privately held company based in Naples, Florida, USA, with more than 90 offices worldwide.

Copyright © 2009 Allen Systems Group, Inc. ASG Worldwide Headquarters | 1333 Third Avenue South, Naples Florida USA 34102
All products mentioned are trademarks or registered trademarks of their respective holders. Telephone 1.239.435.2200 or 1.800.932.5536

ASG-Rochade_DataSheet_20090406en