Reporting

Question

Hi all

We have BizTalk 2006 R2 in production enviroment..

We have close to 10000 transaction coming from 10 different Application per day.

We are looking for a way to extract only the finished/deleted  transaction information from the HAT.
I.E is there a way of counting the number of transaction passing through the application , extract the relative file information i.e File name
and store them in a Datawarehouse for future reporting..

Regards

---

AKE

Answer 1

Hi,

The best option to do that is to use BAM.



 

---

HTH, Randal van Splunteren - http://biztalkmessages.vansplunteren.net - Please mark as answered if this answers your question.

Answer 2

Hi,

You need to explore more on Microsoft.BizTalk.Operations dll. I implemented the similar few months back. You could possibly refer to below link. I will post more information in a while.

http://geekswithblogs.net/VishnuTiwariBlog/archive/2009/11/02/using-bam-apis-for-tracking.aspx

Regards
Vishnu

---

Vishnu

Answer 3

If you want to monitor your Business Activities for Business Users and that is what your scenario is you have to use BAM (Business Activity Monitoring) tool. You can download the BAM Training Kit from here http://msdn.microsoft.com/en-us/library/cc963995.aspx

---

Abdul Rafay http://abdulrafaysbiztalk.wordpress.com/ Please mark this as answer if it helps

Answer 4

Hi,

I got the link for the sample [Look for "BAM and HAT correlation"] which I referred.

http://msdn.microsoft.com/en-us/biztalk/bb608375.aspx

You probably need to explore more to get the required results. You can create your custom .net application to achieve your functionality.
Hope this should help.

---

Vishnu

Answer 5

Agree that BAM would be a great way of tracking the information you need.

You could come up with some queries to gather some initial information already stored on your tracking database though. Here are some examples queries I wrote a while ago:
http://connectedthoughts.wordpress.com/2009/02/23/biztalk-tracking-database-count-queries/

---

Thiago Almeida - http://connectedthoughts.wordpress.com