Looking for advice on how to integrate data from 100+ client DB's into a centralized reporting database
Do we need to consider replicating each database individually and then perhaps use some sort of data virtualization technique to combine data from the various replicated sources?


Yes.  You can host multiple subscriber databases on a single instance, and then query across them with views, or load them into a consolidated database.