|
Home > Archive > BizTalk Server General > June 2006 > BAM Databases
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| 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.
| |
| Ekta Aggarwal [MSFT] 2006-06-27, 7:16 pm |
| Hi,
Yes BamArchive is the best place to extarct data. There is one problem though : latency which depends on the archiving and analysis DTS tasks interval. There will be no lost data.
HTH
-Ekta
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.
--------------------
>From: "bomb" <bharathram@gmail.com>
>Newsgroups: microsoft.public.biztalk.general
>Subject: BAM Databases
>Date: 26 Jun 2006 08:26:55 -0700
>Organization: http://groups.google.com
>Lines: 17
>Message-ID: <1151335615.540697.113290@b68g2000cwa.googlegroups.com>
>NNTP-Posting-Host: 66.210.174.40
>Mime-Version: 1.0
>Content-Type: text/plain; charset="iso-8859-1"
>X-Trace: posting.google.com 1151335620 29314 127.0.0.1 (26 Jun 2006 15:27:00 GMT)
>X-Complaints-To: groups-abuse@google.com
>NNTP-Posting-Date: Mon, 26 Jun 2006 15:27:00 +0000 (UTC)
>User-Agent: G2/0.2
>X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
>X-HTTP-Via: 1.0 192.168.50.11:3128 (iPrism/v3), 1.0 okcnetcache01 (NetCache NetApp/6.0.2)
>Complaints-To: groups-abuse@google.com
>Injection-Info: b68g2000cwa.googlegroups.com; posting-host=66.210.174.40;
> posting-account=F6HonA0AAACZ1_hTCEcKBjR4B0B-J0tU
>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTFEEDS01.phx.gbl!msrtrans!newsfeed.media.kyoto-u.ac.jp!newsfeed.news2me.com!nx02.iad01.newshosting.com!newshosting.com!
216.196.98.140.MISMATCH!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!b68g2000cwa.googlegroups.com!not-for-mail
>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.biztalk.general:38622
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>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.
>
>
|
|
|
|
|