Newbie questions on BAM

From: sidd (sidd_at_discussions.microsoft.com)
Date: 10/14/04 

Date: Wed, 13 Oct 2004 23:23:03 -0700

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

 

Relevant Pages

  • RE: Installation Question...
    ... If using BAM, Excel is needed in a couple of cases. ... you need to be on a BTS box with a complete installation to do this, ... Microsoft Office InfoPath is optional for a BizTalk Server 2006 ...
    (microsoft.public.biztalk.general)
  • RE: BAM - Error deploying excel file
    ... Also I have already turned on the BAM option in excel. ... create/export your BAM definition file. ... BAM - Error deploying excel file ...
    (microsoft.public.biztalk.general)
  • RE: BizTalk 2006 BAM Sample...
    ... It is a doc bug that you are hitting. ... we have BAM XLA to be added in Excel instead of BAM.xls. ... my installation folder I can't find this xls file. ...
    (microsoft.public.biztalk.general)
  • RE: BAM - Error deploying excel file
    ... There is no BAM.xls for BTS 2006. ... Also I have already turned on the BAM option in excel. ... |> create/export your BAM definition file. ...
    (microsoft.public.biztalk.general)
  • RE: Newbie questions on BAM
    ... direct call as what you have given while creating activity in excel. ... > 1)in genral you create bam activity in excel file and then one can use ... > and present in a web interface like asp.net. ... > once i have the data,is there any built in web interface/Controls which come ...
    (microsoft.public.biztalk.general)