Copying data from On Prem SQL to ADLS with ADF and Biml – Part 1
BimlScript
We were able to write the BimlScript and generate the datasets and pipelines in about 35 hours. A previous ADF project without automation took about 3 hours per source table. If we had gone that route, we could have been looking at 350 – 500 hours to complete this part of the project. Visual Studio with Biml Express took about 5 minutes to generate everything. Deploying to Azure took about an hour. We are now looking into ARM templates for future deployments.
published 05.08.17
last updated 05.08.17
Comments
There are no comments yet.