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