Application Integration Solution using BizTalk, XML, ASP.NET, Web Services, Microsoft.NET, SQL Server

Company > Clients > Application Integration System Cisco Systems and WorkplaceIQ, Inc

Cisco Systems, Inc. is the worldwide leader in networking for the Internet and WorkplaceIQ is a technology solutions provider for the real estate industry. We integrated applications for Cisco Systems and WorkPlaceIQ by accepting and manipulating XML documents (related to property management), Web Services and Microsoft BizTalk Server.

The project had two main functions: Import and Export. Import covers all steps needed to receive documents from Cisco, process/map documents and access web services to update the property management system. Export covers all steps needed to access web services to extract data out of the property management system, split them into single-record documents and route them to Cisco.

Both Import and Export rely on a number of custom components that work with BizTalk Server and Microsoft.NET web services to process and route XML data. These components are as follows:

ASP.NET web pages to receive documents
BizTalk Application Integration Component that acts as an adapter between BizTalk Server and web services
Web Service proxy component that communicates with the web service
Microsoft.NET based Export Application that runs at scheduled intervals to export data using web services
XML Splitter component that converts exported XML documents into single-record XML documents

The system accepted incoming XML documents through ASP.NET pages from WebMethods and routed them to BizTalk Server for processing based on various criteria configured in the SQL Server database. We configured BizTalk to map incoming documents to desired formats. We created components to call web services to parse the documents mapped by BizTalk Server and insert data in the database. We created COM+ components to call web services and transmit/receive XML documents.

Processes Overview: