Some BI tools can connect to multiple databases, however the right solution is to put all your data into a single data warehouse and run the analysis off of that. Query performance is one reason, and here's a blog post I've written with some more:

http://dataducketl.com/blog/every-tech-company-needs-a-data-...