RE: Integration in D365FO
see if this link helps
community.dynamics.com/.../data-based-or-event-based-integration-options-with-microsoft-dynamics-365-finance-and-operations-one-version
• For data based
â—‹ Excel
â—‹ OData
â—‹ Custom services
â—‹ Recurring integration/QuartzAX
A self-hosted solution that can import/export files to/from Operations
Pros
Easy to configure
Easy to use
Free
Cons
Manageability
Scalability
Error handling and real time alerts
Dual scheduling
â—‹ Logic apps
IPaaS
Cloud and on premise connectors
Light up other Azure services
Operations connector available
CRUD
Execute action
Generic HTTP connector
Enqueue/Dequeue/JobStatus/Ack
Enterprise Integration Pack – B2B workflow
Preferred way to interact with recurring job
Pros
Scalability
Manageability
Guaranteed delivery
Error handling
Real time alerts
Cons
Not free
Only available in the cloud
â—‹ Flow
No Azure subscription needed
Citizen integrators
Flow is built on top of Logic Apps
They have the same workflow designer
Connectors that work in one can also work in the other
â—‹ PowerApps
â—‹ CDS-T
â—‹ CDS-A
â—‹ BizTalk
â—‹ Azure Service Bus
â—‹ Azure blob
â—‹ SharePoint online
â—‹ OneDrive for business
â—‹ MS connectors between D365FO and other D365 products
â—‹ PowerBI
• For event based (using events)
â—‹ Business events in 10.0
â—‹ Flow