> AI agents: this is one page from Mammoth Analytics documentation. The index of all pages as Markdown is https://docs.mammoth.io/llms.txt. Append `.md` to any docs URL, or send `Accept: text/markdown`, to get Markdown.

# Connectors

> Connect Mammoth to databases, warehouses, cloud storage, CRM, marketing, e-commerce, accounting tools, and REST APIs, and import the data as datasets.

Mammoth connects to your data wherever it lives—relational databases, cloud data warehouses, SaaS platforms, cloud storage, and REST APIs. Each connector handles authentication and data selection in a consistent flow, and you can refresh the resulting datasets manually or on a schedule.

This page is for anyone who needs to bring data from an external system into Mammoth, whether you are a data analyst setting up your first import or an admin who manages connections.

## Where to start

- Find your system in [Connectors by category](#connectors-by-category) and open its guide.
- If your database or server sits behind a firewall, read [Network requirements & IP whitelisting](https://docs.mammoth.io/learn/connectors/network-requirements/) first.
- To learn the query and preview screen that most connectors share, read [Understanding data preview & query](https://docs.mammoth.io/learn/connectors/understanding-data-preview-query/).

Looking for other ways to create a dataset, such as uploading a file or pasting from the clipboard? See [Data sources](https://docs.mammoth.io/learn/data-sources/).

![Animation of the Data Library: New Dataset opens a dialog with Connectors selected and a searchable grid of connector tiles](https://docs.mammoth.io/api/v1/images/20260427_110158_Overview.gif)

## How to add a connector

Connectors follow the same flow:

1. Go to **Data Library** and click **+ New Dataset**
2. Select **Connectors**
3. Choose your connector from the catalog
4. Authenticate (credentials form or OAuth)
5. Select your table or write a query
6. Preview the data, name your dataset, and save (for file connectors, select a file and click **Create new dataset**)

See [Understanding data preview & query](https://docs.mammoth.io/learn/connectors/understanding-data-preview-query/) for a full walkthrough of the query and preview screen.

## Connectors by category

### Databases

Connect to relational databases and cloud warehouses. These connectors use direct credentials (hostname, port, username, password) and require [network access](https://docs.mammoth.io/learn/connectors/network-requirements/) from Mammoth's servers.

| Connector | Default port | AI query | Schemas |
| --- | --- | --- | --- |
| [PostgreSQL](https://docs.mammoth.io/learn/connectors/postgresql-connector/) | 5432 | ✓ | ✓ |
| [MySQL](https://docs.mammoth.io/learn/connectors/mysql/) | 3306 | ✓ |—|
| [SQL Server](https://docs.mammoth.io/learn/connectors/mssql/) | 1433 | ✓ | ✓ |
| [MongoDB](https://docs.mammoth.io/learn/connectors/mongodb/) | 27017 | — | — |
| [Snowflake](https://docs.mammoth.io/learn/connectors/snowflake-connector/) | — | — | ✓ |
| [Google BigQuery](https://docs.mammoth.io/learn/connectors/bigquery/) | — | — | ✓ |
| [Apache Hadoop](https://docs.mammoth.io/learn/connectors/hadoop-connector/) | 10000 | — | ✓ |
| [Databricks](https://docs.mammoth.io/learn/connectors/databricks/) | 443 | — | ✓ |
| [SAP HANA](https://docs.mammoth.io/learn/connectors/sap-hana-connector/) | 443 | ✓ | ✓ |
| [Parquet (Azure)](https://docs.mammoth.io/learn/connectors/parquet-connector/) | — | — | ✓ |

### Cloud storage

Pull files from cloud drives and file servers. Supported file types vary by connector.

| Connector | Auth | File types |
| --- | --- | --- |
| [Google Drive](https://docs.mammoth.io/learn/connectors/google-drive/) | OAuth | CSV, TSV, Excel, XML, text, compressed archives |
| [Google Sheets](https://docs.mammoth.io/learn/connectors/google-sheets-connector/) | OAuth | Spreadsheets |
| [Google Cloud Storage](https://docs.mammoth.io/learn/connectors/google-cloud-storage-connector/) | Service account | CSV, TSV, Excel, text, Parquet, JSON, compressed archives |
| [Dropbox](https://docs.mammoth.io/learn/connectors/dropbox-connector/) | OAuth | CSV, TSV, Excel, XML, text, compressed archives |
| [SFTP](https://docs.mammoth.io/learn/connectors/sftp/) | Password or SSH key | CSV, TSV, Excel, text, compressed archives |
| [SharePoint](https://docs.mammoth.io/learn/connectors/sharepoint-connector/) | App credentials | CSV, TSV, Excel, XML, text, compressed archives |
| [OneDrive](https://docs.mammoth.io/learn/connectors/onedrive-connector/) | App credentials | CSV, TSV, Excel, XML, text, compressed archives |
| [Azure Blob Storage](https://docs.mammoth.io/learn/connectors/azure-blob-storage-connector/) | App credentials | CSV, TSV, Excel, XML, text, compressed archives |

### CRM & marketing

Pull customer, campaign, and email data from your CRM and marketing platforms.

| Connector | Auth | AI query |
| --- | --- | --- |
| [Salesforce](https://docs.mammoth.io/learn/connectors/salesforce-connector/) | OAuth (instance URL) |—|
| [HubSpot](https://docs.mammoth.io/learn/connectors/hubspot-connector/) | OAuth | ✓ |
| [Mailchimp](https://docs.mammoth.io/learn/connectors/mailchimp-connector/) | OAuth | — |
| [SendGrid](https://docs.mammoth.io/learn/connectors/sendgrid-connector/) | API key | — |
| [Microsoft Dynamics](https://docs.mammoth.io/learn/connectors/microsoft-dynamics-connector/) | App credentials | — |
| [Monday.com](https://docs.mammoth.io/learn/connectors/monday-connector/) | API token | — |

### Analytics

Pull advertising data into Mammoth for blending with your other sources.

| Connector | Auth |
| --- | --- |
| [Facebook Ads Manager](https://docs.mammoth.io/learn/connectors/facebook-ads-manager/) | OAuth |

### E-commerce

| Connector | Auth |
| --- | --- |
| [Shopify](https://docs.mammoth.io/learn/connectors/shopify-connector/) | OAuth (shop URL) |

### Accounting

| Connector | Auth | AI query |
| --- | --- | --- |
| [Xero](https://docs.mammoth.io/learn/connectors/xero-connector/) | OAuth | ✓ |
| [Netsuite](https://docs.mammoth.io/learn/connectors/netsuite-connector/) | OAuth (account URL) | — |

### Other

| Connector | Auth | Notes |
| --- | --- | --- |
| [REST API](https://docs.mammoth.io/learn/connectors/rest-api/) | Various | AI Chat builder |

## Full connector comparison

| Connector | Category | Auth method | Needs firewall rule | AI query | Schemas/profiles |
| --- | --- | --- | --- | --- | --- |
| PostgreSQL | Databases | Credentials | ✓ | ✓ | ✓ |
| MySQL | Databases | Credentials | ✓ | ✓ |—|
| SQL Server | Databases | Credentials | ✓ | ✓ | ✓ |
| MongoDB | Databases | Credentials | ✓ | — | — |
| Snowflake | Databases | Credentials | ✓ | — | ✓ |
| Google BigQuery | Databases | Service account JSON | — | — | ✓ |
| Apache Hadoop | Databases | Credentials | ✓ | — | ✓ |
| Databricks | Databases | Credentials (personal access token) | ✓ | — | ✓ |
| SAP HANA | Databases | Credentials | ✓ | ✓ | ✓ |
| Parquet (Azure) | Databases | Azure access key | — | — | ✓ |
| Google Drive | Cloud storage | OAuth (Google) | — | — | — |
| Google Sheets | Cloud storage | OAuth (Google) | — | — | — |
| Google Cloud Storage | Cloud storage | Service account JSON | — | — | ✓ |
| Dropbox | Cloud storage | OAuth | — | — | — |
| SFTP | Cloud storage | Password or SSH key | ✓ | — | — |
| SharePoint | Cloud storage | App credentials | — | — | — |
| OneDrive | Cloud storage | App credentials | — | — | — |
| Azure Blob Storage | Cloud storage | App credentials | — | — | — |
| Salesforce | CRM/Marketing | OAuth (instance URL) | — | — | — |
| HubSpot | CRM/Marketing | OAuth | — | ✓ | — |
| Mailchimp | CRM/Marketing | OAuth | — | — | — |
| SendGrid | CRM/Marketing | API key | ✓ | — | — |
| Microsoft Dynamics | CRM/Marketing | App credentials | — | — | — |
| Monday.com | CRM/Marketing | API token | — | — | — |
| Facebook Ads Manager | Analytics | OAuth | — | — | — |
| Shopify | E-commerce | OAuth (shop URL) | — | — | — |
| Xero | Accounting | OAuth | — | ✓ | ✓ |
| Netsuite | Accounting | OAuth (account URL) | — | — | — |
| REST API | Other | Various | — | AI Chat | — |

- **AI query**—supports natural-language-to-SQL query generation in the preview screen.
- **Schemas/profiles**—supports schema or profile selection after authentication.
- **Needs firewall rule**—you must whitelist Mammoth's IP address, shown on the connection form, in your firewall. See [Network requirements](https://docs.mammoth.io/learn/connectors/network-requirements/).

## Shared connector guides

- [Network requirements & IP whitelisting](https://docs.mammoth.io/learn/connectors/network-requirements/)—required for database and SFTP connectors
- [Understanding data preview & query](https://docs.mammoth.io/learn/connectors/understanding-data-preview-query/)—how the preview grid, AI query generation, and update method work
- [Connector performance & best practices](../performance/connector-optimization)—incremental refresh, query filtering, scheduling
- [PDF extraction](https://docs.mammoth.io/learn/connectors/pdf-extraction)—pull tables and text out of uploaded PDFs and images with AI (not a connector; it works on files already in your Data Library)

---
Source: https://docs.mammoth.io/learn/connectors.md · Updated: 2026-10-13