Export (0) Print
Expand All

Databases in BizTalk Server

Microsoft BizTalk Server installs several databases in SQL Server. The table below describes the typical usage characteristics for the BizTalk Server databases.

BizTalk Server runtime operations typically use the first four databases (BizTalk Server Management database, MessageBox databases, Tracking database, and SSO database). Depending on the BizTalk Server functionality that you use, you may have some or all of the other databases in the table.

 

Database Default database name Description

BAM Analysis

BAMAnalysis

This database contains Business Activity Monitoring (BAM) OLAP cubes for both online and offline analysis.

BAM Archive

BAMArchive

This database archives old business activity data. Create a BAM Archive database to minimize the accumulation of business activity data in the BAM Primary Import database.

BAM Notification Services Application database

BAMAlertsApplication

This database contains alert information for BAM notifications. For example, when you create an alert using the BAM portal, entries are inserted in the database specifying the conditions and events to which the alert pertains, as well as other supporting data items for the alert.

BAM Notification Services Instance database

BAMAlertsNSMain

This database contains instance information specifying how the notification services connect to the system that BAM is monitoring.

BAM Primary Import database

BAMPrimaryImport

This is the database where BAM collects raw tracking data.

BAM Star Schema

BAMStarSchema

This database contains the staging table, and the measure and dimension tables.

BizTalk Management database

BizTalkMgmtDb

This database is the central meta-information store for all instances of BizTalk Server.

BizTalk MessageBox database

BizTalkMsgBoxDb

This database is used by the BizTalk Server engine for routing, queuing, instance management, and a variety of other tasks.

BizTalk Tracking database

BizTalkDTADb

This database stores health monitoring data tracked by the BizTalk Server tracking engine.

Rule Engine database

BizTalkRuleEngineDb

This database is a repository for:

  • Policies, which are sets of related rules.

  • Vocabularies, which are collections of user-friendly, domain-specific names for data references in rules.

SSO database

SSODB

This Enterprise Single Sign-On database securely stores the configuration information for receive locations.

Windows SharePoint Services configuration database

User-defined

This database contains all of the global settings for the server.

Windows SharePoint Services content database

User-defined

This database contains all of the site content, such as list items and documents.

See Also

© 2010 Microsoft Corporation. All rights reserved.

Community Additions

ADD
Show:
© 2014 Microsoft