Reports › Use Reporting Tools with erwin Data Modeler

Use Reporting Tools with erwin Data Modeler

You can use a third-party reporting tool such as Crystal Reports to query the erwin Data Modeler (DM) metadata and build reports on an open model.

This topic and its sub-topics demonstrate the use of Crystal Reports as the reporting tool.

Use this process to create a report:

• Start erwin DM and open the models you want to report on. This ensures that the data source is loaded and available to Crystal Reports when you begin.
• Start Crystal Reports and identify erwin or erwin_Current as the current data source. You can do this when you create a Blank Report or work with the Report wizard. A user name and password are not required to access the erwin data source - you can leave these fields blank and click Finish.

Note: If you see a "Logon failed" message, it is probably because you do not have erwin DM open. When you start erwin DM, it loads the data sources and makes them available to Crystal Reports.

• Build your report from erwin schema objects. For example, work with modeling data using the M0 Schema, metadata using the M1 schema, the EM0 schema, the EM1 schema, or the AL schema.

Note: For more information about the schemas, see the How to Generate or View Reports scenario. The scenario is available in the bookshelf under Product Documentation By Role, Data Architect section. For detailed information about the erwin DM metadata, see the Metamodel Reference Guide.