Business Intelligence

1
?????????? ??????-??????? ? ??????????????
Microsoft BizTalk Server 2004
??????? ?????? ?????????? ?????????????? ??????
2
????????

• ???????? ??????? ? ????? ??????????
• ????? ???????? Microsoft BizTalk Server
• ???? Microsoft SQL Server ? ??????????? ???????

3
???????? ??????????
4
??? ????? ?????????? ??????-????????
?????????? ????????????? ?????????? (EAI)

• ???? ??????????
• ?????????? ??????
• ???????????? ?????????
• ?????????????

????????????? ??????-????????? (BPM)
Business-to-Business
5
??????????? ?????-?????

• ???????????
• ??????????????????
• ????? ?????? ??????????
• ????? ?? ????????? (?? ??????)
• ??????????
• ????????? ??????????
• ????????? ?????????
• ????????? ??????????? ??????? ?????????? ??????

ERP
OrderEntry
Purchasing
Marketing
Financial Systems
CRM System
SCM System
6
????????????? ???? ??????

• ???????????
• ????????????? ??????????? ? ?????????? ?????????
• ?????????????? ??????????
• ????????????? ???????? ??????????
• ??????????
• ????????? ?????????????? ??
• ????? ??????? ????????? ??????????????
• ??????? ??????? ? ?????????? ??????????????
  ??????????

ERP
Purchasing
OrderEntry
Marketing
????
Financial Systems
CRM System
SCM System
7
??? ????? BizTalk Server?

• BizTalk Server ??? ????? ???????????? ???
  ??????? ???????? ????? ?????
• ?????????? ????????????? ?????????? (EAI)
• ??????? Business to Business (B2B)
• ?????????? ??????-?????????? (BPM)

8
??????? ????????

• BizTalk Server 2000
• BizTalk Server 2002
• BizTalk Server 2004

9
BizTalk Server 2004 ????? ????????
???????? A
BizTalk Server

• BizTalk Server 2004 ????????
• ?????????? ?????????
• ?????????? ?????? ???????????
• ???????? ?????????? ? ???-?????????
• ????????? ??????-??????
• ??????? ??????? ????? (Single sign-on)
• ?????? ??????????? ? ???????
• ?????????? ???????? ??????????

??????????
??????????
??????????
Internet
???????? ?
??????????
??????????
10
??????????? ???????
???? ?????????????
????????? ??????????
??????
?????????????
??????????????
???????? ??????????
11
??? BizTalk ???????????? ?????????
XML,Flat File
1
Receive Location
ReceiveAdapter
ReceivePipeline
XML
Message Database
12
????????? ?????????
XML orFlat file

• ??? ????????? ????????? ?????????? ?????????
  ???????? (receive location)
• ????????? ? ?????????? ??????????? ????????????
  ????????? ???????????????
• ????????? ???????? ????????? ?????????? ?
  ??????????? ?????? (pipeline)
• ????? ???? ????????? ??????????? ? ??

Receive Location
ReceiveAdapter
ReceivePipeline
Message Database
13
??? ????? ????????

• ????????
• ?????????? ??????? ?????? ? ????? ??????
• ??????? ?????????? ??? ??????? ????

????????
Financial System
SCM

• ?????????? ????????
• ?????????? ? ??????-????????????
• ?????????? API
• ??????????????? ????????
• ?????????? ?????????? ?? ?????? ?????????
• ??? ??????????, ?? ??????? ??????????? ???????????

Mainframe
Database
ERP
CRM System
14
BizTalk Server 2004 ?????????? ???????? ?
?????????????? ?????????
??????? ????????
EDI ????? ??????????? ? ?????????, ??????????????? ?????? ???????????? ?????? ??????? (EDI)
File ???????? ????????? ? ?????????????? URI-????
HTTP ?????/???????? ????????? ? ?????????????? URL
FTP ????? ??????????? ? ???????????? ? ??????? ?????????
MSMQT ???????? ????????? ??? ?????? ?????????? MSMQ ???????? ??????????????? ????????
SMTP ???????? ????????? ?? ????????? ?????????
SOAP ???????? ????????? ????? ?????? ??????? ???-????????
SQL ?????? ????? ??????? ? ???? MS SQL Server
15
?????????????? ???? ???? ??????
??? ????? ????????
XML ?????????????? ?????? ???? XML-????????? ??? ???????? ???????????? XSD
Flat File ????????? ??????????? ?????? ? ?????? ? ????????????
Property ??? ????? ??? ?????? ???? ?????????? ???? ?????, ??????????? ? ???? ?????? ? ?????????????? ????? ???????? ??????????? ????????? ??????????? BizTalk
16
?????????????? ??????

• ????? ?????????????? ? BizTalk
• ????????? ???????????? ??????? ? ????? ????
  ?????? XML-????
• ???????????? ??? ?????????????? ? ????????????
  ??????
• ????????? ??? ?????? BizTalk Mapper
• ????????????? ? ???? XSLT

XSLT Map
???????? ?????
???????? ?????
Order
PO Number
Date
Quantity
Item No
Status
Date
17
??????? ??????????????

• ?????????? ?????????? ? ?????? ???????? ???
  ???????
• ?????? ?? ?????? ????????? ?????????????
  ??????????? ? ?????? ? ???????? ??????????

XSLT Map
???????? ?????
???????? ?????
Order
Char to Numeric
PO Number
PO
Status
DateTime
ItemID
Item No
Time
Weight
Qty
OrderStatus
UnitPrice
Sum
Total Amt
Date
18
????????????? ??????????

• ???????? ???????? ?????????? ???????? ???
  ??????? ??????????????? ? ???????? ??????????????

• ????? 70 ?????????? ??????????
• ?????????? ? ????????? ??????
• ????????? ???? ? ???????
• ???????????? ???????? ?????
• ??????? ??????????????
• ??????????? ?????????
• ??????????? ????????????? ???????
• ??????????? ????????????? ??????????????
  ????????? ??????????
• ????? ???????????? Visual Basic, C, Jscript ???
  XSLT

???????? ?????
???????? ?????
Order
(..)
PO Number
Date
Item No
Quantity
X
Order Status
Total Price
Functoids
19
??????? ??????

• ????????? ? ????? ??????? ????????????? ?
  ????????? ? ??????
• ?????? ???????? ???? ??????????? ? ?????? XML
• ??? ???????? ????????? ????? ? XML ??????????
  ??????????

XML
???????? ??????
lt?XML version 1.0?gt ltEmployeegt ltFNamegtBenlt/FNa
megt ltLNamegtSmithlt/LNamegt ltEmpNogt4521lt/EmpNogt ltDept
gtSaleslt/Deptgt
???????
Ben, Smith, 4521,Sales
?????????? ??? ????, ??? ??????, ?????? ? ?.?.
20
???????? ? ???????? BizTalk
Port Surface ltlt
gtgt Port Surface

• ???????? ????????? (orchestrations)
• ?????????? ????? ??????????
• ????????????? ????? ???????????? ???
  ????????????? ??????-?????????
• ?????? ??????-???????? ????? ???? ????????? ???
  ??????????? ??????????

Receive PO
ReceivePOPort Operation_1 -gt Request
Check Quantity
Denied
Else
Send_Approve
Denied Msg
SendApprvPort Operation_1 -gt Request
!
Transform
SendDeniedPort Operation_1 lt- Request
Send_Denied
??????????? ????????

• BizTalk Orchestration
• ????? ??????? ??????????
• ????????? ?????? ??????-?????????

21
??? ???????? ????? BizTalk Orchestration
?????? Orchestration

• ??????? ?????????? ?????????
• ?????? ?????? ? ????????? ???? ????????? (? ??
  SQL)
• ????????? ??????????? ????????
• ???????????? ?????????? ??? ?????????? ?
  ??????????? ?????????????? ??????????

Dehydrate
Rehydrate
MessageBox
22
?????? ? ?????????? ?????????
gtgt Port Surface
Port Surface ltlt
Receive_PO
???? ?????????? ??????
CheckQuantity
Denied
Else
???? ?????????? ??????
Const_Denied
Send_Approve
SendApprvPort Operation_1 -gt Request
Transform_1
SendDeniedPort Operation_1 lt- Request
?????? ????????????
???? ??????????????
23
????? ? ?????????? ???-????????

• ????? ???-???????
• ???-?????? ????? ???? ?????? ?????????? ????????
  
• ??? ????????? ?????????? ? ??????? ????????????
  UDDI
• ?????? ??????, ???? ??????-??????

????????
Web Service

• ?????????? ????????
• ?????????????? ?????????? ???????
  ???????-????????
• ???????? ????? ?????????????? ? ???????-???????
• ??? ?????????? ???????????? WSDL
• ???????? ?????? Web-???????

????????
Web Service

• ?????????? ?????
• ?????????????? ?????????? ??????? ? XML-?????
• ????? ????? ??????? ??????? ? ???????
• ?? ????????? ? ????????

?????
Web Service
24
?????????? ?????????? BizTalk
Health and Activity Tracking (HAT)

• ????????
• ?????????? ????????? ? ?????
• ????????, ????????? ? ????????????? ?????????
• ???????? ?????????
• ?????????
• ????? ?????? ??????????????
• ????????? ?????????????

?????????????????
25
???????????? ?????????

• ???????????? ??????? ? ????????? ?????
• ???????????? ???????? ? ????????? ?????????
• ???????????? ??????????? ????????? ????? ?????? ?
  ????????
• ???????? ???????? ??? ??????????? ????????????
  ???????????

26
????????????? Business Rules

• ?????????? Business Rules
• ????????? ??????-???????? ?? ????????
  ??????-??????????
• ????????? ????????????? ??????-?????? ? ?????????
• ???????????? ???????????? ?????????? ?????? ?
  ???????
• ????????????? ??????????? ????????? ???
  ?????????? ??????

?????????? Business Rules
????????
Business RulesEngine
Business RulesComposer
27
??????-??????? (Business Rules)

• Business Rules
• ???????, ???????? ?? ??? ??????????
  ??????-?????????
• ???????????? ????????? ?????? ?? ??????????
  ??????
• ???? ??????-????????????? ???????? ???
  ???????????
• ????????????
• ?????????? ??????? ??????????
• ??????? ??????? ?? ?????????
• ??????????? ?????????? ?????????????
• ???????? ????????? ?????????? ? ????????

Rules
Rules
Rules

• ??????? ??????-??????
• ??????????? ?????? 6.5
• ?????? ?????? ?? ???? ?????? - 20
• ?????? ?? ????? ????? 250k ?????? ???????????? ?
  ?????????? ????? ??? ???????????

28
???????? ??????-??????
????????

• ???????? ?????? ????????
• ???????? ???????????
• ???????? ???????
• ?????????? ???????? ? ???????

???????
???????? ??????
???????????
29
??? ????? BizTalk Host?

• BizTalk Host
• ?????????? ????????? ???????? BizTalk Server
• ???????????? ??? ????????????? ???? ???????
• ????? ?????????????? ??????? ?? ????????

Host A
Host A
Host B
??????? ??????
????????? ????????? ??????
????????? ????????
???????? ????????? ?????
Host C
30
???????????????? ???????
?????? B
?????? C
?????? A
Host
?????? D
???????
??????????????
31
???????????????? ???????
?????? A
?????? B
?????? C
?????? D
Host
???????
??????????????
MessageBox
?????? H
MessageBox
32
???????? ??????????? ????????????
??????? ?????????????
?????????????? ???????? ?????? (PKI) ?????????????? ? ?????????? ??????, ???????????? ??????-?????????? ???? ?????
??? ??????????? ??????????? ???????? ????????? ??????????? ????????? ?????????
?????????? ? ??????? ???????????? ??????????? ???????? ????????? ?????????? ????????? ?????????
S/MIME ??????????? ???????? ????????? ?????????? ????????? ?????????
Integrated logon ?????????????? ????????????? Windows
Kerberos ?????????????? ????????????? ????????
Secured Sockets Layer ?????????? ????? ??????? ?? ????????? HTTPS
???? SQL Server ???????? ??????? ?????????????? ?????? ??????????? ??????????
????????? ???????????? Windows ???????? ???????? ? ???????? ?????? ??? ??????? ?? ??????????? BizTalk Host
33
????????? Microsoft ??? ???????????????????-?????
????
34
?????????????? EAI
BizTalk Server 2004 Engine
Orchestration
4
?????????? ??????
1
???????? ??????
2
3
?????? ????? ??????
????????? ????? ??????
??????? ???????? ?????????
??????????? ???????
35
?????????????? B2B
????????
??????? ?????????? ?????????
Internet
????????? A
????????? B
??????? ???????? ????????
ERP ???????
36
????????? ??????????

• http//www.microsoft.com/BizTalk
• BizTalk Server 2004 Newsgroups and Blogs
• http//www.microsoft.com/BizTalk/community/newsgro
  ups
• BizTalk Server 2004 Community
• http//www.microsoft.com/BizTalk/community
• Sites of Interest
• http//www.topxml.com/b2b/
• http//www.gotdotnet.com/team/entservers/

37
????????
38
?????????? ??????-??????? ? ??????????????
Microsoft BizTalk Server 2004
??????? ?????? ?????????? ??????????????
?????? E-mail SZelenov_at_croc.ru