Synchronizing Tables from Multiple Azure SQL Databases Using Azure Data Factory

Currently facing a challenge involving two different Azure SQL Servers, each containing 4-5 databases. The goal is to select specific tables from each database and synchronize them into a single Azure SQL Database to serve as a data warehouse for reporting purposes.

It’s important to note that some tables have the same schema and names. Looking for a solution using Azure Data Factory (ADF) that allows renaming these tables during the synchronization process through transformation. Any guidance on how to achieve this would be greatly appreciated.