1 / 26

CA’s Advantage Repository

A Presentation to Metadata Special Interest Group 9 April 2003. CA’s Advantage Repository . Ronald Allard, Sr. Consultant Technology Services. Overview. Repository Products. There are 2 Repository Products: Advantage Repository DS (CAARDS) Client/Server Based

Leo
Download Presentation

CA’s Advantage Repository

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. A Presentation to Metadata Special Interest Group 9 April 2003 CA’s Advantage Repository Ronald Allard, Sr. Consultant Technology Services

  2. Overview

  3. Repository Products • There are 2 Repository Products: • Advantage Repository DS (CAARDS) • Client/Server Based • Integrated with Advantage Transformer Suite • Data Shopper for Web -> Active Server Pages • Advantage Repository z/OS and os/390 (AR/ZOS) • Mainframe Based • Integration with Endevor • Data Shopper for Web -> JAVA

  4. Repository for Distributed Systems Architecture

  5. Repository for Distributed Systems Interfaces(aka: Metadata Exchanges) Languages/Development Tools Modeling Interfaces User Clients • COOL:DBA • ERwin • Oracle Designer • Component Modeler • Oracle • PowerBuilder • Visual BASIC • Visual C/C++ • Win 95 • Win NT • Win 98 • Win 2000 • ActiveX • C/C++ • COBOL • Java • JCL ERP Systems Data Warehouse AdvantageRepository For Distributed Systems • PeopleSoft • SAP R/3 • Data Transformer Report Writers/Other DBMS Support • Document • Flat Files • SQL Scanner Metadata Reporting • DB2 • IDMS • Informix • MS SQL • ODBC • Oracle • Sybase • Standard Reports • CleverPath Reporter • Data Shopper • WEB

  6. Functionality

  7. Repository Key Capabilities • Viewing Metadata • Adding and Updating Metadata • Repository Administration

  8. Capabilities – Viewing Metadata • Repository Client • Read/Write access to metadata • Desktop installation • Customizable for different user groups • Data Shopper for Intranets • Read-only access to metadata • Web based--no desktop installation needed • User-friendly

  9. Capabilities – Adding & Updating Metadata • Population Center • Automated scanning/loading of numerous source systems • Client • Manual updates of information (definitions, notes, etc.)

  10. Capabilities – Administration • Client • Customize interfaces for both Client and Data Shopper • Security Manager • Manage repository users and roles • Extend Tool • Modify the repository model • Reuse Rules • Administer change management

  11. Repository Cases

  12. Source System Restructuring Mappings Target Design Normalize Oracle Calculations DB2 Homogeneous Data Warehouse Reformat Translate Sybase Balance Flat Files Repository Data Warehouse Support Advantage Transformer

  13. Application Development SlsSum TL_SLS nTotalSales SALES_TOT VendTotale = Total Sales!

  14. Reports Warehouse Tables Transformation Rules Table Change JCL Program Informix Element Oracle Sybase IMS DB2 Impact Analysis

  15. Customer Success Stories

  16. Customer Base • Advantage Repository has over 400 user worldwide • The Repository maintains an active and vocal User Group • A recent independent survey of Fortune 1000 companies using a repository found that over 50% were using CA’s Advantage Repository Solution

  17. Success Stories • Read more on the web: • Royal Bank of Canada • Winner of Prestigious Wilshire Award for Best Practices in Metadata Management • CA's Advantage & AllFusion Help RBC Earn Award http://www3.ca.com/press/pressrelease.asp?id=2013

  18. Reference Sites • CA has successful customers in a wide variety of industries and geographical areas including: • Banking: Citibank, Metavante, Standard Chartered Bank, State Street, Svenska Handelsbanken, Wachovia, etc. • Insurance: New York Life, Prudential, Blue Cross Blue Shield, Old Mutual Life Assurance (South Africa) etc. • Government: US. Social Security Admin, US National Security Admin, Florida Dept. of Transportation, Wuhan Public Security Bureau, etc.

  19. Repository Future

  20. CA’s Roadmap and ISO9002 – What We Can Say • Generally available (GA) • Beta • Information gathering or under consideration for inclusion in a future release

  21. Under Consideration for Future Release • Closer Integration with CA’s BI and Modeling Tools • Integration with External Tools • New Exchanges • Informatica • Business Objects • Certify Exchanges on latest versions • Support of Industry Standards • XML DTD and XML Schemas • CWM support • Visualization • Enhanced visualization and editing via Web

  22. Repository Partners

  23. Implementing a RepositoryCosts & ROI

  24. Phased Approach • Our Best Practices say:

  25. Fundamental Principles • Incremental Approach • Tangible Benefits • Fixed Scope • Clear Objectives • Marketing • Methodology vs. Technology • Metadata Planning precedes the implementation • A Repository is an enterprise solution (vs. a point-product)

  26. Questions/Comments?

More Related