|
Home > Archive > Commerce Server General > September 2006 > Integrating Inventory to CS 2007 using BizTalk Server
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]
| Author |
Integrating Inventory to CS 2007 using BizTalk Server
|
|
|
| Are there any tech notes or tutorials of integrating an Inventory system
(within SQL Server) with Commerce Server using BizTalk.
| |
| Vinayak Tadas[MSFT] 2006-09-18, 7:36 pm |
| Is this the Commerce Server 2007 Inventory system you are talking about ?
Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only
--------------------
Thread-Topic: Integrating Inventory to CS 2007 using BizTalk Server
thread-index: AcbbRkGwshzWntK3TSieV4IJUVm53w==
X-WBNR-Posting-Host: 70.88.248.145
From: =?Utf-8?B?WGNlbA==?= <Xcel@discussions.microsoft.com>
Subject: Integrating Inventory to CS 2007 using BizTalk Server
Date: Mon, 18 Sep 2006 10:17:02 -0700
Lines: 2
Message-ID: <48F49368-DE37-4838-8C90-8B6BFC0CCA7F@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.commerceserver.general
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18449
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.general
Are there any tech notes or tutorials of integrating an Inventory system
(within SQL Server) with Commerce Server using BizTalk.
| |
|
| Yes, I would like to integrate the Inventory System in CS 2007 with our
in-house Inventory system that resides in SQL.
""Vinayak Tadas[MSFT]"" wrote:
> Is this the Commerce Server 2007 Inventory system you are talking about ?
>
>
> Thanks
> Vinayak Tadas
> Microsoft
> http://blogs.msdn.com/vinayakt
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
> You assume all risk for your use. © 2002 Microsoft Corporation. All rights
> reserved.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> Get Secure! For more info visit http://www.microsoft.com/security. Please
> reply to the newsgroups only
>
>
> --------------------
> Thread-Topic: Integrating Inventory to CS 2007 using BizTalk Server
> thread-index: AcbbRkGwshzWntK3TSieV4IJUVm53w==
> X-WBNR-Posting-Host: 70.88.248.145
> From: =?Utf-8?B?WGNlbA==?= <Xcel@discussions.microsoft.com>
> Subject: Integrating Inventory to CS 2007 using BizTalk Server
> Date: Mon, 18 Sep 2006 10:17:02 -0700
> Lines: 2
> Message-ID: <48F49368-DE37-4838-8C90-8B6BFC0CCA7F@microsoft.com>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="Utf-8"
> Content-Transfer-Encoding: 7bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Content-Class: urn:content-classes:message
> Importance: normal
> Priority: normal
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
> Newsgroups: microsoft.public.commerceserver.general
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18449
> NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> X-Tomcat-NG: microsoft.public.commerceserver.general
>
> Are there any tech notes or tutorials of integrating an Inventory system
> (within SQL Server) with Commerce Server using BizTalk
| |
| Jeff Lynch 2006-09-18, 7:36 pm |
| There are two ways to accomplish this.
1) Use the CS2007 Inventory Adapter and BTS2006 to "pull" inventory data
from your backend system periodically.
2) Use a SQL sproc to update the CS2007 inventory tables from data in your
backend system.
I've done both and so far, they both work well.
--
Jeff Lynch
MVP Windows Server System - Commerce Server
http://codebetter.com/blogs/jeff.lynch
"Xcel" <Xcel@discussions.microsoft.com> wrote in message
news:EB698D74-2DFC-4621-AA1A-999F3691ECDF@microsoft.com...[vbcol=seagreen]
> Yes, I would like to integrate the Inventory System in CS 2007 with our
> in-house Inventory system that resides in SQL.
>
> ""Vinayak Tadas[MSFT]"" wrote:
>
| |
| Vinayak Tadas[MSFT] 2006-09-18, 7:36 pm |
| Have you looked into the XML Import/export features of Inevntory system?
Thanks
Vinayak Tadas
Microsoft
http://blogs.msdn.com/vinayakt
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. © 2002 Microsoft Corporation. All rights
reserved.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Get Secure! For more info visit http://www.microsoft.com/security. Please
reply to the newsgroups only
--------------------
Thread-Topic: Integrating Inventory to CS 2007 using BizTalk Server
thread-index: AcbbYwjqSlIbORJ2S0CA7X/nf5zQTw==
X-WBNR-Posting-Host: 70.88.248.145
From: =?Utf-8?B?WGNlbA==?= <Xcel@discussions.microsoft.com>
References: <48F49368-DE37-4838-8C90-8B6BFC0CCA7F@microsoft.com>
<i#A5eJ22GHA.3440@TK2MSFTNGXA01.phx.gbl>
Subject: RE: Integrating Inventory to CS 2007 using BizTalk Server
Date: Mon, 18 Sep 2006 13:43:02 -0700
Lines: 48
Message-ID: <EB698D74-2DFC-4621-AA1A-999F3691ECDF@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 8bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.commerceserver.general
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18459
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.general
Yes, I would like to integrate the Inventory System in CS 2007 with our
in-house Inventory system that resides in SQL.
""Vinayak Tadas[MSFT]"" wrote:
> Is this the Commerce Server 2007 Inventory system you are talking about ?
>
>
> Thanks
> Vinayak Tadas
> Microsoft
> http://blogs.msdn.com/vinayakt
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> You assume all risk for your use. © 2002 Microsoft Corporation. All
rights
> reserved.
> Use of included script samples are subject to the terms specified at
> http://www.microsoft.com/info/cpyright.htm
> Get Secure! For more info visit http://www.microsoft.com/security.
Please
> reply to the newsgroups only
>
>
> --------------------
> Thread-Topic: Integrating Inventory to CS 2007 using BizTalk Server
> thread-index: AcbbRkGwshzWntK3TSieV4IJUVm53w==
> X-WBNR-Posting-Host: 70.88.248.145
> From: =?Utf-8?B?WGNlbA==?= <Xcel@discussions.microsoft.com>
> Subject: Integrating Inventory to CS 2007 using BizTalk Server
> Date: Mon, 18 Sep 2006 10:17:02 -0700
> Lines: 2
> Message-ID: <48F49368-DE37-4838-8C90-8B6BFC0CCA7F@microsoft.com>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="Utf-8"
> Content-Transfer-Encoding: 7bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Content-Class: urn:content-classes:message
> Importance: normal
> Priority: normal
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
> Newsgroups: microsoft.public.commerceserver.general
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:18449
> NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> X-Tomcat-NG: microsoft.public.commerceserver.general
>
> Are there any tech notes or tutorials of integrating an Inventory system
> (within SQL Server) with Commerce Server using BizTalk
| |
|
| Jeff,
My original thought was to use SQL Stored Procedures, SSIS etc for all my
integrations (Catalog, Inventory, Profiles and Orders) however I was told
this not recommended and supported by Microsoft :-(
Chris...
"Jeff Lynch" wrote:
> There are two ways to accomplish this.
>
> 1) Use the CS2007 Inventory Adapter and BTS2006 to "pull" inventory data
> from your backend system periodically.
>
> 2) Use a SQL sproc to update the CS2007 inventory tables from data in your
> backend system.
>
> I've done both and so far, they both work well.
>
> --
> Jeff Lynch
> MVP Windows Server System - Commerce Server
> http://codebetter.com/blogs/jeff.lynch
>
>
> "Xcel" <Xcel@discussions.microsoft.com> wrote in message
> news:EB698D74-2DFC-4621-AA1A-999F3691ECDF@microsoft.com...
>
>
>
| |
| Jeff Lynch 2006-09-19, 1:28 am |
| Chris,
All I can say to the "not supported" is "do what makes the best sense". I'm
currently using a sproc in some cases and the Inventory Adapter in other
cases. The structure of the inventory table(s) used by CS2007 is pretty
simple and updating it from another SQL table is also pretty simple.
For "Orders" , "Catalog" and "Profiles" integration I use the BizTalk
Adapters since they work great in my B2B scenario and they are easier than
using SSIS (in my personal opinion, but my SQL developers tend to disagree).
--
Jeff Lynch
MVP Windows Server System - Commerce Server
http://codebetter.com/blogs/jeff.lynch
"Xcel" <Xcel@discussions.microsoft.com> wrote in message
news:3D4254CE-7B29-4E9B-8BE6-79C4D6D98F6A@microsoft.com...
> Jeff,
>
> My original thought was to use SQL Stored Procedures, SSIS etc for all my
> integrations (Catalog, Inventory, Profiles and Orders) however I was told
> this not recommended and supported by Microsoft :-(
>
> Chris...
| |
| Colin Bowern 2006-09-20, 1:22 pm |
| Chris,
I guess it depends on how much flexibility you want. The support boundaries
are a bit fuzzy with Commerce Server given that you are meant to extend it
in many ways. The support scenario will likely turn to a "best effort"
scenario when custom code is in effect. I would echo Jeff's recommendation
of going to the table if that is the easiest way to do it. For example,
we're writing additional sprocs to sit beside in the out-of-the-box sprocs
to provide some additional inventory related functionality.
As well, when dealing with support they will often ask you to try and
isolate the problem in the starter site or in a new site scenario. It's a
prety fair ask and will often help you focus on the root cause as well.
Cheers,
Colin
---
We're looking for smart people to join our team in buildling communities for
music legends: http://rockstarguys.com/smrtppl
"Xcel" <Xcel@discussions.microsoft.com> wrote in message
news:3D4254CE-7B29-4E9B-8BE6-79C4D6D98F6A@microsoft.com...[vbcol=seagreen]
> Jeff,
>
> My original thought was to use SQL Stored Procedures, SSIS etc for all my
> integrations (Catalog, Inventory, Profiles and Orders) however I was told
> this not recommended and supported by Microsoft :-(
>
> Chris...
>
> "Jeff Lynch" wrote:
>
|
|
|
|
|