Introduction

Business Activity Monitoring is a Real Time Miniature design of Business Intelligence. As number of Finance transactions are growing day by day, we are in need of reporting the transactions to Business for better Decision Making. BAM plays a vital part to implement such a quick BI solution. BAM Tool ships along with BizTalk server, but it also can be coupled with WCF (Windows Communication Foundation) and WF (Windows Workflow Foundation). Below is the List of tables in BAMPrimaryImport database, which is a data source for BAM portal.

S.No

Table Name

Description

1

bam_<ActivityName>_Active

Message Instances which are active are first saved in this table. Is Complete flag will indicate the completion of this instance

2

bam_<ActivityName>_Completed

When the Active instances gets completed, the data from Active table will be moved to Completed table

3

bam_<ActivityName>_ActiveRelationships

Instances Active Relationship Reference are stored in this table

Eg: Relationship between two or more activities

4

bam_<ActivityName>_CompletedRelationships

The Instances are moved to Completed relationship tables from Active Relationship tables once the instances are completed

5

bam_<ActivityName>_Continuations

Continuation between different tracepoints (ActivityID and ParentActivityID are stored in this table). Eg: Receive Trace point and send trace point

6

bam_Metadata_Activities

All BAM activities installed in the Server with Activity Definition XML will be stored in this table

7

bam_Metadata_ActivityViews

Views-Activity Relations are recorded in this table

8

bam_Metadata_AnalysisTasks

Cube record details which is used for analysis is recorded in this table.

Eg: Measures, Dimensions and charts are in the analysis scope

9

bam_Metadata_Annotations

BAM Event bus service converts the data blobs(from BizTalk Engine) to usable data using the metadata annotations

10

bam_Metadata_Configuration

BAM Server Configuration Details are recorded in this table

11

bam_Metadata_Cubes

Cube's Definition XML and associated Views/Activities are listed in this table

12

bam_Metadata_CustomIndexes

Custom indexes, if used for any activities is listed here

13

bam_Metadata_DatabaseVersion

Database Build, Minor, Major, Revision version is resided here

14

bam_Metadata_EventSource

Event Sources used for BAM Interceptors is recorded here

15

bam_Metadata_InterceptorConfiguration

BAM Interceptors(WCF Interceptors) relations with activities and Even XML is stored here

16

bam_Metadata_OperationEvents

All the events which take place in BAM is recorded chronologically

17

bam_Metadata_Operations

BAM Operations like Remove, deploy, update will be recorded here along with definition file, user and configuration files

18

bam_Metadata_Partitions

In order to increase the performance throughput, BAM always does a Partition of completed instance records. The details of Partitions are recorded in this table

19

bam_Metadata_PivotTables

Real Time Aggregation based Pilot table information with reference to cubes/analytics is recorded here

20

bam_Metadata_Properties

BAM Server properties are listed in this table, which was configured in BAM tools of BizTalk Server Configuration

21

bam_Metadata_RealTimeAggregations

Real Time Aggregation details are inserted in this table

22

bam_Metadata_ReferencedDatabases

BAM Referenced databases ( if any) will be recorded here

23

bam_Metadata_RTAMutex

Used for RTA Mutual Exclusion for thread based scenarios

24

bam_Metadata_TrackingProfiles

All Tracking Profiles(Linkage of Ports/Orchestration to BAM Activities) is Listed in this table

25

bam_Metadata_Views

BAM View Details with View Definition XML is recorded in this table

26

BizTalkDBVersion

BAM Primary Import DB's Version details are recorded here

27

MarkLog

This table is filled by the Backup BizTalk server job.

28

TDDS_FailedTrackingData

All BAM related errors are tracked in this table with Time stamp. TDDS Service is responsible for moving data from BizTalk Message box database to Primary import database. Any error that happens during this transport will be recorded in this table

29

TDDS_StreamStatus

Every time the data moved by TDDS Service, the Sequence number in this table will get increase

Note: As we have many default activity tables in BAMPrimaryImport, I am covering it as template tables in the first 5 rows.

Hope this helps…!

See Also

Another important place to find a huge amount of BizTalk related articles is the TechNet Wiki itself. The best entry point is BizTalk Server Resources on the TechNet Wiki.