Connectors
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 and open its guide.
- If your database or server sits behind a firewall, read Network requirements & IP whitelisting first.
- To learn the query and preview screen that most connectors share, read 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.
How to add a connector
Connectors follow the same flow:
- Go to Data Library and click + New Dataset
- Select Connectors
- Choose your connector from the catalog
- Authenticate (credentials form or OAuth)
- Select your table or write a query
- Preview the data, name your dataset, and save (for file connectors, select a file and click Create new dataset)
See 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 from Mammoth's servers.
| Connector | Default port | AI query | Schemas |
|---|---|---|---|
| PostgreSQL | 5432 | ✓ | ✓ |
| MySQL | 3306 | ✓ | — |
| SQL Server | 1433 | ✓ | ✓ |
| MongoDB | 27017 | — | — |
| Snowflake | — | — | ✓ |
| Google BigQuery | — | — | ✓ |
| Apache Hadoop | 10000 | — | ✓ |
| Databricks | 443 | — | ✓ |
| SAP HANA | 443 | ✓ | ✓ |
| Parquet (Azure) | — | — | ✓ |
Cloud storage
Pull files from cloud drives and file servers. Supported file types vary by connector.
| Connector | Auth | File types |
|---|---|---|
| Google Drive | OAuth | CSV, TSV, Excel, XML, text, compressed archives |
| Google Sheets | OAuth | Spreadsheets |
| Google Cloud Storage | Service account | CSV, TSV, Excel, text, Parquet, JSON, compressed archives |
| Dropbox | OAuth | CSV, TSV, Excel, XML, text, compressed archives |
| SFTP | Password or SSH key | CSV, TSV, Excel, text, compressed archives |
| SharePoint | App credentials | CSV, TSV, Excel, XML, text, compressed archives |
| OneDrive | App credentials | CSV, TSV, Excel, XML, text, compressed archives |
| Azure Blob Storage | 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 | OAuth (instance URL) | — |
| HubSpot | OAuth | ✓ |
| Mailchimp | OAuth | — |
| SendGrid | API key | — |
| Microsoft Dynamics | App credentials | — |
| Monday.com | API token | — |
Analytics
Pull advertising data into Mammoth for blending with your other sources.
| Connector | Auth |
|---|---|
| Facebook Ads Manager | OAuth |
E-commerce
| Connector | Auth |
|---|---|
| Shopify | OAuth (shop URL) |
Accounting
| Connector | Auth | AI query |
|---|---|---|
| Xero | OAuth | ✓ |
| Netsuite | OAuth (account URL) | — |
Other
| Connector | Auth | Notes |
|---|---|---|
| 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.
Shared connector guides
- Network requirements & IP whitelisting—required for database and SFTP connectors
- Understanding data preview & query—how the preview grid, AI query generation, and update method work
- Connector performance & best practices—incremental refresh, query filtering, scheduling
- 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)