Understanding the Microsoft CRM Database

Microsoft CRM data is stored in a Microsoft SQL Server database named <organization>_MSCRM on the SQL server in your Microsoft CRM installation. A second database named <organization>_METABASE contains metadata that is used by Microsoft CRM in conjunction with the main database.

Reports access Microsoft CRM data through numerous SQL "filtered views" that ship with Microsoft CRM. These views filter data based on the user's Microsoft CRM security role. The next sections describe using filtered views and how you can access the data in the Microsoft CRM database for your reports.

In This Topic

Object Schemas

Filtered Views

Naming Conventions

Related Topics

Microsoft CRM Entity Model

© 2007 Microsoft Corporation. All rights reserved.