If you are following along, you can begin with a very simple query. Subject Areas contain references to the included Entities and that would be a good way to structure my report. According to CA, they have the first data modeling tool that integrates. How-to examples using CA ERwin Data Modeler are provided for each of these building blocks, as well as real world scenarios for. Computer Associates (CA) announced late last week the release of its latest effort, called CA Erwin Data Modeler (DM). Section II introduces the basic building blocks of a data model, including entities, relationships, keys, and more. Next, knowing what I already know about the ERwin metadata, I decided the Subject Area was the best point to start. The basic features of CA ERwin Data Modeler are introduced with a simple, easy-to-follow example. I always develop in the context of a small model with a familiar design to minimize issues that may arise from the volume or complexity of the data. ERwin has a decent querying tool built right into it, available from the Tools | Query Tools. So next, I needed a place to experiment with some queries. My other resources were the documentation of the Metadata and the ODBC documentation, both available at.Ĭ:\Program Files\CA\ERwin Data Modeler r8\Doc\ For my resources, I opened a model of the ERwin ODBC schema objects which is available at.Ĭ:\Program Files\CA\ERwin Data Modeler r8\BackupFiles\Samples\ERwin Relational Metamodel.erwin I thought I would bring you in on the process in the hopes it might shed some light on some of your efforts.įirstly, I needed some documentation and I needed a sandbox to play with the ERwin metadata. The Installation Guide is a new guide added for this release, which provides you with all the information necessary for installing and licensing CA ERwin Data Modeler. So I had to build a Crystal Report that included the Subject Areas, Tables, Columns and some Column Properties. CA ERwin Data Modeler Installation Guide for more information about installing CA ERwin Data Modeler. CA ERwin Data Modeler is a program that provides a powerful way to visualize data from multiple sources across the organization, increasing efficiency through reuse and standards, while at the same time increasing data quality and providing a unified view of strategic data assets.
0 kommentar(er)
