The classic ETL (Extract, Transpose, Load) way. Common tools we use for this are: Informatica, Data Stage, SQL Server Integration Services (SSIS), Python, Talend
Using ODS as a means of collecting data from disperse operational sources. Mostly used when:
There is a need for the integrated data in real-time accuracy.
There are multiple consumers for integrated data (DWH, Web Site, CRM…)
There is a need for complex logic of transformation and integration of data from the different sources (ie: complex master data logic).
Using A Data Virtualization platform. Nogamy is a certified partner of Cisco for its Data Virtualization solution. This solution enables achieving the advantages of an ODS solution but with much more benefits and without the disadvantage of a physical storage layer.