|
Home > Archive > Commerce Server General > April 2005 > Order Extraction From SQL 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 |
Order Extraction From SQL Server
|
|
| jtwright@tycovalves.com 2005-04-13, 8:50 pm |
| We have our Commerce Server integrating with 2 different no-name ERP
systems. When an order is complete, we have a VB6 application that
runs on a scheduler which extracts each order from SQL Server and maps
it to an XML schema. This XML file gets passed to our BizTalk Server
for mapping to the ERP system.
My question is how do most people get their orders out of SQL in order
to process them. I'd like to get rid of all VB6 applications that I
have and didn't know if anyone uses a .NET solution for this, or if
there is just a better method alltogether.
Regards,
John
| |
| Jeff Lynch 2005-04-13, 8:50 pm |
| John,
Long time no talk buddy!
A few possibilities:
1. Rewrite the VB6 app in C# or VB.NET and run it using the task scheduler
as before.
2. Use the BizTalk Server 2002 SQL Adapter to extract the orders from the
CS2002 tables and submit them to your ERP systems. I'm not sure how this
adapter handles a scheduled process though.
3. BTS2004 has a new SQL Receive Adapter that periodically polls for SQL
result sets. I've used this to periodically extract data from a SQL table
and submit it to BTS2004 for processing.
4. You could also write some code in your CS2002 app to submit the basket
directly to your BTS2002 server at the "checkout" time.
--
Jeff Lynch
"A BizTalk Enthusiast"
http://codebetter.com/blogs/jeff.lynch
<jtwright@tycovalves.com> wrote in message
news:1113413917.355351.210070@g14g2000cwa.googlegroups.com...
> We have our Commerce Server integrating with 2 different no-name ERP
> systems. When an order is complete, we have a VB6 application that
> runs on a scheduler which extracts each order from SQL Server and maps
> it to an XML schema. This XML file gets passed to our BizTalk Server
> for mapping to the ERP system.
>
> My question is how do most people get their orders out of SQL in order
> to process them. I'd like to get rid of all VB6 applications that I
> have and didn't know if anyone uses a .NET solution for this, or if
> there is just a better method alltogether.
>
> Regards,
>
> John
>
| |
| Ravi Shankar 2005-04-14, 2:49 am |
| Expanding on what Jeff has mentioned you should
1. Use the POSCHEMA.XML and amend it to incorporate your order specifics.
2. Create a pipeline component that uses the
DictionaryTransformToXMLFreeThreaded (something like this) to convert it into
an XML
3. Using BTS2004 create an orchestration that uses the amended poschema.xml
and update it to your no-name ERP.
4. Expose the above orchestration as a web service
5. In the component written in 2 after conversion to XML, submit it to
webservice exposed in 4
Have fun ! 
"jtwright@tycovalves.com" wrote:
> We have our Commerce Server integrating with 2 different no-name ERP
> systems. When an order is complete, we have a VB6 application that
> runs on a scheduler which extracts each order from SQL Server and maps
> it to an XML schema. This XML file gets passed to our BizTalk Server
> for mapping to the ERP system.
>
> My question is how do most people get their orders out of SQL in order
> to process them. I'd like to get rid of all VB6 applications that I
> have and didn't know if anyone uses a .NET solution for this, or if
> there is just a better method alltogether.
>
> Regards,
>
> John
>
>
| |
| jtwright@tycovalves.com 2005-04-14, 7:48 am |
| Excellent. We are migrating to BTS2004 currently, so that will make
for something fun to try out with webservices in orchestrations.
Thanks for the info.
|
|
|
|
|