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
  • Getting started
    • Introduction
    • Obtaining API keys
    • Quickstart
    • Concepts
    • Embedding authentication
    • Versioning
    • Idempotent requests
  • Configuring your connections
    • CDC streaming from databases
  • API Reference
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, 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