Systems and methods are provided to aggregate and analyze data from a plurality of data sources. The system may obtain data from a plurality of data sources. The system may also transform data from each of the plurality of data sources into a format that is compatible for combining the data from the plurality of data sources. The system uses a metadata-based data mapping template to match fields from one database system to the other. The system can generate and publish master data of a plurality of business entities.