Working with BAM BizTalk 2013

This space is to describe my experience working with BAM on BizTalk 2013 using SQL Server 2012.

Business Activity Monitoring (BAM) provides real-time business intelligence by capturing data as it flows through a business system. By using BAM, we monitor a business process in real time and generate alerts when the business process needs human intervention.
BAM captures data from business systems, providing real-time monitoring of a business process and makes is available to non-technical users. The main benefits of BAM are

• BAM automates data capture and aggregation.
• Bam provides real-time visibility into business processes.
• BAM can alert users. (though this functionality is not supported in BizTalk 2013 beta using SQL Server 2013 at the moment)
• BAM can capture data asynchronously.

Please follow the below steps to create BAM application.

  1. Include BAM Add-ins in your MS Excel file.

image 2.

If it is not available you can browse it from c:\..\Microsoft BizTalk Server\ExcelDir\Bam.xla.

2. Goto the BAM Add-ins and open Activity.


Click on “New Activity” to create new activity.

3. Give a name to the Activity “ABC_Activity”.


Add fields which you need to track.


You can also create a milestones field which shall be used for aggregation.
4. Click next and you’ll be directed to view creation.


5. Click on to Create a new view and provide name “ABC_View” to the view.

6. Select Activity, and select all the fields.
7. You can create Dimensions/Measurement (you need milestone field defined in the activity page) for creating aggregates (Pivot Table).
8. XML Export.

  • Add-Ins->BAM and click drop down
  • Select Export XML.
  • Save XML.

9. Bam Deployment.

    • Open command prompt.
    • Navigate to the folder where XML file is stored.
    • set the BM path. path %path% ; c:\Program Files\Microsoft BizTalk Server 20xx\Tracking.
    • Run the below command.
    • Bm deploy-all –DefinitionFile:.xml
    • Browse to the BAM Portal – you’ll see the view on the left panel.

10. AIA BAM Usage:-
Once you have created and deployed the BAM project you can browse to the BAM portal. You’ll notice the view created above appears in the left panel. You can also create your own query.

11. Creating Tracking Profile.

  • Open tracking profile editor.


  • Click on “Click here to import a BAM Activity Definition”. This will provide you all the activities which are deployed to BAM database.
  • “Click here to select an event” – using this you can select your tracking fields. It can be message/context property or actual message.
  • You need to select the field and drop it to the field in left panel.
  • For the milestones field the whole orchestration shape needs to be drop e.g. Receive / Send shape.
  • Apply the tracking profile. Tools->Apply tracking profile. You can also remove the tracking profile.

12. Send some messages to BizTalk .

13. Open the BAM Portal and click on the view.

  • select the fields which needs to be included in the report.
  • Click Execute Query. You’ll get the result in the result panel.
  • Subsequently, if you have created Aggregate view, you can see the table once you click the aggregate under aggregations.


13. Alert and Schedule. Save the query and you can use this query to  set up an email/file alert notification for specific threshold.

Note-: The BAM Alert do not work with SQL Server 2012 because SQL Server 2012 do not comes with SQL Server Notification Service although it has it own database mail service, but this service do not work with BAM Alerts. You can generate FILE Alerts though.

BAM is a powerful tracking tools, and can be used for all reporting and tracking of all the incoming messages into BizTalk.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s