Analyzing a data model

Use the Analyze Model wizard to analyze a data model to ensure that it meets certain specifications. Model analysis helps to ensure model integrity and helps to improve model quality by providing design suggestions and best practices.

You can use the Analyze Model wizard to analyze data models. You can analyze the following types of data models:

From the Data Project Explorer:
  • A package in a logical data model
  • A database or schema in a physical data model
From the Database Explorer:
  • A database or schema in a database connection

To analyze a data model:

  1. Right-click one of the supported data objects, and click Analyze Model from the pop-up menu. The Analyze Model wizard opens.
  2. Complete the steps of the wizard. On the first page of the wizard, you select the rules that you want to use during the analysis. If you select naming standard rules, you can specify glossary models on the next page of the wizard.
  3. Click Finish.
The model is analyzed, and errors and warnings are displayed in the Problems view.

Feedback