After posting 'Data Vault methodology', I found a webpage that says Data Vault is not the ideal technology to use. 
Rather stick with Kimball.

You mentioned: 
We are a company doing surveys with different kind of questionnaires. There is a company in Mumbai (MySQL) specialized in Type 1 questionnaire and one in Peru (SQL-Server)...

I think that's where the Data Vault methodology helps. 
https://www.talend.com/blog/2015/03/27/what-is-the-data-vault-and-why-do-we-need-it/   
https://danlinstedt.com/solutions-2/data-vault-basics/      
https://www.snowflake.net/data-vault-modeling-and-snowflake/

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...

Hi Sue_H, I eventually installed MDS on Windows Server. 
For the web configuration (I selected create new website), entered computername\username (I used a local account on

November 1, 2017 at 2:24 pm

#1966315