# Data Connectors Overview

- URL: https://betteranalyst.com/docs/connectors/overview
- Updated: 2026-11-12
- Author: Better Analyst

Connect Power BI, Tableau, Google Sheets, Google Drive, Dropbox, OneDrive, SharePoint, MySQL, PostgreSQL, Supabase, BigQuery, Snowflake, Amazon Redshift, Databricks, MSSQL, Salesforce, HubSpot, Google Analytics, Google Ads, and Search Console to Better Analyst (Meta Ads coming soon) for real-time data analysis.

Data Connectors allow you to query spreadsheets, BI collections, databases, and analytics platforms directly from Better Analyst. Instead of exporting data manually, connect once and analyze in real-time.

## Available Connectors

### Analytics Platforms

- [Google Analytics](https://betteranalyst.com/docs/connectors/google-analytics) - GA4 website and app analytics
- [Google Search Console](https://betteranalyst.com/docs/connectors/google-search-console) - Search performance data
- [Google Ads](https://betteranalyst.com/docs/connectors/google-ads) - Campaign, keyword, cost, and conversion performance
- [Meta Ads](https://betteranalyst.com/docs/connectors/meta-ads) (coming soon) - Facebook and Instagram spend, delivery, conversion, and ROAS reporting

### Business Intelligence

- [Power BI](https://betteranalyst.com/docs/connectors/powerbi) - Power BI workspaces and semantic models queried with DAX
- [Tableau](https://betteranalyst.com/docs/connectors/tableau) - Tableau Cloud dashboards, views, and extract-backed datasource collections
- [Airtable](https://betteranalyst.com/docs/connectors/airtable) - Read-only OAuth access to explicitly selected base tables

### CRM

- [Salesforce](https://betteranalyst.com/docs/connectors/salesforce) - Read-only OAuth access to selected Salesforce objects, queried with SOQL
- [HubSpot](https://betteranalyst.com/docs/connectors/hubspot) - Read-only OAuth access to CRM contacts, companies, deals, tickets, and owners

### Spreadsheets

- [Google Sheets](https://betteranalyst.com/docs/connectors/google-sheets) - Synced spreadsheet data for chats, dashboards, and tasks
- [Google Drive](https://betteranalyst.com/docs/connectors/google-drive) - Import spreadsheet and tabular files from Drive
- [Dropbox](https://betteranalyst.com/docs/connectors/dropbox) - Import Excel, CSV, and TSV files from Dropbox
- [OneDrive](https://betteranalyst.com/docs/connectors/onedrive) - Import Excel, CSV, and TSV files from Microsoft OneDrive
- [SharePoint](https://betteranalyst.com/docs/connectors/sharepoint) - Import Excel, CSV, and TSV files from SharePoint document libraries

### Databases

- [MySQL](https://betteranalyst.com/docs/connectors/mysql) - Open-source relational database
- [PostgreSQL](https://betteranalyst.com/docs/connectors/postgresql) - Advanced open-source database
- [Supabase](https://betteranalyst.com/docs/connectors/supabase) - Managed Postgres platform
- [MSSQL](https://betteranalyst.com/docs/connectors/mssql) - Microsoft SQL Server

### Data Warehouses

- [BigQuery](https://betteranalyst.com/docs/connectors/bigquery) - Google Cloud data warehouse
- [Snowflake](https://betteranalyst.com/docs/connectors/snowflake) - Cloud data platform
- [Amazon Redshift](https://betteranalyst.com/docs/connectors/redshift) - AWS cloud data warehouse
- [Databricks](https://betteranalyst.com/docs/connectors/databricks) - Databricks SQL warehouses and Unity Catalog

### Don't see your source?

- **Custom APIs**: connect any REST API yourself, on Pro and up (on Free it counts as your one source).
- **Custom connectors**: on [Enterprise](https://betteranalyst.com/contact?plan=enterprise), we build a connector for a system we don't support yet, such as an internal database, an in-house tool or an industry platform, as part of your contract.

## Benefits of Connectors

### Real-Time Data

- No more exporting and uploading files
- Always analyze the latest data
- Changes in your source are immediately available

### Secure Access

- Credentials stored encrypted
- Read-only access for analytics and database connectors
- File connectors import only the files users explicitly choose
- BI connector artifacts are generated internally from attached collections

### Smart Context

- Better Analyst understands your database schema
- Better Analyst can treat BI views as governed assets rather than uploaded files
- Automatic column type detection
- Relationship awareness for joins

## How Connectors Work

1. **Connect** - Authenticate with your data source
2. **Configure** - Select tables, files, or BI collections and set access controls
3. **Query** - Ask questions in natural language
4. **Analyze** - Get insights without writing SQL

Better Analyst translates your questions into appropriate queries and returns the results.

You don't need to know SQL. Better Analyst writes the queries for you based on your natural language questions.

## Setting Up a Connector

1. Go to **Connectors** in the sidebar
2. Click **Add Connector**
3. Select your data source type
4. Follow the connection wizard
5. Test the connection

Each connector has specific setup requirements. See the individual guides for details.

## Managing Connectors

### View Connection Status

Check if your connectors are active and functioning:

- Green = Connected and working
- Yellow = Token expiring soon
- Red = Connection failed

### Edit Configuration

Update connection settings:

- Change credentials
- Modify table access
- Refresh synced BI assets and collections
- Update knowledge base settings

### Delete Connector

Remove a connection when no longer needed. This doesn't affect your source data.

## Advanced Features

### Data Context

For SQL databases, use Data Context to:

- Index your table structures
- Improve query accuracy
- Get better natural language understanding

### BI Collections

For Tableau, create collections to:

- Attach selected dashboards and views to chat
- Keep users in a connector workflow instead of file uploads
- Query extract-backed datasources when extract access is available

For Power BI, sync workspaces and semantic models to:

- Browse the assets available to the connected account
- Query semantic models with DAX through the attached connector
- Keep reports and dashboards available as non-queryable discovery metadata

### Data Access Controls

Restrict what the AI can see:

- Row-level filtering
- Column exclusions
- Table restrictions

Use Data Access Controls when connecting to databases with sensitive information you don't want included in analysis.

## Connector Limits

| Plan | Connectors |
| - | - |
| Free | 1 source of any type, custom APIs included |
| Pro | Unlimited, every connector type |
| Team | Unlimited, shared with the team |
| Enterprise | Unlimited |

## Next Steps

Choose your data source to get started:

- [Google Analytics](https://betteranalyst.com/docs/connectors/google-analytics)
- [Google Search Console](https://betteranalyst.com/docs/connectors/google-search-console)
- [Google Ads](https://betteranalyst.com/docs/connectors/google-ads)
- [Meta Ads](https://betteranalyst.com/docs/connectors/meta-ads) (coming soon)
- [Power BI](https://betteranalyst.com/docs/connectors/powerbi)
- [Tableau](https://betteranalyst.com/docs/connectors/tableau)
- [Airtable](https://betteranalyst.com/docs/connectors/airtable)
- [Salesforce](https://betteranalyst.com/docs/connectors/salesforce)
- [HubSpot](https://betteranalyst.com/docs/connectors/hubspot)
- [Google Sheets](https://betteranalyst.com/docs/connectors/google-sheets)
- [Google Drive](https://betteranalyst.com/docs/connectors/google-drive)
- [Dropbox](https://betteranalyst.com/docs/connectors/dropbox)
- [OneDrive](https://betteranalyst.com/docs/connectors/onedrive)
- [SharePoint](https://betteranalyst.com/docs/connectors/sharepoint)
- [MySQL](https://betteranalyst.com/docs/connectors/mysql)
- [PostgreSQL](https://betteranalyst.com/docs/connectors/postgresql)
- [Supabase](https://betteranalyst.com/docs/connectors/supabase)
- [MSSQL](https://betteranalyst.com/docs/connectors/mssql)
- [BigQuery](https://betteranalyst.com/docs/connectors/bigquery)
- [Snowflake](https://betteranalyst.com/docs/connectors/snowflake)
- [Amazon Redshift](https://betteranalyst.com/docs/connectors/redshift)
- [Databricks](https://betteranalyst.com/docs/connectors/databricks)