Building a Leave Application Workflow System using BizTalk Server 2006 and SharePoint Server 2003: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
Building a Leave Application Workflow System using BizTalk Server 2006 and SharePoint Server 2003

page 1 of 7

Published: 23 May 2006

Unedited - Community Contributed

Abstract
In this article Naveen demonstrates how to create a simple workflow system using BizTalk Server 2006 and Sharepoint portal server.

by Naveen Karamchetti
Feedback

Average Rating:

Views (Total / Last 10 Days): 40563/ 281

Article Contents:

Introduction

This article describes how to design and develop simple workflow systems using BizTalk Server and SharePoint Server. InfoPath is also used for editing XML documents.

Human Workflow – what does it mean?

A Workflow is a movement of a document or a task across several people. In a human workflow several humans communicate using a business process. This business process is implemented as a workflow. For example, an article (document) could be routed to several people for a review in a publishing company. In this article we shall consider a “Leave Approval Workflow.” This leave application raised by the employee is routed to the manager and the boss for their input or approval.

Role of BizTalk, SharePoint and InfoPath

BizTalk Server 2006: BizTalk is used to compose the workflows and determine the routing of the documents. It is also used to make database related changes pertaining to the workflow.

SharePoint Server 2003: SharePoint is used as a repository for the leave application documents. It also consists of several views for BizTalk to pickup the right kind of documents.

InfoPath 2003: InfoPath 2003 is used for editing XML instance documents from the XML schemas.

Target Audience

This article uses BizTalk 2006, SQL Server 2005, Visual Studio 2005, SharePoint Server 2003 and InfoPath 2003. It is expected that readers of this article have considerable working experience in these products.

View Entire Article

(Page 2) »

Article Feedback

Comment:
Title:
Name:
Url:	( Optional )

Please add 5 and 7 and type the answer here:

User Comments

Title: Workflow
Name: rajendra
Date: 10/26/2009 2:07:04 AM
Comment:
Great one.

Title: Request for simple Leave Application Management System
Name: Zanele
Date: 5/8/2009 9:07:50 AM
Comment:
Hi,
Could you please provide me with an up and running above mentioned system but not the executable because I need to view the databases as well as the coding. Thak you.

my email address: ngcobozanele1@yahoo.com

Title: How to install in WSS 3.0
Name: Jeff Cheung
Date: 10/23/2008 11:42:07 PM
Comment:
Hi,
May I know that how to install the download file in WSS 3.0?
Would you please send me a simple instruction for it? Thanks a lot.

My email address is : jeffcheung@lexibook.com

Title: Request for simple leave application without using sharepoint.
Name: kumaran
Date: 10/1/2008 1:33:48 AM
Comment:
Hi,
Can you provide sample of simple leave application without using sharepoint and infopath ?
Say for example Employee can raise a leave appliation through website and the leave application routed to manager for his approval. Manager login in site and check is workitems. He may approve or reject like.
It's simple and straightforward to understand.
Regards,
kumaran

Title: Nice but need Help
Name: Arun
Date: 9/1/2008 1:24:20 AM
Comment:
Nice Article. But my task is to develop the same within Sharepoint but not with BizTalk. Could you please guide me with this to develop the same simpler and easy in Sharepoint portal
My email id is: arunbalait@aim.com, arunbalait@hotmail.com

Title: Development of BizTalk application
Name: Mike Wassermann
Date: 8/1/2008 4:26:14 PM
Comment:
I need a little help with the Sharepoint side of the article, I don't have any experience with Sharepoint and don't understand how to configure the sharepoint stuff to get the BizTalk stuff to work. Any detail steps on setting up sharepoint to get the code to work will be helpful.

Mike

Title: Deployment of Biztalk application
Name: Ranjeet
Date: 5/12/2008 10:55:07 AM
Comment:
hi
how can we coneect Biztalk application to C# application. please help me. i m new in biztalk server2006.

Thanks in aadvance

Title: simplified Sample Application in BizTalk Server 2006
Name: Ranganath
Date: 4/23/2008 7:04:59 AM
Comment:
HI,

This is the First Time i am learning the BizTalk server 2006.

I want simplified sample Application in it.

i.e. Step By Step

Title: Good Example
Name: Guru Raam
Date: 3/4/2008 7:12:56 AM
Comment:
Hi,

I'm new to BizTalk, this example is very useful to me.

Thanks

Title: Error
Name: Nikunj R
Date: 6/16/2007 4:45:39 AM
Comment:
After deployment i stuck with following error ,
event id:5753
when putting .xml file receive location i got the error:
The published message could not be routed because no subscribers were found. This error occurs if the subscribing orchestration or send port has not been enlisted, or if some of the message properties necessary for subscription evaluation have not been promoted. Please use the Biztalk Administration console to troubleshoot this failure.
My email id is:nikunj_18july@yahoo.co.in

Title: Regarding Leave Sample
Name: Nikunj R
Date: 6/16/2007 3:21:52 AM
Comment:
I am very impress with your comment, i wants to know how to set sharepoint connection in application
mi id: nikunj_18july@yahoo.co.in

Title: Help needed
Name: Malathi
Date: 3/24/2007 12:31:56 AM
Comment:
I am new to Biztalk and I tried to launch this leave work flow system, but not able to lauch successfully, Can you please help me to launch this? I restored the database, created the infopath template but not able to build and deploy the application. It would be nice if you give me the step by step instruction to launch this.

Thanks in Advance

Regards

Malathi

Title: Implement Leave Request Case Study
Name: Pouyan
Date: 11/22/2006 7:26:30 AM
Comment:
Hopfully i could use this case study and after struglying a lot i could configuring and launch the system. Thank you very much to provide this title.
If any one faces a problem to use this sample i can share my experiences with him. Contact me by this E-Mail:
PSepah@Yahoo.com

Title: Business process development stages
Name: Jon
Date: 11/7/2006 9:58:03 AM
Comment:
Very entertaining issue. I haven't heard of this one. It will be necessary to visit you on a thicket!

Title: Good work
Name: Harry Tsavdaris
Date: 11/4/2006 5:59:05 PM
Comment:
I am new in Biztalk and Sharepoint and you example is very useful.
Thanks.

Title: Need more details how to run the sample solution
Name: Abhijit Mahato
Date: 11/1/2006 2:37:40 AM
Comment:
Hi,
This article is really very good. From last couple of months i was just searching any article about the integration of BizTalk and Share point server. Actually i am using BizTalk 2004 and Sqlserver 2000. Could you please provide me some more details about this, so that i can use it.

Thanks in advance
Abhijit Mahato
email : abhi_dev2@rediffmail.com

Title: How to Deploy
Name: Pouyan
Date: 10/9/2006 3:13:21 AM
Comment:
I still try to use your sample. I am new in using Biztalk and visual stuadio 2005. Would you plesae provide me a little more detail document to deploy your sample on my computer? I have the following questions:
1-How can i edit the Sharepoit connection ?
2-How can i add the "DBLIB.EMPLOYEEUTIL" variable (When i start to Deploy i get SQL-Connection Error)
By the way i installed SQL-Server 2005 and Sharepoint and it seems there is no problem to use your sample.
Thanks a lot in advance.
Pouyan
E-Mail: pouyan.sepahvand@asiacell.com

Title: SQL-Server Problem
Name: Pouyan
Date: 10/7/2006 7:47:40 AM
Comment:
Dear Naveen Karamchetti,

I am very interested in to you your sample. Actually i am new in using BizTalk. My problem is to use SQL-Server with SP4 instead of SQL-Server 2005. Are there any way to use this sample by SQL-Server2000. I couldn't restor SQL-Server backup file.

All the best
Pouyan

Title: Workflow
Name: Steven
Date: 5/30/2006 1:28:45 AM
Comment:
Workflow using BizTalk has been explained very well in this article. Unfortunately BizTalk HWS for workflow is complicated to use, and hence this could be the best way.

Title: Good
Name: Ram Potturi
Date: 5/26/2006 11:30:30 PM
Comment:
Thank you very much for good article.
Thanks,
Ram

Product Spotlight