SSIS ETL or CDC - real time DWH reporting
Have you considered transactional replication? From what I see that would be the best option with the less administrative overhead. 

That way you will have the DB in practically real time and can be relatively easily modified to include more tables in the future. 

https://docs.microsoft.com/en-us/sql/relational-databases/replication/transactional/transactional-replication?view=sql-server-2017