azure integration in production with logic apps and more
TRANSCRIPT
Sponsored & Brought to you by
Azure Integration in Production with Logic Apps and moreAlex Murov & Kelvin van Geene
http://www.twitter.com/AlexMurov
https://nl.linkedin.com/in/oleksandr-murov-a4a31012 https://nl.linkedin.com/in/kelvinvangeene
Azure Integration SolutionLogic apps and more in Production
Who are we?Kelvin van Geene
Worked in IT for 8 years, 5 for Avanade as Integration Consultant
Main focus: BizTalk and WCF
Who are we?Alex Murov
Working at Avanade for 7 years
Main focus: Azure, BizTalk and Custom .Net Development
Avanade• Joint Venture between
Microsoft and Accenture• Founded in 2000• In 23 countries
What will we share with you today?
Azure App Service
API Apps
Logic App
BizTalk Services
Cloud Services
Service Bus (Queues)
AS2 on Azure BizTalk Services
vs Logic App Connector
What will we share with you today?First steps
First Producti
on Product
Implementation
shift
Introduction of Logic Apps
Specific implementation
s
Lessons learned Future
What will we share with you today?First steps
First Producti
on Product
Implementation
shift
Introduction of Logic Apps
Specific implementation
s
Lessons learned Future
What will we share with you today?First steps
First Producti
on Product
Implementation
shift
Introduction of Logic Apps
Specific implementation
s
Lessons learned Future
What will we share with you today?First steps
First Producti
on Product
Implementation
shift
Introduction of Logic Apps
Specific implementation
s
Lessons learned Future
What will we share with you today?First steps
First Producti
on Product
Implementation
shift
Introduction of Logic Apps
Specific implementation
s
Lessons learned Future
What will we share with you today?First steps
First Producti
on Product
Implementation
shift
Introduction of Logic Apps
Specific implementation
s
Lessons learned Future
What will we share with you today?First steps
First Producti
on Product
Implementation
shift
Introduction of Logic Apps
Specific implementation
s
Lessons learned Future
How it all started About 2,5 years ago
How it all started About 2,5 years ago Integration was required between local systems and CRM Online
How it all started About 2,5 years ago Integration was required between local systems and CRM Online
Assumptions: 1. No Custom Development on CRM side2. SAP-PI will be used as on-premise middleware system3. AS2 connection must be used to integrate with SAP-PI4. Costs for development and operations must be kept to the bare
minimum
How it all started About 2,5 years ago Integration was required between local systems and CRM Online Selection fell on Azure BizTalk Services for
realizing of PoC
How it all started About 2,5 years ago Integration was required between local systems and CRM Online Selection fell on Azure BizTalk Services for
realizing of PoC
so we started building…
SAP-PI On-premise
ERP BI Other LOB System
CRM online
CRM Online
HTTPS connection
CRM OrganizationServiceCRM OrganizationService
Azure Cloud
On-premise
CRM Online
SAP-PI On-premise
ERP BI Other LOB System
CRM online
CRM Online
HTTPS connection
CRM OrganizationServiceCRM OrganizationService
Azure Cloud
On-premise
CRM Online
AS2 Agreement BizTalk Services
BizTalk Services
SAP-PI On-premise
ERP BI Other LOB System
CRM online
XML message
CRM Online
HTTPS connection
CRM OrganizationServiceCRM OrganizationService
Azure Cloud
On-premise
CRM Online
Service Bus (Queue’s)
AS2 Agreement BizTalk Services
Service Bus (Queue’s)
BizTalk Services
SAP-PI On-premise
ERP BI Other LOB System
XML message
CRM online
XML message
CRM Online
HTTPS connection
CRM OrganizationServiceCRM OrganizationService
Azure Cloud
On-premise
CRM Online
Service Bus (Queue’s)
XML message
AS2 Agreement BizTalk Services
Cloud Services
Service Bus (Queue’s)
X
Logic App
Logic Apps
Design simple but effective workflow with ease
What are Logic Apps?
Design simple but effective workflow with ease Initiates based on a Trigger on which Actions are taken
What are Logic Apps?
Design simple but effective workflow with ease Initiates based on a Trigger on which Actions are taken Extensible with Custom API Apps
What are Logic Apps?
Why start with Logic Apps? Simplicity / Flexibility
Why start with Logic Apps? Simplicity / Flexibility Most common adapters are already available
Why start with Logic Apps? Simplicity / Flexibility Most common adapters are already available Azure BizTalk Services deprecation
Advantages over Cloud Services Cost efficient
Advantages over Cloud Services Cost efficient Quick to deploy Start and Stop almost instantly
Advantages over Cloud Services Cost efficient Quick to deploy Start and Stop almost instantly Reusability of components
Advantages over Cloud Services Cost efficient Quick to deploy Start and Stop almost instantly Reusability of components Operations Monitoring in portal UI
Disadvantages of Logic Apps Not easy to retrieve information if something goes wrong Formatting of data in web viewer
Disadvantages of Logic Apps Not easy to retrieve information if something goes wrong Formatting of data in web viewer Simple Visual Studio integration (V1, V2 is better) Settings / Configuration management
Disadvantages of Logic Apps Not easy to retrieve information if something goes wrong Formatting of data in web viewer Simple Visual Studio integration (V1, V2 is better) Settings / Configuration management Still in preview, regular changes
Specific implementations
Master data flowMaster data flow
Logic App
Big Data (volume data) Amount of data involved Process flow
Why not use logic apps Long running processes Timeouts on SQL Vo
lum
e D
ata
Repo
rt F
low
Data Warehouse
Web App –1xPer OpCo
WebJob –Process
Accounts
WebJob –Upsert
Account
Service Bus Queue – New
Account Notification
Message
Storage blob –New Account Object
DocumentDB –1x Account per
Staging/Production 1x Collection Per
OpCo
SQL database –Staging /
Production
SSIS
Web App –API App
Windows App
Sales Orders
Sales Orders
Sales OrdersWindows app
App Back-end(CRM Online)
Azure Service Bus queue
Azure Logic App
SAP-PI( on-premise integration platform)
OpCo FTP location
Azure Cloud
on-premise
E-mail to the disctibutor
OpCo FTP location
OpCo FTP location
Message Validation
Message ValidationAp
p to
Azu
re to
SAP
-PI
App
to A
zure
to S
AP-P
I
Sim
ple
Ord
er C
aptu
ring
Inte
rfac
ing
Mas
ter D
ata
from
App
to S
AP-P
IIn
terf
acin
g M
aste
r Dat
a fr
om A
pp to
SAP
-PI
Inte
rfac
ing
Ord
ers t
o on
-pre
mis
e LO
B sy
stem
s
New AccountIn App back-end
(CRM Online)
Send to SAP-PI
Update AccountIn App back-end
(CRM Online)
Send to SAP-PI
Account Create message is send to
Azure via Azure aware plugin
Service endpoint configuration
Does the message for
account create contains
hsem_externalid
Yes
Ignore
No
Any OpCo specific business
rules?
Yes
Process OpCo business
requerments
No
Need to be encoded as
base64 string?For character
specific issues in SAP-PI
No
Yes
Encode to base64 string
Need to be encoded as
base64 string?For character
specific issues in SAP-PI
Encode to base64 string
Yes
No
Is validation On for this Message
Type and this OpCo
No
Yes
Validate and Send Results to SQL Azure
Database
Is validation On for this Message
Type and this OpCo
Validate and Send Results to SQL Azure
Database
Yes
No
New OrdersIn App back-end
(CRM Online)
Send To SAP-PI
Check if Order Headers have
Status @͞Confirmed A͞B
Yes
No
Get complete orders, their order-
lines and distributors from
CRM.
Send orders in one xml batch file to SAP-PI system
Is the distributor @͞E-mail only B͞reachable?
Filter out all orders for @͞E-mail only B͞
and e-mail them to their specified
addresses
Yes
No
Is validation On for this Message
Type and this OpCo
Validate and Send Results to SQL Azure
Database
No
Yes
Future
Multi project Integration SeparationMulti project Integration Separation• Different types of
integration
Multi project Integration SeparationMulti project Integration Separation• Different types of
integration• Multiple development and
operation teams
Multi project Integration SeparationMulti project Integration Separation• Different types of
integration• Multiple development and
operation teams• Different contracts
Multi project Integration SeparationMulti project Integration Separation• Different types of
integration• Multiple development and
operation teams• Different contracts
Full Logic App Implementation
Full Logic App Implementation
