ETL with Azure Cookbook

ETLisoneofthemostcommonandtediousproceduresformovingandprocessingdatafromonedatabasetoanother.Withthehelpofthisbook,youwillbeabletospeeduptheprocessbydesigningeffectiveETLsolutionsusingtheAzureservicesavailableforhandlingandtransforminganydatatosuityourrequirements.Withthiscookbook,you’llbecomewellversedinallthefeaturesofSQLServerIntegrationServices(SSIS)toperformdatamigrationandETLtasksthatintegratewithAzure.You’lllearnhowtotransformdatainAzureandunderstandhowlegacysystemsperformETLon-premisesusingSSIS.LaterchapterswillgetyouuptospeedwithconnectingandretrievingdatafromSQLServer2019BigDataClusters,andevenshowyouhowtoextendandcustomizetheSSIStoolboxusingcustom-developedtasksandtransforms.ThisETLbookalsocontainspracticalrecipesformovingandtransformingdatawithAzureservices,suchasDataFactoryandAzureDatabricks,andletsyouexplorevariousoptionsformigratingSSISpackagestoAzure.Towardtheend,you’llfindouthowtoprofiledatainthecloudandautomateservicecreationwithBusinessIntelligenceMarkupLanguage(BIML).Bytheendofthisbook,you’llhavedevelopedtheskillsyouneedtocreateandautomateETLsolutionson-premisesaswellasinAzure.