You mentioned: the business processes for CRM1 (Oracle DB) and CRM2 (SQL DB) is different? It depends on whether the management want the data separate or not. If they want it separate due to different business rules, it's quite simple, if CRM1 has a location of Texas and CRM2 has a location of New York, then you integrate the data of both making sure their location is integrated with each. Now when users run a report or access cube, they can filter the data by location. This way, the business processes (business rules / logic) will remain intact, for the respective locations (Texas / New York). If both in same location, then you integrate the data of both making sure their company / business name is integrated with each.