Desktop files, databases, warehouses, Hadoop, cloud data, or cubes. Tableau is data analysis software that allows you to work with your data no matter where it lives.
The reality of business today is that no organization has data in a single place. Heterogeneous environments are the rule; exceptions to it are hard to find. You need the ability to analyze data wherever it lives to get the answers you need. Make sure your business intelligence solution can handle your data, everywhere.
Where does your data live? Chances are it has many homes. When you can access multiple data sources in one place, you can use one tool for all of your data analysis.
Tableau has native connectors to many common databases, such as Microsoft SQL Server, MySQL, Teradata, Oracle, EMC Greenplum, HP Vertica, and more. These native connectors:
- Are optimized to increase performance
- Leverage the particular capabilities of each data source
- Honor and enforce security protocols
If a native connector is not available, you can still use the ODBC (Open DataBase Connectivity) protocol to access your data.
Sometimes you want to connect live to your speedy database and get up-to-the-second changes . Sometimes you want to bring data in-memory to work faster, go offline, or take query load off critical systems. You should have the choice to work with your data the way you need to.
Tableau provides an optimized, live connector to many data sources so you can work directly with your data. But if your database is already under heavy load, you can take the burden of analysis off of it with Tableau. Tableau’s fast Data Engine lets you bring your data in-memory, meaning you can get the data you need and answer your questions without overloading your database.
Product data in a warehouse? Finance data in a database? No problem. Connect to both and blend the data. Now you can start to relate product characteristics and costs to sales by segment and location. Combine maps, trend lines and scatter plots in a dashboard to get the full picture.
Tableau makes it easy to add new data sets –from another Excel workbook, a database, or flat files– and automatically blends them using common fields. Check out this short video that demonstrates the speed and ease with which you can blend data from different sources.