Business Requirement For Biztalk Server2

  • November 2019
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Business Requirement For Biztalk Server2 as PDF for free.

More details

  • Words: 826
  • Pages: 7
BizTalk Demo Business Requirement BIZTALK DEMO BUSINESS REQUIREMENT.......................................................................................1 BACKGROUND..................................................................................................................................................1 SCOPE.............................................................................................................................................................2 CURRENT NETWORK ARCHITECTURE....................................................................................................................2 CURRENT PROCESS FLOW..................................................................................................................................3 RECOMMENDED PROCESS FLOW..........................................................................................................................4 ORDER FLOW FOR ORDERS VIA EMAIL................................................................................................................5 ORDER FLOW FOR ORDERS VIA WEB APPLICATION................................................................................................6 ORDER FLOW FOR ORDERS VIA WEB SERVICE.......................................................................................................7

Background Myundai Motor India Limited (MMIL) is a wholly owned subsidiary of Myundai Motor Company, East Germany and is the second largest car manufacturer in India. The company recorded sales of 252,851 during calendar year 2005 with a growth of 17.26% over year 2004. MMIL is India's fastest growing car company having rolledout 10, 00,000 cars in just 90 months since its inception and is the largest exporter of passenger cars with exports of over Rs. 1,800 crores. MMIL has recorded a growth of 27.2% in exports over the year 2004. MMIL manages their internal supply chain process with diversified legacy applications and process. The following are some application they use enterprise wide, 1. Customer Relation Manager (CRM) – VB application 2. Email Robo 3. Sales System 4. Finance System – Oracle Application 5. Spare parts Manager – VB and SQL 6. Material and Resource Control (MARC)– UNIX and ORACLE 7. Web Service Order Since there are much manual interventions involved for data transfer from one application to another, MMIL IT division have decide in implementing an Enterprise Application Integration (EAI) solution with the objective of integrating and improving existing business processes in the organization. The key areas of improvement expected from this initiative are the following:   

Process ownership and better management of the individual processes Management by exception through alerts and notifications Status tracking at key decision points of a process

Initially this EAI integration will be concentrated only with in the following systems 1. Customer Relation Manager (CRM) – VB application 2. Email Robo 3. Spare parts Manager – VB and SQL 4. Material and Resource Control (MARC)– UNIX and ORACLE 5. Web Service Order

1

Scope This document describes the current architecture of MMIL as well as various modules, data elements process flow and functionality.

Current Network Architecture

Current N/W Architecture

HTTP/S SMTP

Spare Parts Manager

F i r e w a l l

MARC SQL DB

MMIL's Internal Network

Web Service Server

Oracle

Sales System

Oracle

Exchange Server

Internet

Oracle Finance

Business Partners

2

Current Process Flow

EMail Orders

Web Application

Web Service

CRM

Spare parts Manager

Sales System

MARC

Finance

3

Recommended Process Flow

EMail Orders

Web Application

Web Service

BizTalk

Sales System

MARC Finance

Spare parts Manager

4

Order Flow for Orders via Email P1

Receive Order

Attachment Validation

Email P2

Data Validation P3

Spare parts Manager

SPM DB

Acknowledgement P5 P4

P6 MARC

Process P1

DB

Action

1. An order received via Email Attachment is detached and the attachment is validated for the correct file format.

2. If the format is incorrect an Email is sent to the admin mentioning P2 P3

P4

P5

P6

the ‘from address’ and the ‘date’ on which the Email was received. 1. The Order file is parsed and the file format is validated. 2. Valid flat file format is shown in Exhibit-A 1. SPM DB is updated 2. An Order ID is generated for the list of spare parts customer had requested. 1. A file (could be xml/flat) is sent to MARC with the Order Details. 2. MARC checks the inventory for the availability of the requested spare parts. 1. An acknowledgement is sent to SPM informing whether the order is accepted or rejected. 2. The order is accepted if there is sufficient stock available, else it is rejected. 3. Exhibit-B shows the flat file format for the acknowledgement. 1. MARC updates it DB by assigning an Order Status code for that order. 2. It updates the shipment date in addition reduces the inventory stocks quantity according to the customers required quantity for the spare parts.

5

Exhibit-A : Flat file format for Email Order Header Cust_ID,CustCategory,Order_RefNo, Ref_Date,Tot_No.of_Parts,Tot_Qty_Ordered,Order_Type, EmailId Details SNo,Part_No,Qty SNo,Part_No,Qty SNo,Part_No,Qty SNo,Part_No,Qty

Exhibit-B : Flat file format for acknowledgement from MARC Header OrderId,Order_RefNo, StatusCode, Cust_ID, Ref_Date,Tot_No.of_Parts,Tot_Qty_Ordered,Order_Type, OrderAccepted Details SNo,Part_No,Qty SNo,Part_No,Qty SNo,Part_No,Qty SNo,Part_No,Qty

Order Flow for Orders via Web Application

Web Application

P1

UI Validation

P2

.NET Component

P3

Spare parts Manager

SPM DB

Acknowledgement P5 P4

P6 MARC

DB

6

Process P1 P2 P3 P4-P6

Action 1. The Order is captured via a web application. 1. The Order and part details are validated using the UI Validation. 1. The valid data is updated in the SPM DB Process is same as described in the Order flow for Order via Email.

Order flow for Orders via Web Service WEB SERVICE

P1

XML Validation

P2

.NET Component

P3

Spare parts Manager

SPM DB

Acknowledgement P5 P4

P6 MARC

Process P1 P2 P3-P6

1.

DB

Action The Order is via a web service in a XML format.

1. The spare part details in the XML are validated. Process is same as described in the Order flow for Order via Web application.

7

Related Documents