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" <[EMAIL PROTECTED]> 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.
