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
Related Topics