What Types of Data Sources Can Tableau Connect To?

Before you can build those stunning dashboards in Tableau, you need to feed it data. Getting your information into the tool is the first, most critical step in turning raw numbers into business insights. The good news is that Tableau's real power lies in its incredible versatility, it’s designed to connect to just about any data source you can imagine.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

This tutorial will walk you through the various types of data sources you can connect to Tableau. We'll cover everything from simple spreadsheets and flat files to powerful databases, cloud applications, and everything in between.

Connecting to Files: The Starting Point for Many

For many users, especially those new to data analysis, connecting to a file is the most common starting point. This method is straightforward and perfect for one-off analyses or when working with data exported from a system that doesn't have a direct connector.

Flat Files (CSV, TXT)

Flat files are the bread and butter of data exchange. A CSV (Comma-Separated Values) file is simply a text file where values in a table are separated by commas. It’s one of the most universal formats for exporting data.

• Why they're used: Almost every SaaS tool, from your email marketing platform to your project management software, can export reports as a CSV. It's the go-to format for grabbing a quick snapshot of your campaign performance, a list of leads, or user activity logs.
• How it works: In Tableau, you simply select "Text File" from the data connection menu, navigate to your saved CSV file, and Tableau will automatically parse the columns and data types.

Traditional Spreadsheets (Excel & Google Sheets)

This is easily the most popular connection type for business users. Spreadsheets are familiar territory, and many internal business processes still revolve around Microsoft Excel or Google Sheets.

• Microsoft Excel (.xls, .xlsx): You can connect Tableau to an Excel workbook with a few clicks. Tableau even lets you join different sheets within the same workbook, which is incredibly useful for combining related data, like sales figures on one sheet and sales rep quotas on another.
• Google Sheets: The cloud-based counterpart to Excel, Google Sheets, offers a direct connector. The benefit here is that when you update the Google Sheet online, you can simply refresh the data source in Tableau to pull in the latest changes without having to re-upload a file. This is a great way to create a semi-automated reporting process for teams that collaborate heavily in Sheets.

Other File Types

Tableau’s file-based connections don’t stop at spreadsheets. It also natively supports:

• JSON Files: Often used for web data and APIs, JSON is a common format for semi-structured data.
• PDFs: You can pull data directly from tables embedded within PDF documents - a surprisingly useful feature for extracting information from static reports.
• Spatial Files (e.g., KML, Shapefiles): For analysts working with geographic data, Tableau has robust support for spatial files, allowing you to create rich, detailed maps.
• Statistical Files (SAS, SPSS, R): If you’re coming from a statistical analysis background, you can connect directly to files from these popular software packages.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Leveling Up: Connecting Directly to Databases

While files are great for getting started, the real power of analytics comes from connecting to live, structured databases. This is where your company’s core business data usually resides. Connecting directly means you get more current data and can say goodbye to manually exporting files every Monday morning.

Relational Databases

These are the workhorses of the digital world, storing structured data for everything from websites to internal applications. Tableau has deep support for nearly every major relational database, including:

• MySQL
• PostgreSQL
• Microsoft SQL Server
• Oracle
• MariaDB
• Amazon Aurora

When you connect to these, you get access to all the tables, views, and schemas. Tableau's interface makes it easy to drag and drop tables to create joins, relationships, and build a cohesive data model without writing a single line of SQL (though you can if you want to!).

Data Warehouses and Big Data

For organizations dealing with massive volumes of data, traditional databases aren't enough. Data warehouses are optimized specifically for fast querying and analysis, not day-to-day transactions. Tableau thrives in these environments, connecting seamlessly to platforms like:

• Amazon Redshift: A fully managed, petabyte-scale data warehouse service in the cloud.
• Google BigQuery: Google Cloud's serverless, highly-scalable data warehouse designed to handle terabytes of data in seconds.
• Snowflake: A popular cloud-agnostic data platform that scales storage and compute separately.
• Teradata: A long-standing leader in the enterprise data warehousing space.

Connecting to a data warehouse allows you to analyze huge historical datasets to identify long-term trends, run complex customer cohort analyses, and build comprehensive business overview dashboards.

In the Cloud: Connecting to SaaS and Online Platforms

This is where Tableau really shines for modern marketing and sales teams. Instead of the tedious weekly ritual of exporting CSVs from your various platforms, you can connect Tableau directly to the source for live, automated reporting.

Tableau offers native connectors for dozens of popular cloud applications, including:

• Salesforce: Pull your CRM data directly into Tableau to visualize your sales pipeline, track team performance, and analyze lead conversion rates.
• Google Analytics: Connect to your website data to create custom dashboards that go far beyond what GA’s native interface offers. Analyze user behavior, track marketing channel performance, and build full-funnel reports.
• Marketo: For marketing automation, this connector helps you analyze campaign effectiveness, lead scoring, and email engagement.
• Cloud storage services like Google Drive, Dropbox, and OneDrive, allowing you to access files stored in your shared folders.
• Cloud platforms like Amazon Web Services (AWS), Google Cloud Platform (GCP), and Microsoft Azure, giving you access to the host of database and storage services they provide.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

For the Enterprise: Server and Cube Data

In larger organizations with mature data practices, data isn't always accessed from its raw source. It’s often prepared, aggregated, and stored in formats optimized for enterprise-wide reporting.

Connecting to Data Cubes

A "cube" (technically OLAP, or Online Analytical Processing) is a multi-dimensional database optimized for data analysis. Think of cubes as super-charged pivot tables that are lightning fast because the calculations and aggregations are pre-computed. Tableau can connect to services like Microsoft SQL Server Analysis Services (SSAS) and Oracle Essbase. This is a common setup in finance and enterprise settings where query speed and data governance are paramount.

Connecting to a Tableau Server

You can even connect Tableau Desktop to a Tableau Server or Tableau Online. This might sound circular, but it's a key feature for collaboration and data governance. A data analyst can connect to several raw sources, clean and prepare the data, create a standardized data model, and then publish that model as a "Published Data Source" to the server. Other users can then connect their workbook to this single, certified source of truth, ensuring everyone in the organization is working from the same numbers.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The 'Catch-All' Connectors: ODBC and JDBC

What happens when your data source isn’t on Tableau’s long list of native connectors? That’s where generic connectors come in. ODBC (Open Database Connectivity) and JDBC (Java Database Connectivity) are universal standards that act like a translator, allowing applications like Tableau to communicate with a database it doesn’t know by name.

If you're using a more niche or legacy database, an ODBC driver is often available. While it might require a bit more configuration and may not be as performant as a native connector, it provides a powerful fallback that ensures you can connect to almost any database system out there.

A Quick Note on Live vs. Extract Connections

When you connect to a data source, Tableau will typically give you two options: Live or Extract.

• A Live connection means Tableau sends queries directly to your source database every time you load or interact with a dashboard. This is great for real-time data but can be slow if the underlying database is slow or the query is complex.
• An Extract connection takes a snapshot of your data and pulls it into Tableau’s own high-performance data engine. This makes your dashboards incredibly fast. The only trade-off is that the data is only as fresh as your last refresh. You can schedule these extracts to run automatically on a set schedule (e.g., every hour or once a day).

Choosing between them depends on your need for real-time data versus dashboard performance.

Final Thoughts

Tableau's biggest strength is its immense flexibility. It’s built to plug into nearly any system where your company data lives, from a simple Excel file on your desktop to a massive enterprise data warehouse in the cloud. Understanding these different types of connectors is the first step toward unlocking the full analytical power of the tool.

Even with all these connectors, the process of uniting data from multiple sources, understanding their relationships, and building reports can still feel like a full-time job with a steep learning curve. We built Graphed because we wanted to eliminate that complexity. With our tool, you connect marketing and sales sources like Google Analytics, Shopify, and Salesforce in seconds, then simply ask for the reports you need in plain English. There’s no need to learn how to manage extracts or configure complex data models - just describe what you want to see, and our AI data analyst builds real-time dashboards for you, turning hours of tedious work into a 30-second conversation.