I have two databases on Microsoft SQL Server (daily business activities performed) and also on peachtree and on orange human resources software. I want to build a data warehouse with this databases available. My questions are:

i. Where can I integrate all these databases together

ii. After I integrate, how can I mine this data?

iii. What is the best software to use and mine this data?

iv. Can combining all these databases produce insight for making business decisions after mining?

Please, really need your help and suggestions.

Thank you.