Myriad of inputs from ancient on-prem FTP and mainframe to data uploaded to Azure Storage containers. Azure Data Factory migrating all inputs to Azure Data Lake

Myriad of inputs from ancient on-prem FTP and mainframe to data uploaded to Azure Storage containers. Azure Data Factory migrating all inputs to Azure Data Lake(s). Different visualization tools for on-prem and cloud. On-prem is a messy turd of BOBJ (barf!), custom CGI scripts, SAS generating html/emails/etc. Tableau and PowerBI for other things. Nothing cohesive.