As Microsoft have accelerated its investment in Dynamics & Azure the latest years a lot of new integrations options are available. Below I’ll try to give you a quick view to some of latest integration offering and also include some of the older options that some have forgotten about. Below integration options are what I have seen being used in most recently implementation in forward looking companies, with use of Microsoft Low-code/No code “integration options”
Batch/Data import/data migration
PowerApps Dataflow it is a self-Serv ETL tool for manual or scheduled batch procession where one can combine multiple data source into one and import into existing entity or have Dataflow generate a Entity that fits the data in first load. https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/create-and-use-dataflows,
Batch/Data import/data migration can be done for most projects with Power platform Dataflows, which have connector multiple connectors to fx. SFDC for easy migration and SAP BW (Application service & Message Server) plus SAP HANA database. Dataflow delivers single threated data load with max of 500000 record pr. Load.
If data is on. Premises a PowerApps On premises gateway are needed: https://docs.microsoft.com/en-us/powerapps/maker/common-data-service/using-dataflows-with-on-premises-data
If more that 500000 records are needed and more speed in data migration/batch Azure Data service it the thing to use. https://azure.microsoft.com/en-us/services/data-factory/
if API integrations are needed (scheduled or data CRUD triggered) Power Automate or Azure LogicApp could be a for fit for purpose. Power Automate now have SAP ECC connector connector for close to no code integration: https://powerapps.microsoft.com/en-us/blog/introducing-the-sap-erp-connector/ and Azure LogicApps still have its integrate connector to SAP https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-using-sap-connector and other enterprise essential connectors like edifact: https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-enterprise-integration-edifact
RPA / Robotics
Power Automate now have RPA functionality. https://docs.microsoft.com/en-us/power-automate/ui-flows/overview. the RPA functionaliy covers both automation for web and Windows application… https://flow.microsoft.com/en-us/blog/microsoft-power-automate-adds-robotic-process-automation-in-april/
RPA automations are often used where the system to integrate to do not have an API or where Business people have a hard time getting IT to prioritize building an automation.
RPA is a shortcut making people more efficient but also a fragile tool as it integrates through the UI.
I often see RPA used where customer have SAP as it is usually expensive to do proper API integration with SAP. You know you need RPA for SAP if you business people need to instruct each other through “email integration” on what to update/create in SAP.
Power Automate have 2 RPA flavors, Attended & Unattended
Attended RPA plan provides the ability for users to run an RPA bot on their workstation. and includes access to several AI Builder capabilities like forms processing, object detection, prediction, text classification and recognition, and more. Attended RPA can have Human step included.
Unattended RPA is the same as Attended it just runs on a service without human view or or human manual steps
Export and Import data to and from Azure Data lake
Enabling a modern Data & AI approach having a pool of unaggregated data from siloed system combined in a enterprise Azure Data lake ready to unleash AI, Machine learning in your business application of choice, Dynamics 365 & PowerApps and as a added bonus this serves well as an data integrator as well
Common Data Service – Virtual Entities
Use Virtual entities for Read-only data coming from OData api and display the data as it was stored within Common data service (CDS). It is usually used for show data(order, Quotes etc.) from ERP system within Dynamics Customer engagement.
Here is a details step by step setup guide https://lystavlenhistoric.home.blog/2017/09/08/virtual-entities/