Modifying the size of a nvarchar column of a data item of an activity Applies to: Microsoft BizTalk Server 2004 You have already deployed a BAM definition with a text data item but now you want to change the maximum length of data item. The recommended...

In BizTalk 2006, you can define alerts based on real-time aggregations or scheduled aggregations based on analysis cubes. For aggregated alerts, you have the option to specify a time window. This binds the alerts to be aggregated within a time past to...

The steps to create a report based on data in Bam infrastructure is no different from what one would do for other SQL data sources. It is recommended that you read the “ Creating a Report with Report Designer ” section in SQL Server 2005 Books Online...

BAM introduces a new type of dimension, the Progress Dimension. It allows aggregations of data within categories of progress status of activities. For example, the valid categories of status of a purchase order activity may be evaluating, fulfilling,...

The following applies to BAM in BizTalk 2006. It would work similarly in BizTalk 2004, without SQL NS databases. Deployment and Removal To ensure consistent schema across all BAM databases, run the “Backup BizTalk Server” SQL job for each deployment...

The BAM web service needs to be able to access the SQL NS binaries in order to set up alerts. The following will set up the BAM portal so that you can define alerrts via the portal. Grant Permissions to Microsoft SQL Notification Services bin folder...

The following assumes that you are using Internet Information Services (IIS) 6.0 or higher and your operating system is Microsoft Windows Server 2003. 1. Create Application Pool a. Click Start->Programs->Administrative Tools->Internet Information...

In BizTalk 2006, if you do not want to create a BizTalk group, yet would still like to use BAM. You can create the BAM infrastructure is supported without having to configure BizTalk. The steps are as follows: Define a Bam Configuration file. The...

In BizTalk 2004, in order to add BAM Analysis after an initial configuration without, one can use a command in bm.exe to create the BAM Analysis as well as the BAM Star Schema databases. The star schema database acts us a staging database for the building...

In BAM, instead of waiting for the execution of data analysis task to update the cube aggregations at scheduled intervals, one can define specific slices of data to be aggregated in real-time. For example, in a departmental store scenario, a store manager...