RE: Newbie questions on BAM

From: Derek Tan [MSFT] (derektan_at_online.microsoft.com)
Date: 10/14/04 

Date: Thu, 14 Oct 2004 18:05:18 GMT

Hi Siddharth,

1) Yes, you will call DirectEventStream API with the activity name that you have defined.
2 & 3) Out of the box, if you installed and configured BAS (Business Activity Services), you will get a link that brings up the
Business Activity Search. From there, you will be able to query instance data (as opposed to aggregated data). Otherwise,
follow the BizTalk online help, link http://www.msdn.microsoft.com/library/default.asp?url=/library/en-
us/sdk/htm/ebiz_prog_bam2_xxbo.asp to "Querying BAM Data" section on how to query data.
4) You do not need any dimensions or measures to do this. What you have asked to output is instance data. Define views
containing aliases referencing the data items that you want to view and use 2) & 3) as above to query the instance data.

Regards,
Derek [MSFT]

--------------------
>Thread-Topic: Newbie questions on BAM
>thread-index: AcSyA/cMrTih6bIFSIeVF1wpe5cVaA==
>X-WBNR-Posting-Host: 63.166.226.90
>From: =?Utf-8?B?c2lkZGhhcnRo?= <siddharth@discussions.microsoft.com>
>References: <B8FEDA59-0285-4088-BCC0-33ACD774E1EB@microsoft.com>
>Subject: RE: Newbie questions on BAM
>Date: Thu, 14 Oct 2004 08:39:17 -0700
>Lines: 80
>Message-ID: <EFC631B0-E46A-444A-BD9B-65731E25788F@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups: microsoft.public.biztalk.general
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
>Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.general:20732
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>i think answer to my first question is that you use the same activity name in
>direct call as what you have given while creating activity in excel.
>
>but still don't know answer to other(2,3,4) questions i posted.
>thanks
>siddharth
>
>"sidd" wrote:
>
>> Hi All,
>> please see if some one could help me with this.
>> 1)in genral you create bam activity in excel file and then one can use
>> BizTalk Server Tracking Profile Editor to configure which data in your
>> orchestrations map to which BAM fields.by doing this we are establishing a
>> line between the data in orchestration and the activity we have created in
>> excel.
>>
>> how is this link created when you are baming data using 'DirectEventStream'
>> direct calls(beginactivity etc...) how does biztalk know which excel file..in
>> other words which activity we are trying to BAM this data for ....i could not
>> undestand this in BAMApi sample..?
>> 2) whats are different ways to get the data from the BAM tables/views .are
>> there any API/stored procedures which return the data?
>> OR
>> should we directly access the views created using TSQL.
>> also can some one give some description of what all views/tables are created
>> when you deploy a activity.which one of these are okay to access and which
>> ones are not meaning they may or may not be supported in future?are they
>> documented some where(please post a link)?
>>
>> 3)in my application i want to fetch the data from BAM
>> store(BAMPrimaryImportDB)
>> and present in a web interface like asp.net.
>> now answer to my second question will tell me how i get to the data ..but
>> once i have the data ,is there any built in web interface/Controls which come
>> with BAM by default that one can use to display data in web
>> interface?basically i don't prefer to built presentation UI if there is one
>> already built.
>>
>> 4)Last question-->
>> i have a xml message as follows..
>>
>>
>> <CustomerRequests>
>> <CustomerRequest sequestName="Service1" ServiceBy="Joe"
>> ServicedOnDate="10-10-2004" >
>> <CustomerRequest sequestName="Service2" ServiceBy="Joe"
>> ServicedOnDate="10-10-2004">
>> <CustomerRequest sequestName="Service3" ServiceBy="Jack"
>> ServicedOnDate="10-10-2004">
>> <CustomerRequest sequestName="Service4" ServiceBy="Jack"
>> ServicedOnDate="10-10-2004">
>>
>> </CustomerRequests>
>>
>> i want to use bam to capture data as it is being processed by
>> orchestrations...
>> final out put will be just a tabular presentation of this xml message...so
>> we want to be able se who serviced a request on what date....
>>
>> so out put would look like
>> ROW 1-->Joe Service1 10-10-2004
>>
>> ROW 2-->Joe Service2 10-10-2004
>>
>> ROW 3-->Jack Service3 10-10-2004
>>
>> ROW 4-->Jack Service4 10-10-2004
>>
>> could some one help me undestand what should be my Mesaures and dimentions
>> to acheive this?
>>
>> thank
>> siddharth
>>
>>
>>
>>
>>
>>
> 

-- 
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the 
terms specified at http://www.microsoft.com/info/cpyright.htm 
Note:  For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread 
from which they originated.