Microsoft Biz Talk Server Tutorial CIS 764 Enterprise

Microsoft Biz. Talk Server Tutorial CIS 764 - Enterprise Database Design Oubai Bounie

Introduction • Microsoft Biz. Talk Server is an integration server product that enables you to develop, deploy, and manage integrated business processes and XML-based Web services. • Microsoft Biz. Talk Server enables you to connect diverse applications, and then to graphically create and modify business processes that use the services that those applications provide. • Biz. Talk Server engine provides a mechanism for specifying business rules, better ways to manage and monitor the applications built on it. • Biz. Talk supports many built-in data adapters. (SOAP, Message Queuing, FTP, HTTP, SMTP, SQL, EDI, File) • Biz. Talk supports many data format (Database, Formatted Text, HL 7, XML) • Biz. Talk engine uses XML for all internal processing.

Concept Overview

Prerequisites • Microsoft Windows server 2003: you can download trial version from . • Microsoft SQL Server 2000: you can download trial version from http: //www. microsoft. com/sql/evaluation/trial/. • Microsoft Biz. Talk Server 2004: you can download trial version from http: //www. microsoft. com/windowsserver 2003/evaluation/trial/default. mspx http: //www. microsoft. com/biztalk/evaluation/trial/default. mspx. • Microsoft Visual Studio 2003 or newer: you can download trial version from http: //msdn. microsoft. com/vstudio/products/trial/.

Biz. Talk Tutorial • This Biz. Talk tutorial demonstrates how you can use Biz. Talk Server orchestrations to convert an XML message (a purchase order) into a related, but distinct type of message (an invoice). • This tutorial uses two folders: "In" folder is the pick up folder where input file will be dropped to be picked up by Biz. Talk. And "Out" is the output folder where Biz. Talk will drop the results. • When you place a file, such as the sample file Sample. POInput. xml, into this folder, Biz. Talk Server processes the message using the following steps: 1. Biz. Talk Server retrieves the XML purchase order message from the receive location folder In. 2. The orchestration uses the map file to create an XML invoice from the XML purchase order. 3. Biz. Talk Server places the resulting XML invoice message into the send adapter folder Out. • We will use Microsoft Visual Studio to build a Biz. Talk application to achieve the above solution.

1. Create Biz. Talk Project • Run Visual Studio • From the menu, select File -> New -> Project • Select "Biz. Talk Projects" from the project types listbox • Select "Empty Biz. Talk Server Project" from the templates listbox. • Enter the project name and location and click OK to proceed.

2. Create the Invoice schema • Right click on the project icon in the Solution Explorer window and select Add -> Add New Item. • Select Schema from the templates list box. • Name the schema as Invoice. Schema. xsd

3. Create the PO Schema

4. Create the Map • Right click on the project icon in the Solution Explorer window and select Add -> Add New Item. • Select Map from the templates list box. • Name the Map as POTo. Invoice. btm

5. Create the Orchestration • Right click on the project icon in the Solution Explorer window and select Add -> Add New Item. • Select Biz. Talk Orchestration from the templates list box. • Name the Map as Hello. Orchestration. btm

6. Create Setup. bat to deploy the project and bind the ports to Biz. Talk. @SETLOCAL @CALL "%VS 71 COMNTOOLS%vsvars 32. bat" @SET Solution. Name= Hello. World. sln @SET Assembly. Key. File= Hello. World. snk @SET Binding. File. Name= Hello. World. Binding. xml @SET Send. Port. Name= Hello. World. Send. Port @SET Receive. Port. Name=Hello. World. Receive. Port @SET Receive. Location. Name= Hello. World. Receive. Location @SET File. Receive. Directory=In @SET File. Receive. Location= %File. Receive. Directory%*. xml @SET File. Send. Directory=Out @SET File. Send. Address= %File. Send. Directory%%%Message. ID%%. xml @SET Orchestration. Name=Hello. World. Hello. Schedule @SET Assembly. Name=Hello. World @IF NOT EXIST %Assembly. Key. File% sn -k %Assembly. Key. File% @Dev. Env %Solution. Name% /Deploy Development /Out Build. log @BTSDeploy Import Binding=%Binding. File. Name% Log=Binding @CScript /No. Logo ". . AdminWMIStart Send PortVBScriptStart. Send. Port. vbs" %Send. Port. Name% %File. Send. Address% @CScript /No. Logo ". . AdminWMIEnable Receive LocationVBScriptEnable. Rec. Loc. vbs" %Receive. Port. Name% %Receive. Location. Name% %File. Receive. Location% @CScript /No. Logo ". . AdminWMIEnlist OrchestrationVBScriptEnlist. Orch. vbs" %Orchestration. Name% %Assembly. Name% Start @ENDLOCAL

7. Test the application • • Create a sample XML file to use it as input. Name it Sample. POInput. xml Copy and paste this XML code into the new created file <? xml version="1. 0"? > <ns 0: PO xmlns: ns 0="http: //Hello. World. POSchema"> <PO_Number>1234</PO_Number> <Total>$19. 99</Total> </ns 0: PO> </xml> • • Copy the new file into the In folder. Check the Out folder for results. You should get a new xml file that should look like this: <? xml version="1. 0" encoding="utf-8"? > <ns 0: Invoice xmlns: ns 0="http: //Hello. World. Invoice. Schema"> <Number>1234</Number> <Total. Price>$19. 99</Total. Price> </ns 0: Invoice> </xml>

References • MSDN Library. Microsoft Biz. Talk Server 2004 Introduction. http: //www. msdn. microsoft. com/library/default. asp? url=/library/enus/def/htm/ebiz_def_portal_page. asp • David Chappell. (2004) Understanding Biz. Talk Server. http: //go. microsoft. com/fwlink/? Link. Id=21281