azure integration in production with logic apps and more

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

In closingKelvin.van.geene@avanade.com

omurov@gmail.com@AlexMurov