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

# Mammoth connectors: every data source you can connect

> Every Mammoth connector by type: databases, warehouses, cloud storage, CRM, analytics, e-commerce, accounting and REST APIs, with sign-in and refresh notes.

Mammoth connects to databases, cloud warehouses, cloud storage, business apps and REST APIs. Every connector starts the same way: **Data Library** > **New dataset** > **Connectors**, or **Data → Connections** > **New Connection**. This page lists every source, grouped by type, with a link to its own page; [Connect a database or app](https://mammoth.io/docs/learn/get-data-in/connect-a-source/) covers the shared steps.

![Connect a source: search box, the category menu on the left and Popular connectors](https://mammoth.io/docs/images/20261102_connectors-launcher.webp)

## Which connector page do I need?

| I want to... | Go to |
| --- | --- |
| Import a table or SQL query from a database | [Databases and warehouses](#database-and-warehouse-connectors) |
| Import a file from a drive, bucket, file server or mailbox | [Cloud storage and files](#cloud-storage-and-file-connectors) |
| Import CRM or email marketing data | [CRM and marketing](#crm-and-marketing-connectors) |
| Import ad, web analytics, meeting or streaming data | [Analytics and streaming](#analytics-and-streaming-connectors) |
| Import store, accounting or ERP data | [E-commerce and accounting](#e-commerce-and-accounting-connectors) |
| Connect a service Mammoth doesn't list | [REST API](https://mammoth.io/docs/learn/get-data-in/connectors/rest-api/) |
| Let another system push data to Mammoth | [Receive data by webhook](https://mammoth.io/docs/learn/get-data-in/webhooks/) |
| Open my database to Mammoth's IP address | [Allow Mammoth through your firewall](https://mammoth.io/docs/learn/get-data-in/network-requirements/) |

## Which connectors you see and who can add them

- The launcher shows the connectors your plan includes. A connector that isn't on your plan still turns up in search, greyed out, with **Not on your plan · See plans**.
- A connector your plan has retired stays available only while your project still has connections to it.
- Only Project Admins create connections. Project Editors can start datasets from the project's existing connections. For a new source, they can click **Copy a request** to send an admin what they need.
- A saved connection belongs to the project. See [Manage saved connections](https://mammoth.io/docs/learn/get-data-in/connections/).

## Add a connector in four steps

1. Go to the **Data Library**, click **New dataset**, and choose **Connectors**. You can also go to **Data → Connections** and click **New Connection**.
2. Find your source by search or in the left menu: **Popular**, **All**, a category (such as **Databases**, **Cloud Storage**, **CRM & Marketing**, **Analytics**, **E-commerce**, **Accounting**, **APIs** or **Education**), **Files & links**, or **Push** (webhooks).
3. Connect it. A database opens its connection form; other sources open the connector workspace, where the chat asks for credentials or a sign-in.
4. Pick tables and columns, then click **Save as dataset**.

Datasets from databases, cloud apps and APIs can refresh manually or on a schedule. A file from a drive or file server is saved once, and a **File Collection** automation brings in new files.

## Database and warehouse connectors

These use direct credentials (host, port, username, password) or a key, and most need [network access](https://mammoth.io/docs/learn/get-data-in/network-requirements/) from Mammoth's servers. A database opens its connection form, then the SQL view. MongoDB lists collections without a SQL view, and Parquet (Azure) connects in the connector workspace chat instead of a form.

| Connector | Default port | AI query (**Write SQL**) | Schemas |
| --- | --- | --- | --- |
| [Amazon Redshift](https://mammoth.io/docs/learn/get-data-in/connectors/redshift/) | 5439 | No | No |
| [Apache Hadoop](https://mammoth.io/docs/learn/get-data-in/connectors/hadoop/) | 10000 | No | Yes |
| [Databricks](https://mammoth.io/docs/learn/get-data-in/connectors/databricks/) | 443 | No | Yes |
| [Google BigQuery](https://mammoth.io/docs/learn/get-data-in/connectors/bigquery/) | | No | Yes |
| [MongoDB](https://mammoth.io/docs/learn/get-data-in/connectors/mongodb/) | 27017 | No | No |
| [MySQL](https://mammoth.io/docs/learn/get-data-in/connectors/mysql/) | 3306 | Yes | No |
| [Oracle Database](https://mammoth.io/docs/learn/get-data-in/connectors/oracle/) | 1521 | No | Yes |
| [Parquet (Azure)](https://mammoth.io/docs/learn/get-data-in/connectors/parquet/) | | No | Yes |
| [PostgreSQL](https://mammoth.io/docs/learn/get-data-in/connectors/postgresql/) | 5432 | Yes | Yes |
| [SAP HANA](https://mammoth.io/docs/learn/get-data-in/connectors/sap-hana/) | 443 | Yes | Yes |
| [Snowflake](https://mammoth.io/docs/learn/get-data-in/connectors/snowflake/) | | No | Yes |
| [SQL Server](https://mammoth.io/docs/learn/get-data-in/connectors/sql-server/) | 1433 | Yes | Yes |

**AI query** means Mammoth can write SQL from a plain-language description (**Write SQL** in a database's SQL view) when AI query is on for your workspace.

## Cloud storage and file connectors

These pull files from cloud drives, buckets, file servers and mailboxes. A file you save from them is saved once, except from Google Sheets and Azure Blob Storage, which can refresh. To bring in new files on a schedule, use a **File Collection** automation (see [What you can automate](https://mammoth.io/docs/learn/automate/)).

| Connector | Sign-in | File types |
| --- | --- | --- |
| [Azure Blob Storage](https://mammoth.io/docs/learn/get-data-in/connectors/azure-blob-storage/) | App credentials | CSV, TSV, Excel (incl. .xlsm), XML, JSON, JSONL, NDJSON, text, compressed archives |
| [Dropbox](https://mammoth.io/docs/learn/get-data-in/connectors/dropbox/) | OAuth | CSV, TSV, Excel (incl. .xlsm), XML, JSON, JSONL, NDJSON, text, compressed archives |
| [Email (IMAP)](https://mammoth.io/docs/learn/get-data-in/connectors/email-imap/) | Email and password | Email attachments: CSV, TSV, Excel (incl. .xlsm) |
| [Google Cloud Storage](https://mammoth.io/docs/learn/get-data-in/connectors/google-cloud-storage/) | Service account | CSV, TSV, Excel (incl. .xlsm), text, Parquet, JSON, compressed archives |
| [Google Drive](https://mammoth.io/docs/learn/get-data-in/connectors/google-drive/) | OAuth | CSV, TSV, Excel (incl. .xlsm), XML, JSON, JSONL, NDJSON, text, compressed archives |
| [Google Sheets](https://mammoth.io/docs/learn/get-data-in/connectors/google-sheets/) | OAuth | Spreadsheets |
| [OneDrive](https://mammoth.io/docs/learn/get-data-in/connectors/onedrive/) | App credentials | CSV, TSV, Excel (incl. .xlsm), XML, JSON, JSONL, NDJSON, text, compressed archives |
| [SFTP](https://mammoth.io/docs/learn/get-data-in/connectors/sftp/) | Password or SSH key | CSV, TSV, Excel (incl. .xlsm), XML, JSON, JSONL, NDJSON, text, compressed archives |
| [SharePoint](https://mammoth.io/docs/learn/get-data-in/connectors/sharepoint/) | App credentials | CSV, TSV, Excel (incl. .xlsm), XML, JSON, JSONL, NDJSON, text, compressed archives |

## CRM and marketing connectors

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

## Analytics and streaming connectors

These pull advertising, web analytics, meeting and streaming data for blending with your other sources.

| Connector | Sign-in |
| --- | --- |
| [Apache Kafka](https://mammoth.io/docs/learn/get-data-in/connectors/kafka/) | Bootstrap servers, optional SASL |
| [Facebook Ads Manager](https://mammoth.io/docs/learn/get-data-in/connectors/facebook-ads/) | OAuth |
| [Google Ads](https://mammoth.io/docs/learn/get-data-in/connectors/google-ads/) | OAuth (Google) |
| [Google Analytics 4](https://mammoth.io/docs/learn/get-data-in/connectors/google-analytics-4/) | OAuth (Google) |
| [MQTT](https://mammoth.io/docs/learn/get-data-in/connectors/mqtt/) | Broker host, optional username and password |
| [Zoom](https://mammoth.io/docs/learn/get-data-in/connectors/zoom/) | OAuth |

## E-commerce and accounting connectors

| Connector | Category | Sign-in | AI query |
| --- | --- | --- | --- |
| [Netsuite](https://mammoth.io/docs/learn/get-data-in/connectors/netsuite/) | Accounting | OAuth (NetSuite sign-in) | No |
| [Shopify](https://mammoth.io/docs/learn/get-data-in/connectors/shopify/) | E-commerce | OAuth (shop URL) | No |
| [Xero](https://mammoth.io/docs/learn/get-data-in/connectors/xero/) | Accounting | OAuth | Yes |

## REST APIs and webhooks

| Source | Sign-in | Notes |
| --- | --- | --- |
| [REST API](https://mammoth.io/docs/learn/get-data-in/connectors/rest-api/) | Various | Built with the agent in the connector chat. The launcher also lists several hundred known API sources by category (including **APIs** and **Education**); each is built the same way. |
| [Webhooks](https://mammoth.io/docs/learn/get-data-in/webhooks/) | Optional secret | Under **Push**: other systems send data to a Mammoth URL |

## Compare all connectors: firewall, AI query and schemas

| Connector | Category | Sign-in method | Needs firewall rule | AI query | Schemas or profiles |
| --- | --- | --- | --- | --- | --- |
| PostgreSQL | Databases | Credentials | Yes | Yes | Yes |
| MySQL | Databases | Credentials | Yes | Yes | No |
| SQL Server | Databases | Credentials | Yes | Yes | Yes |
| MongoDB | Databases | Credentials | Yes | No | No |
| Snowflake | Databases | Credentials | Yes | No | Yes |
| Google BigQuery | Databases | Service account JSON | No | No | Yes |
| Apache Hadoop | Databases | Credentials | Yes | No | Yes |
| Databricks | Databases | Credentials (personal access token) | Yes | No | Yes |
| SAP HANA | Databases | Credentials | Yes | Yes | Yes |
| Parquet (Azure) | Databases | Azure access key | No | No | Yes |
| Oracle Database | Databases | Credentials | Yes | No | Yes |
| Amazon Redshift | Databases | Credentials | Yes | No | No |
| Google Drive | Cloud storage | OAuth (Google) | No | No | No |
| Google Sheets | Cloud storage | OAuth (Google) | No | No | No |
| Google Cloud Storage | Cloud storage | Service account JSON | No | No | Yes |
| Dropbox | Cloud storage | OAuth | No | No | No |
| SFTP | Cloud storage | Password or SSH key | Yes | No | No |
| SharePoint | Cloud storage | App credentials | No | No | No |
| OneDrive | Cloud storage | App credentials | No | No | No |
| Azure Blob Storage | Cloud storage | App credentials | No | No | No |
| Email (IMAP) | Cloud storage | Email and password | No | No | No |
| Salesforce | CRM/Marketing | OAuth (instance URL) | No | No | No |
| HubSpot | CRM/Marketing | OAuth | No | Yes | No |
| Mailchimp | CRM/Marketing | OAuth | No | No | No |
| SendGrid | CRM/Marketing | API key | Yes | No | No |
| Microsoft Dynamics | CRM/Marketing | App credentials | No | No | No |
| Monday.com | CRM/Marketing | API token | No | No | No |
| Facebook Ads Manager | Analytics | OAuth | No | No | No |
| Google Ads | Analytics | OAuth (Google) | No | No | Yes |
| Google Analytics 4 | Analytics | OAuth (Google) | No | No | Yes |
| Zoom | Analytics | OAuth | No | No | No |
| Apache Kafka | Analytics | Bootstrap servers, optional SASL | Yes | No | No |
| MQTT | Analytics | Broker credentials | No | No | No |
| Shopify | E-commerce | OAuth (shop URL) | No | No | No |
| Xero | Accounting | OAuth | No | Yes | Yes |
| Netsuite | Accounting | OAuth (NetSuite sign-in) | No | No | No |
| REST API | Other | Various | No | Agent | No |

- **AI query**: Mammoth can write SQL from a plain-language description (**Write SQL** in a database's SQL view). For HubSpot and Xero, you describe the data in the chat.
- **Schemas or profiles**: you pick a schema or profile (such as an account or property) after signing in.
- **Needs firewall rule**: allow Mammoth's IP address, shown on the connection form, through your firewall. SendGrid needs it only when your account restricts API access by IP. See [Allow Mammoth through your firewall](https://mammoth.io/docs/learn/get-data-in/network-requirements/).

## Related

- [Connect a database or app](https://mammoth.io/docs/learn/get-data-in/connect-a-source/): the shared steps for every connector and the SQL view.
- [Manage saved connections](https://mammoth.io/docs/learn/get-data-in/connections/): see, reuse, edit and delete connections, and who can do what.
- [Allow Mammoth through your firewall](https://mammoth.io/docs/learn/get-data-in/network-requirements/): needed for database and SFTP connectors.
- [Speed up pipelines and connectors](https://mammoth.io/docs/learn/help/performance/): incremental refresh, query filtering and scheduling.
- [Extract tables from PDFs](https://mammoth.io/docs/learn/get-data-in/extract-from-pdfs/): pull tables and text out of PDFs and images (not a connector).
- [Choose how to bring data in](https://mammoth.io/docs/learn/get-data-in/): uploads, paste, URLs and other ways to create a dataset.

---
Source: https://mammoth.io/docs/learn/get-data-in/connectors.md · Updated: 2026-11-08