|
Home > Archive > Commerce Server General > September 2006 > Export Product data via Biztalk Adapater
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 |
Export Product data via Biztalk Adapater
|
|
| CodeDigger 2006-09-07, 7:33 pm |
| I need to export Product data from Catalog system via the Biztalk Adapater
for Commerce Server 2007.
MSDN says - "If you change the default schemas for the Orders, Catalog,
Inventory, or Profiles Systems within Commerce Server, and you are going to
use one or more of the BizTalk adapters provided with Commerce Server, you
will need to generate an up-to-date version of the XSD file that describes
the now changed schema(s) and deploy the schema(s) to the BizTalk application
in which your adapters reside. By doing this, the BizTalk processing that you
develop for the adapter messages will be able to properly validate and
interpret the data in the body of the messages."
http://msdn.microsoft.com/library/d...0507d232f54.asp
It explains the Orders and Profiles, but for atalog and Inventory, it says -
"The Catalog and Inventory adapters provide an alternative mechanism for
generating the Catalog System and Inventory System schemas, respectively.
When you configure the transport property Format Type to Xsd for a Catalog or
Inventory receive adapter endpoint, the body of the export message contains
the schema of the corresponding Commerce Server system."I dont understand. So
what this means is I really dont have to do anything - simply apply the map
on the Send Port of the Commerce Server Catalog Adapter? What about
namespaces, or schema type names? DO I have to use the default names for
messagetypes?
a) Which raises another questions. The MessageType name for the Catalog
Schema is
"Microsoft.CommerceServer.Adapter.MessageSchemas.Catalog1.DefaultCatalog" -
but the DefaultCatalog is a system schema and not an adapter schema. Why is
everthing prefaced with "Microsoft.CommerceServer.Adapter.xxx" ?
| |
| Jeff Lynch 2006-09-07, 7:33 pm |
| There are two basic ways to do this.
1) Use the Catalog adapter to export only your custom catalog schema (xsd).
2) Export your catalog using the Catalog Manager application and then create
a BizTalk schema from the XML.
--
Jeff Lynch
MVP Windows Server System - Commerce Server
http://codebetter.com/blogs/jeff.lynch
"CodeDigger" <CodeDigger@discussions.microsoft.com> wrote in message
news:48AE6358-518F-41C7-A40E-0D34AFC75F07@microsoft.com...
>I need to export Product data from Catalog system via the Biztalk Adapater
> for Commerce Server 2007.
>
> MSDN says - "If you change the default schemas for the Orders, Catalog,
> Inventory, or Profiles Systems within Commerce Server, and you are going
> to
> use one or more of the BizTalk adapters provided with Commerce Server, you
> will need to generate an up-to-date version of the XSD file that describes
> the now changed schema(s) and deploy the schema(s) to the BizTalk
> application
> in which your adapters reside. By doing this, the BizTalk processing that
> you
> develop for the adapter messages will be able to properly validate and
> interpret the data in the body of the messages."
>
> http://msdn.microsoft.com/library/d...0507d232f54.asp
>
> It explains the Orders and Profiles, but for atalog and Inventory, it
> says -
> "The Catalog and Inventory adapters provide an alternative mechanism for
> generating the Catalog System and Inventory System schemas, respectively.
> When you configure the transport property Format Type to Xsd for a Catalog
> or
> Inventory receive adapter endpoint, the body of the export message
> contains
> the schema of the corresponding Commerce Server system."I dont understand.
> So
> what this means is I really dont have to do anything - simply apply the
> map
> on the Send Port of the Commerce Server Catalog Adapter? What about
> namespaces, or schema type names? DO I have to use the default names for
> messagetypes?
> a) Which raises another questions. The MessageType name for the Catalog
> Schema is
> "Microsoft.CommerceServer.Adapter.MessageSchemas.Catalog1.DefaultCatalog"
> -
> but the DefaultCatalog is a system schema and not an adapter schema. Why
> is
> everthing prefaced with "Microsoft.CommerceServer.Adapter.xxx" ?
| |
| CodeDigger 2006-09-08, 7:22 am |
|
"Jeff Lynch" wrote:
> There are two basic ways to do this.
> 1) Use the Catalog adapter to export only your custom catalog schema (xsd).
> 2) Export your catalog using the Catalog Manager application and then create
> a BizTalk schema from the XML.
I have taken the second route. What I am asking is -
1) How will Commerce Server "know" how to apply which schema elements to
match to which? By a run-time matching of the schema?
2) Are the namespaces (targetNamepace) and schema MessageType names
important?
2a) Why are the MessageType name for the Catalog Schema
"Microsoft.CommerceServer.Adapter.MessageSchemas.Catalog1.DefaultCatalog" -
when the DefaultCatalog is a **System schema** and not an adapter schema.
Why is
everthing prefaced with adapter - as in
"Microsoft.CommerceServer.Adapter.xxx" ?
| |
| CodeDigger 2006-09-08, 7:24 pm |
| One more question - if I wanted to export only Products (child node in the
schema) and not Catalog data, how could I do that? Do I have to put in the
Catalog Name so it would know which Catalog to export the Products to?
| |
| Brian Blum [MSFT] 2006-09-08, 7:24 pm |
| There are a couple of different schemas associated with the CS BizTalk
Adapters. First, there are the schemas associated with the messages that
act as commands to the Adapters. Then, there are the schemas that are
associated with the data produced by the different web service calls that
the Adapters pass to BizTalk.
If you are trying to map the content of an Inventory export (whether
through the Receive Adapter or the results of a query to the Send Adapter),
you need to have the message body associated with output of web service
call (the second type noted above).
1. The Catalog and Inventory web service has an xsd that it uses to export
its data. BizTalk is responsible for mapping elements of the CS schema to
some other LOB schema.
2. The target namespace is important because BizTalk will need this for
its mapping. MessageType names are important for routing. These are the
commands that tell the Adapters which web service api to invoke.
2a. I'm not sure what message type you're referring to here.
This posting is provided "AS IS" with no warranties, and confers no rights.
EBuisness Server Team
--------------------
Thread-Topic: Export Product data via Biztalk Adapater
thread-index: AcbS65yuz1DO/w9eQ521mV1P8FzeGg==
X-WBNR-Posting-Host: 70.26.112.25
From: =?Utf-8?B?Q29kZURpZ2dlcg==?= <CodeDigger@discussions.microsoft.com>
References: <48AE6358-518F-41C7-A40E-0D34AFC75F07@microsoft.com>
<OwGiAVt0GHA.4264@TK2MSFTNGP05.phx.gbl>
Subject: Re: Export Product data via Biztalk Adapater
Date: Thu, 7 Sep 2006 19:08:01 -0700
Lines: 25
Message-ID: <FD84860E-D558-4E95-B952-58F798089180@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:18346
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.general
"Jeff Lynch" wrote:
> There are two basic ways to do this.
> 1) Use the Catalog adapter to export only your custom catalog schema
(xsd).
> 2) Export your catalog using the Catalog Manager application and then
create
> a BizTalk schema from the XML.
I have taken the second route. What I am asking is -
1) How will Commerce Server "know" how to apply which schema elements to
match to which? By a run-time matching of the schema?
2) Are the namespaces (targetNamepace) and schema MessageType names
important?
2a) Why are the MessageType name for the Catalog Schema
"Microsoft.CommerceServer.Adapter.MessageSchemas.Catalog1.DefaultCatalog" -
when the DefaultCatalog is a **System schema** and not an adapter schema.
Why is
everthing prefaced with adapter - as in
"Microsoft.CommerceServer.Adapter.xxx" ?
| |
| Brian Blum [MSFT] 2006-09-08, 7:24 pm |
| I don't understand what you mean when you say:
Do I have to put in the Catalog Name so it would know which Catalog to
export the Products to?
On a query or export, you have to put the Catalog Name in so that the
Adapter know which Catalog to export the products from.
You can shape the export by using the 'Properties to Export' field on the
Receive Adapter, so if you only want the product id, you could put
ProductID in the 'Properties to Export' field of the Receive Adapter config
screen, but that limits all of the exports through that endpoint to just
include the ProductID in the output. Another approach would be to export
more data and then use a map to filter the data that your other endpoint
receives.
This posting is provided "AS IS" with no warranties, and confers no rights.
EBuisness Server Team
--------------------
Thread-Topic: Export Product data via Biztalk Adapater
thread-index: AcbTTxQZlld1sZ4uSLaPkk3IOdKSWQ==
X-WBNR-Posting-Host: 70.26.112.25
From: =?Utf-8?B?Q29kZURpZ2dlcg==?= <CodeDigger@discussions.microsoft.com>
References: <48AE6358-518F-41C7-A40E-0D34AFC75F07@microsoft.com>
<OwGiAVt0GHA.4264@TK2MSFTNGP05.phx.gbl>
Subject: Re: Export Product data via Biztalk Adapater
Date: Fri, 8 Sep 2006 07:00:01 -0700
Lines: 3
Message-ID: <7D24214C-D1D1-41BC-892F-2EEB82442C34@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:18352
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.general
One more question - if I wanted to export only Products (child node in the
schema) and not Catalog data, how could I do that? Do I have to put in the
Catalog Name so it would know which Catalog to export the Products to?
| |
|
|
|
|
|