For AI agents: a documentation index is available at the root level at /llms.txt and /llms-full.txt. Append /llms.txt to any URL for a page-level index, or .md for the markdown version of any page.
Log inBook a demo
GuidesAPI Reference
GuidesAPI Reference
  • Getting started
    • Introduction
    • IP Whitelisting
    • Obtaining API keys
    • LLMs.txt
    • MCP server
    • Quickstart
    • Native clients
    • Concepts
    • Embedding authentication
    • Versioning
    • Idempotent requests
    • Events
    • Self-hosted option
    • 2025-09-18 Migration Guide
  • Configuring your connections
    • Overview
    • CDC streaming from databases
    • Syncing to custom webhooks
  • Code examples
    • Overview
    • Bulk sync (ELT) from HubSpot to PostgreSQL
    • Bulk sync (ELT) from Salesforce to S3
    • Bulk sync (ELT) from Salesforce to Snowflake
    • Model sync (Reverse ETL) from Snowflake query to Salesforce
    • Model sync (Reverse ETL) from MongoDB to Salesforce
    • Adding users from Snowflake to Salesloft Cadence
    • Adding contacts from Snowflake to Gong Engage
    • Joined model sync from Postgres, Airtable, and Stripe to Hubspot
    • Model sync from MySQL to Snowflake
    • Model sync from Salesforce to Netsuite
    • Querying Salesforce using SOQL
    • Syncing audiences from Snowflake to LinkedIn Ads
    • Syncing contacts from Google Cloud Storage to Salesforce
    • Syncing contacts from Google Cloud Storage to webhooks
  • Terraform examples
    • Overview
    • Model sync (Reverse ETL) from BigQuery to Salesforce
    • Model sync (Reverse ETL) from BigQuery to LinkedIn Ads
Logo
Log inBook a demo
On this page
  • Sync types
Getting started

Concepts

Sync types

The fundamental choice to make in Polytomic is whether to use Model Syncs or Bulk Syncs:

  • Use Bulk Syncs if you want to sync untransformed data into SQL databases, data warehouses, spreadsheets, and cloud storage systems like S3 (this is the ‘ELT’ pattern: Extract, Load, and Transform).

  • Use Model Syncs for all other use cases:

    • Syncing data to business systems like Salesforce, HubSpot, NetSuite, and so on.
    • Transforming data at the source (e.g. with custom SQL) before syncing it into any destination (including data warehouses).

Model Syncs require defining a data model first. A data model is a reusable view of fields from your source, either defined literally or through a transformation query (SQL, MongoDB, CosmosDB, Salesforce’s SOQL, etc).

Was this page helpful?
Previous

Embedding authentication

Next