# Connector catalogue

> Every system sanda can bring into your warehouse, how a connector works, and what to do when yours is not listed.

A connector is sanda's way of reading one kind of system. It knows how to sign in, which tables or objects the system offers (sanda calls each one a stream), and how to read them, so nobody writes extraction code. You choose a connector when you [add a connection](https://docs.sanda-os.com.au/connections/add-a-connection). The connection is the saved link between that system and your warehouse.

Each page in this catalogue covers one connector: what to prepare in that system, and every field its setup form asks for. The field lists are generated from the connectors themselves, so they match what you see in the console. The popular connectors ([PostgreSQL](https://docs.sanda-os.com.au/connectors/postgres), [MySQL](https://docs.sanda-os.com.au/connectors/mysql), [CSV / files](https://docs.sanda-os.com.au/connectors/csv), [Google Sheets](https://docs.sanda-os.com.au/connectors/google_sheets), [Stripe](https://docs.sanda-os.com.au/connectors/stripe), [Xero](https://docs.sanda-os.com.au/connectors/xero), [QuickBooks](https://docs.sanda-os.com.au/connectors/quickbooks), [Shopify](https://docs.sanda-os.com.au/connectors/shopify), [Salesforce](https://docs.sanda-os.com.au/connectors/salesforce) and [HubSpot](https://docs.sanda-os.com.au/connectors/hubspot)) also carry notes on where to find each credential.

## Find your system

Filter by name, or narrow the list to one family.


### Databases

- [PostgreSQL](https://docs.sanda-os.com.au/connectors/postgres)
- [MySQL](https://docs.sanda-os.com.au/connectors/mysql)
- [SQL Server](https://docs.sanda-os.com.au/connectors/mssql)
- [MongoDB](https://docs.sanda-os.com.au/connectors/mongodb)
- [Oracle](https://docs.sanda-os.com.au/connectors/oracle)
- [Snowflake](https://docs.sanda-os.com.au/connectors/snowflake)
- [BigQuery](https://docs.sanda-os.com.au/connectors/bigquery)
- [Redshift](https://docs.sanda-os.com.au/connectors/redshift)
- [ClickHouse](https://docs.sanda-os.com.au/connectors/clickhouse)
- [DynamoDB](https://docs.sanda-os.com.au/connectors/dynamodb)
- [Elasticsearch](https://docs.sanda-os.com.au/connectors/elasticsearch)
- [CockroachDB](https://docs.sanda-os.com.au/connectors/cockroachdb)

### Files and storage

- [CSV / files](https://docs.sanda-os.com.au/connectors/csv)
- [S3 / object storage](https://docs.sanda-os.com.au/connectors/s3)
- [Google Sheets](https://docs.sanda-os.com.au/connectors/google_sheets)
- [Google Drive](https://docs.sanda-os.com.au/connectors/google_drive)
- [Azure Blob Storage](https://docs.sanda-os.com.au/connectors/azure_blob_storage)
- [SFTP](https://docs.sanda-os.com.au/connectors/sftp)
- [Google Cloud Storage](https://docs.sanda-os.com.au/connectors/gcs)

### Finance and payments

- [Stripe](https://docs.sanda-os.com.au/connectors/stripe)
- [Xero](https://docs.sanda-os.com.au/connectors/xero)
- [QuickBooks](https://docs.sanda-os.com.au/connectors/quickbooks)
- [NetSuite](https://docs.sanda-os.com.au/connectors/netsuite)
- [PayPal](https://docs.sanda-os.com.au/connectors/paypal)
- [Square](https://docs.sanda-os.com.au/connectors/square)
- [Chargebee](https://docs.sanda-os.com.au/connectors/chargebee)
- [Recurly](https://docs.sanda-os.com.au/connectors/recurly)
- [Braintree](https://docs.sanda-os.com.au/connectors/braintree)
- [Zuora](https://docs.sanda-os.com.au/connectors/zuora)

### Commerce

- [Shopify](https://docs.sanda-os.com.au/connectors/shopify)
- [WooCommerce](https://docs.sanda-os.com.au/connectors/woocommerce)
- [Amazon Seller Partner](https://docs.sanda-os.com.au/connectors/amazon_seller)
- [Amazon Ads](https://docs.sanda-os.com.au/connectors/amazon_ads)
- [BigCommerce](https://docs.sanda-os.com.au/connectors/bigcommerce)
- [Recharge](https://docs.sanda-os.com.au/connectors/recharge)

### CRM and support

- [Salesforce](https://docs.sanda-os.com.au/connectors/salesforce)
- [HubSpot](https://docs.sanda-os.com.au/connectors/hubspot)
- [Pipedrive](https://docs.sanda-os.com.au/connectors/pipedrive)
- [Zendesk](https://docs.sanda-os.com.au/connectors/zendesk)
- [Intercom](https://docs.sanda-os.com.au/connectors/intercom)
- [Freshdesk](https://docs.sanda-os.com.au/connectors/freshdesk)
- [Zoho CRM](https://docs.sanda-os.com.au/connectors/zoho_crm)
- [Front](https://docs.sanda-os.com.au/connectors/front)
- [Close](https://docs.sanda-os.com.au/connectors/close_com)

### Marketing and analytics

- [Google Ads](https://docs.sanda-os.com.au/connectors/google_ads)
- [Google Analytics 4](https://docs.sanda-os.com.au/connectors/google_analytics)
- [Google Search Console](https://docs.sanda-os.com.au/connectors/google_search_console)
- [Facebook Marketing](https://docs.sanda-os.com.au/connectors/facebook_marketing)
- [Instagram](https://docs.sanda-os.com.au/connectors/instagram)
- [TikTok Marketing](https://docs.sanda-os.com.au/connectors/tiktok)
- [LinkedIn Ads](https://docs.sanda-os.com.au/connectors/linkedin_ads)
- [Klaviyo](https://docs.sanda-os.com.au/connectors/klaviyo)
- [Mailchimp](https://docs.sanda-os.com.au/connectors/mailchimp)
- [Mixpanel](https://docs.sanda-os.com.au/connectors/mixpanel)
- [Amplitude](https://docs.sanda-os.com.au/connectors/amplitude)
- [Typeform](https://docs.sanda-os.com.au/connectors/typeform)
- [Microsoft Advertising](https://docs.sanda-os.com.au/connectors/bing_ads)
- [Pinterest](https://docs.sanda-os.com.au/connectors/pinterest)
- [Snapchat Ads](https://docs.sanda-os.com.au/connectors/snapchat_marketing)
- [Iterable](https://docs.sanda-os.com.au/connectors/iterable)
- [SendGrid](https://docs.sanda-os.com.au/connectors/sendgrid)
- [Braze](https://docs.sanda-os.com.au/connectors/braze)
- [PostHog](https://docs.sanda-os.com.au/connectors/posthog)
- [SurveyMonkey](https://docs.sanda-os.com.au/connectors/surveymonkey)

### Product and operations

- [GitHub](https://docs.sanda-os.com.au/connectors/github)
- [Jira](https://docs.sanda-os.com.au/connectors/jira)
- [Notion](https://docs.sanda-os.com.au/connectors/notion)
- [Airtable](https://docs.sanda-os.com.au/connectors/airtable)
- [Slack](https://docs.sanda-os.com.au/connectors/slack)
- [Asana](https://docs.sanda-os.com.au/connectors/asana)
- [GitLab](https://docs.sanda-os.com.au/connectors/gitlab)
- [Monday](https://docs.sanda-os.com.au/connectors/monday)
- [ClickUp](https://docs.sanda-os.com.au/connectors/clickup)
- [Zoom](https://docs.sanda-os.com.au/connectors/zoom)
- [Twilio](https://docs.sanda-os.com.au/connectors/twilio)
- [Harvest](https://docs.sanda-os.com.au/connectors/harvest)

### People

- [BambooHR](https://docs.sanda-os.com.au/connectors/bamboo_hr)
- [Greenhouse](https://docs.sanda-os.com.au/connectors/greenhouse)

### By arrangement

- [MYOB](https://docs.sanda-os.com.au/connectors/myob)
- [Something else](https://docs.sanda-os.com.au/connectors/other)


## How a connector works

The steps are the same for every source, whatever it holds.

1. **You give sanda the details for the system.** A host and a login for a database, an API key or app credentials for a SaaS product. The details go straight to sanda's managed sync over TLS, and sanda's own database never stores them.
2. **sanda reads what the system offers.** Pressing **Read schema** signs in and lists the streams available. This doubles as the test: a wrong password or a closed firewall fails here, with a reason.
3. **You choose what to sync.** Every table starts on **Full refresh · Overwrite**, which reads the whole table on every run and replaces what landed last time. For a large table, switch to an incremental mode with a cursor column so each run reads only the rows that have changed. See [sync modes](https://docs.sanda-os.com.au/connections/sync-modes) and [choose what to sync](https://docs.sanda-os.com.au/connections/choose-streams).
4. **Each stream lands as a table in your warehouse.** Rows go to the `raw` schema, one table per stream, named `raw.<connection>__<stream>`.
5. **Runs repeat on a schedule.** You set the frequency, or run a sync by hand with **Sync now**. See [sync schedules](https://docs.sanda-os.com.au/connections/schedules).

## Connect a system

:::steps
1. **Open Connections.** In the console, go to **Data · Connections** and press **New connection**.
2. **Choose the source.** Search by name, or pick from **Popular** or **All sources**.
3. **Fill in the form.** The setup guide sits beside it, and the page for your connector here says where to find each credential.
4. **Read the schema and choose streams.** Nothing moves until you save your choice of streams.
5. **Run the first sync.** Press **Sync now**, or let the schedule start it.
:::

Owners and admins add connections. The full walkthrough is in [Add a connection](https://docs.sanda-os.com.au/connections/add-a-connection). If the system sits behind a firewall, [allow sanda's address](https://docs.sanda-os.com.au/connections/allowlist) first.

## Connectors set up by arrangement

A few connectors have no setup form. [MYOB](https://docs.sanda-os.com.au/connectors/myob) is wired by hand, and so is [Something else](https://docs.sanda-os.com.au/connectors/other), which covers any system that is not in the catalogue. [Zuora](https://docs.sanda-os.com.au/connectors/zuora) and [BigCommerce](https://docs.sanda-os.com.au/connectors/bigcommerce) are set up the same way, because the ready-made connectors for them are no longer maintained. In the console they carry a **Concierge** badge.

There is nothing to fill in. You create the connection with a name and a frequency, and a sanda engineer gets in touch to wire it up and confirm the first load with you. Until then the connection shows **Setup incomplete** in **Data · Connections**.

A connector that normally has a form can land here too. If sanda cannot read a connector's setup form, the console says so and offers the same route, and the connector's page in this catalogue says the same.

## Ask for a connector

If the system you use is not in the catalogue, pick **Something else** when you add a connection. Give it a name and a frequency, and a sanda engineer gets in touch to find out what the system is and the best way to bring its data in.

If what you have is a file rather than a system, [load a CSV](https://docs.sanda-os.com.au/connections/upload-a-csv) straight into your warehouse. For anything else, see [getting help](https://docs.sanda-os.com.au/help).
