Gurus,
I have a question regarding the structure of the BAM
Databases,
My client is interested in using the BAM infrastructure to persist the
data during the processing of the orchestration and later do a ETL
process into thier Enterprise Data Warehouse and use it for long term
analysis.I have a few questions regarding the issue.
1.Which database would be appropriate to do the extraction from, my
best bet is BAM archive,
since it will contain the historic data, but my only concern is whether
any data is removed from the primary import and is lost forever when
doing the archiving process,warranting the use of the Primary Import
Database.

I know that this is a unique situation,but any little suggestion which
i can get will be of  great help.

[ Post a follow-up to this message ]

You could pull the data from there, but I'd probably setup my activity as a
historical collection, then edit the DTS package.  I'd change the package so
that it does not move data to analysis services cubes, but rather moves the
data to your custom store where you can do the analytical processing.

Matt


"bomb" <bharathram@gmail.com> wrote in message
news:1151335646.185037.116580@b68g2000cwa.googlegroups.com...
> Gurus,
>             I have a question regarding the structure of the BAM
> Databases,
> My client is interested in using the BAM infrastructure to persist the
> data during the processing of the orchestration and later do a ETL
> process into thier Enterprise Data Warehouse and use it for long term
> analysis.I have a few questions regarding the issue.
> 1.Which database would be appropriate to do the extraction from, my
> best bet is BAM archive,
> since it will contain the historic data, but my only concern is whether
> any data is removed from the primary import and is lost forever when
> doing the archiving process,warranting the use of the Primary Import
> Database.
>
> I know that this is a unique situation,but any little suggestion which
> i can get will be of  great help.
>

[ Post a follow-up to this message ]

You could pull the data from there, but I'd probably setup my activity as a
historical collection, then edit the DTS package.  I'd change the package so
that it does not move data to analysis services cubes, but rather moves the
data to your custom store where you can do the analytical processing.

Matt


"bomb" <bharathram@gmail.com> wrote in message
news:1151335646.185037.116580@b68g2000cwa.googlegroups.com...
> Gurus,
>             I have a question regarding the structure of the BAM
> Databases,
> My client is interested in using the BAM infrastructure to persist the
> data during the processing of the orchestration and later do a ETL
> process into thier Enterprise Data Warehouse and use it for long term
> analysis.I have a few questions regarding the issue.
> 1.Which database would be appropriate to do the extraction from, my
> best bet is BAM archive,
> since it will contain the historic data, but my only concern is whether
> any data is removed from the primary import and is lost forever when
> doing the archiving process,warranting the use of the Primary Import
> Database.
>
> I know that this is a unique situation,but any little suggestion which
> i can get will be of  great help.
>

[ Post a follow-up to this message ]

Thanks Matt,sounds like a plan.
Matt Milner wrote:[vbcol=seagreen]
> You could pull the data from there, but I'd probably setup my activity as 
a
> historical collection, then edit the DTS package.  I'd change the package 
so
> that it does not move data to analysis services cubes, but rather moves th
e
> data to your custom store where you can do the analytical processing.
>
> Matt
>
>
> "bomb" <bharathram@gmail.com> wrote in message
> news:1151335646.185037.116580@b68g2000cwa.googlegroups.com... 

[ Post a follow-up to this message ]

Thanks Matt,sounds like a plan.
Matt Milner wrote:[vbcol=seagreen]
> You could pull the data from there, but I'd probably setup my activity as 
a
> historical collection, then edit the DTS package.  I'd change the package 
so
> that it does not move data to analysis services cubes, but rather moves th
e
> data to your custom store where you can do the analytical processing.
>
> Matt
>
>
> "bomb" <bharathram@gmail.com> wrote in message
> news:1151335646.185037.116580@b68g2000cwa.googlegroups.com... 

[ Post a follow-up to this message ]

Hi Bharath,

The solution from Matt is a good one given what you want to do.   The only
problem is that there might be issue when you do upgrade.  Just make sure
that you have a copy of the original DTS somewhere and if necessary to
revert it back prior to any future upgrades.   Just a thought so that you
client is aware of this.   I got your email posted thru my blog as well.

Happy BAMifying 

Thanks,
Keith Lim [MSFT]
My BizTalk BAM Blog: http://blogs.msdn.com/keithlim/default.aspx

--------------------[vbcol=seagreen] 
14:54:31 GMT)[vbcol=seagreen] 
NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1),gzip(gfe),gzip(gfe)[vbcol=seagreen] 
(NetCache NetApp/6.0.2)[vbcol=seagreen] 
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!newsfeed.c
w.net!cw.net!news-FFM2.ecrc.de!news.glorb.com!postnews.google.com!u72g2000cw
u.googlegroups.com!not-for-mail[vbcol=seagreen] 
as a[vbcol=seagreen] 
package so[vbcol=seagreen] 
the[vbcol=seagreen] 
whether[vbcol=seagreen] 

--

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.

[ Post a follow-up to this message ]

Hi Bharath,

The solution from Matt is a good one given what you want to do.   The only
problem is that there might be issue when you do upgrade.  Just make sure
that you have a copy of the original DTS somewhere and if necessary to
revert it back prior to any future upgrades.   Just a thought so that you
client is aware of this.   I got your email posted thru my blog as well.

Happy BAMifying 

Thanks,
Keith Lim [MSFT]
My BizTalk BAM Blog: http://blogs.msdn.com/keithlim/default.aspx

--------------------[vbcol=seagreen] 
14:54:31 GMT)[vbcol=seagreen] 
.NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1),gzip(gfe),gzip(gfe)[vbcol=seagreen] 
(NetCache NetApp/6.0.2)[vbcol=seagreen] 
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!newsfeed.c
w.net!cw.net!news-FFM2.ecrc.de!news.glorb.com!postnews.google.com!u72g2000cw
u.googlegroups.com!not-for-mail[vbcol=seagreen] 
as a[vbcol=seagreen] 
package so[vbcol=seagreen] 
the[vbcol=seagreen] 
whether[vbcol=seagreen] 

--

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.

[ Post a follow-up to this message ]