BAM API's for Custom Dash board?

[Srinivasa Mahendrakar]

Hi group,

BACKGROUND:- I am working on a project where we are prviding frame work
for the Biztalk Developers for streamlining the Development process. We have
our Custom Dash board to monitor the activities of various Interfaces running
in the organization. This dash board is using the BAM Infrastructure. we are
using BAM API's in our tracking components.Now we are upgrading our whole
biztalk infrastructure to BTS2006.

PROBLEM:- we were using our own SQL queries (Leveraging some views in BAM
infrastructure)to retrieve the data from the BAM Tables into our Custom
Dashboard.
But now we are facing lot of performance issues in our dash board which we
found difficult to solve as we dont have flexibility in using BAM Tables.

HELP NEEDED:- Now i want to know are there any API's exist in BTS2006 for
retrieving the Data from BAM Tables into our custom dash board(Please note i
am not talking about BAM tracking API's) or are there any best practices to
retrieve the data from the BAM Tables into Custom Dashboard.

with advance thanks
srinivas mahendrakar

[Paul Somers]

You should be using the BAM views in the tables. There are no API's other
than the views in BAM.

You should be using the complete method in BAM, in that when everything is
complete in your view it moves it out of the live incomplete data
tables/views.

If you have significant volumes of data in BAM, you can archive it off using
the archive method for BAM, or you should really move the BAM database to
its own dedicated instance of BAM.

I am so pleased you are using BAM, its great, you just need to manage it
correctly.

Post by Srinivasa Mahendrakar
Hi group,
BACKGROUND:- I am working on a project where we are prviding frame work
for the Biztalk Developers for streamlining the Development process. We have
our Custom Dash board to monitor the activities of various Interfaces running
in the organization. This dash board is using the BAM Infrastructure. we are
using BAM API's in our tracking components.Now we are upgrading our whole
biztalk infrastructure to BTS2006.
PROBLEM:- we were using our own SQL queries (Leveraging some views in BAM
infrastructure)to retrieve the data from the BAM Tables into our Custom
Dashboard.
But now we are facing lot of performance issues in our dash board which we
found difficult to solve as we dont have flexibility in using BAM Tables.
HELP NEEDED:- Now i want to know are there any API's exist in BTS2006 for
retrieving the Data from BAM Tables into our custom dash board(Please note i
am not talking about BAM tracking API's) or are there any best practices to
retrieve the data from the BAM Tables into Custom Dashboard.
with advance thanks
srinivas mahendrakar