I see, what you call realtime DWH, I would tend to consider this as a
mix between BAM and DWH. BAM stands for Business Activity Monitoring.
Some BPM solutions (BPM stands for Business Process Management) have
an integrated BAM service, it means that related process metrics are
automatically recorded in a BAM database and accessible through a
dashboard.
Robin
--- In [email protected], Nierop Pieter
<[EMAIL PROTECTED]> wrote:
>
> Robin,
>
> What I try to do is to feed a DWH using Bizztalk. I don't know
what a BAM is, will have to look this up....
>
> What we do:
>
> First of all we collect process information like start, endpoint
and general information of processes and then by using Bizztalk we
collect additional process information from our source-databases.
>
> After enriching this data we load it into our preparatory format.
A table that contains the information we use for building our stars.
After that we load the information into our stars using loading
services. Every step is logged.
>
> All these services are managed by using Bizztalk. So our
processes, the collection of process trigers, enriching of data,
logging, loading in preparatory tables and loading stars are handled
by services that are controled by Bizztalk.
>
> In this way we try to create a realtime DWH.
>
> For defining and creating stars we use a metadatamanaged design
tool. After giving in meta-data our star-scheme's automatically get
generated. Further after giving in the metadata of our sources the
mapping from source to targeted stars is for a big part automatically
generated and loading-software is also automatically generated. For
some mappings there is some work to be done by hand. All these
automatically generated loadingscripts are defined as services.
>
> Pieter
>
>
>
> Robin <[EMAIL PROTECTED]> wrote:
> I don't understand the question. Are you trying to use
Bizztalk to
> feed a DWH? or to get information from a DWH? or are you trying to
> implement some kind of BAM in your DWH for specific processes?
> Best regards.
> Robin Mulkers
>
> --- In [email protected], "Pieter
> Nierop" <pnierop@> wrote:
> >
> > Someone ever build a DWH based on SOA using Bizztalk?
> > Any tips, links for me?
> >
> > Pieter
> >
>
>
>
>
>
>
> ---------------------------------
> Looking for earth-friendly autos?
> Browse Top Cars by "Green Rating" at Yahoo! Autos' Green Center.
>
