I am looking for a database client that can access data from multiple sources. We use Tableau (http://www.tableau.com
) for data visualization and it is able to use many different data sources at the same time. For example, I can grab data from MSSQL, MySQL, DB2, Excel, and a CSV file and tie them all together.
Basically, it queries the multiple data sources, builds a local table with the data, and then blends the data sources locally.
Does anyone know if there is a text-based client that can do this? I cannot used linked sources and have no administrative rights on the database servers.