January 2006 - Posts

• Modifying Length of a Text Data Item of an Activity

  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 Read More... Posted Thursday, January 19, 2006 12:46 PM by derektan | 1 Comments

• Moving Time Window of BAM Aggregated Alerts

  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 Read More... Posted Monday, January 09, 2006 1:53 PM by derektan | 0 Comments

• BAM integration with Microsoft SQL Server Reporting Services 2005

  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 Read More... Posted Monday, January 09, 2006 1:39 PM by derektan | 0 Comments

• What is a Progress Dimension? What are a Progress Stage and a Progress Milestone?

  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, Read More... Posted Monday, January 09, 2006 12:29 PM by derektan | 0 Comments

• Backup and Restore for BAM databases

  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 of Read More... Posted Monday, January 09, 2006 11:57 AM by derektan | 1 Comments

• BAM without BizTalk Configuration (Part 3)

  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 Grant Read More... Posted Friday, January 06, 2006 12:58 PM by derektan | 0 Comments

• BAM without BizTalk Configuration (Part 2)

  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 Read More... Posted Friday, January 06, 2006 11:43 AM by derektan | 2 Comments

• BAM without BizTalk configuration (Part 1)

  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 following Read More... Posted Wednesday, January 04, 2006 4:18 PM by derektan | 0 Comments

• Addition of BAM Analysis after initial configuration

  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 Read More... Posted Wednesday, January 04, 2006 3:38 PM by derektan | 1 Comments

• Real-time Aggregation Online Window

  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 Read More... Posted Wednesday, January 04, 2006 2:51 PM by derektan | 0 Comments