In the following blog post’s we will implement a scenario and check how it behaves with and without Integration Service Environment.
We would be focusing on the below points
- Implementation Approach
- Execution time
- Challenges faced etc.
Artifacts Used – VNet, Subnet, SQL Virtual Machine, Logic Apps, Integration Service Environment, On-Premise Data Gateway
Scenario – An XML file with repeating records (50 records)will be fetched for the File Share, De-batched and individual records will be send across to a SQL Table.
Approach 1 – Without Integration Service Environment (ISE)
This approach was quite straight forwards and did not face much challenges.
- Created a VNet/Subnet
- Create SQL Server VM and added it to my default subnet
- Installed On-Premise Data Gateway
- Created a file-share, SQL Database and Table on that VM
- Logic App (de-batch and insert individual file to SQL table)
The input XML will look like below with 50 Customer Information.
Ursprünglichen Post anzeigen 296 weitere Wörter