Pluralsight – PaaSport To Paradise Lifting And Shifting With Azure SQL Database Plus SSIS In Azure Data Factory-QUASAR
English | Size: 174.77 MB
Category: TUtorial
Microsoft Ignite 2019 | PaaSport to Paradise: Lifting and Shifting with Azure SQL Database + SSIS in Azure Data Factory | Sandy Winarko
This session focuses on the all PaaS solution of Azure SQL DB/Managed Instance (MI) + SSIS in Azure Data Factory (ADF) to lift and shift, modernize, and extend ETL workflows. We first show you how to provision Azure-SSIS Integration Runtime (IR) – dedicated ADF servers for running SSIS – with SSIS catalog (SSISDB) hosted by Azure SQL DB/MI, configure it to access data on premises using Windows authentication and virtual network injection/self-hosted IR as a proxy, and extend it with custom/open source/third-party components. We next show you how to use the familiar SSDT/SSMS tools to design/test/deploy/execute your SSIS packages in the cloud just like you do on premises. Finally, we show you how to modernize your ETL workflows by invoking/scheduling SSIS package executions as first-class activities in ADF pipelines and combining/chaining them with other activities, allowing you to trigger your pipeline runs by events, automatically (de)provision SSIS IR just in time, etc.
DOWNLOAD:
https://rapidgator.net/file/14a13fe7e33f633b72a377685766dc93/Pluralsight.PaaSport.To.Paradise.Lifting.And.Shifting.With.Azure.Sql.Database.Plus.Ssis.In.Azure.Data.Factory-QUASAR.rar.html
