PaaSport to paradise: Lifting and shifting with Azure SQL Database + SSIS in Azure Data Factory

%3CLINGO-SUB%20id%3D%22lingo-sub-865554%22%20slang%3D%22en-US%22%3EPaaSport%20to%20paradise%3A%20Lifting%20and%20shifting%20with%20Azure%20SQL%20Database%20%2B%20SSIS%20in%20Azure%20Data%20Factory%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-865554%22%20slang%3D%22en-US%22%3EThis%20session%20focuses%20on%20the%20all%20PaaS%20solution%20of%20Azure%20SQL%20DB%2FManaged%20Instance%20(MI)%20%2B%20SSIS%20in%20Azure%20Data%20Factory%20(ADF)%20to%20lift%20and%20shift%2C%20modernize%2C%20and%20extend%20ETL%20workflows.%20We%20first%20show%20you%20how%20to%20provision%20Azure-SSIS%20Integration%20Runtime%20(IR)%20%E2%80%93%20dedicated%20ADF%20servers%20for%20running%20SSIS%20%E2%80%93%20with%20SSIS%20catalog%20(SSISDB)%20hosted%20by%20Azure%20SQL%20DB%2FMI%2C%20configure%20it%20to%20access%20data%20on%20premises%20using%20Windows%20authentication%20and%20virtual%20network%20injection%2Fself-hosted%20IR%20as%20a%20proxy%2C%20and%20extend%20it%20with%20custom%2Fopen%20source%2Fthird-party%20components.%20We%20next%20show%20you%20how%20to%20use%20the%20familiar%20SSDT%2FSSMS%20tools%20to%20design%2Ftest%2Fdeploy%2Fexecute%20your%20SSIS%20packages%20in%20the%20cloud%20just%20like%20you%20do%20on%20premises.%20Finally%2C%20we%20show%20you%20how%20to%20modernize%20your%20ETL%20workflows%20by%20invoking%2Fscheduling%20SSIS%20package%20executions%20as%20first-class%20activities%20in%20ADF%20pipelines%20and%20combining%2Fchaining%20them%20with%20other%20activities%2C%20allowing%20you%20to%20trigger%20your%20pipeline%20runs%20by%20events%2C%20automatically%20(de)provision%20SSIS%20IR%20just%20in%20time%2C%20etc.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-865554%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBRK3209%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-983692%22%20slang%3D%22en-US%22%3ERE%3A%20PaaSport%20to%20paradise%3A%20Lifting%20and%20shifting%20with%20Azure%20SQL%20Database%20%2B%20SSIS%20in%20Azure%20Data%20Factory%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-983692%22%20slang%3D%22en-US%22%3EStream%20broken%3F%20Can't%20load.%3C%2FLINGO-BODY%3E
Highlighted
Community Manager
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.
1 Reply
Highlighted

View this session in the session catalog

View session