Stacksync Documentation
  • What is Stacksync?
  • 🚀 Start here
    • Quick start
    • Community
  • 💡Guides
    • Modify Salesforce Data in Postgres
    • 🔄Two-way sync Salesforce and Postgres
      • Create a Postgres Database with Supabase (free forever)
      • Create a Salesforce Developer instance (free forever)
      • Create a Sync between Supabase Postgres and Salesforce
    • ⚡Event Triggers
    • 🔣Add a new custom field to an existing sync
  • 🔗 Connectors
    • Salesforce
      • Authorize Salesforce
        • ⚙️Enable API Access in Salesforce
    • Postgres
      • Authorize Postgres
        • Supabase
        • Cloud SQL
        • Digital Ocean
        • Heroku
        • Amazon Lightsail
        • Amazon RDS
          • Ensuring Secure RDS Connections with SSL Certificate
        • Basedash
        • Render
        • Retool
      • Snippets
      • Required Permissions
    • BigQuery
      • Authorize BigQuery
    • HubSpot
      • Authorize HubSpot
      • Associations
      • HubDB
      • Attachments
    • MotherDuck
    • Supabase
    • Snowflake
      • Authorize Snowflake
    • Attio
      • Authorize Attio
    • Pipedrive
      • Authorize Pipedrive
    • Front
      • Authorize Front
    • Zoho
      • Authorize Zoho
    • MySQL
      • Authorize MySQL
        • Ensure Secure RDS connection with SSL Certificate
        • Access Private RDS database through SSH Tunnel
    • MariaDB
      • Authorize Mariadb
        • Ensure Secure RDS connection with SSL Certificate
        • Access Private RDS database through SSH Tunnel
    • Netsuite
      • Authorize Netsuite
    • MongoDB
    • Shopify
      • Authorize Shopify
    • Zendesk
      • Authorize Zendesk
    • 🤖Setup options
      • 🏳️IP Whitelisting
      • 🚰Manage API rate limits
      • 🌍Choose data processing region
      • SSH Tunneling
        • Access private ASW RDS instance through Jumpbox
        • Azure Jumpbox
        • Windows Server 2022 Jumpbox
        • Windows Server 2025 Jumpbox
        • GCP Jumpbox
  • 📦 API Proxy
    • Salesforce
    • HubSpot
    • Attio
    • Pipedrive
  • Features
    • Two-way sync
    • Event triggers
      • Webhook (HTTP call)
      • Database Query
    • Update Sync configuration
    • Associations support
    • Manage workspace users
    • Manage API rate limits
    • Delete Record Protection
    • Issues dashboard
    • Custom sync frequencies
    • Other features
      • Sync statistics
      • Monitoring
    • 🔐Security
      • SSO & SCIM
        • Azure Entra ID
        • OKTA
      • MFA
  • Workflows
    • Workflows Quick Start
    • Features
      • Variables and Secrets
        • Variable replacement
  • Legal
    • Terms of Service and Conditions (TC)
    • Privacy Notice
    • Service Consumption Tables
    • Global Employee and Applicant Privacy Notice
    • Acceptable Use Policy (AUP)
    • Data Processing Addendum (DPA)
    • Referral Programme Policy
    • Terms and Conditions for Stacksync Content Creator Programme
    • Stacksync Certified Partner Program Terms and Conditions
  • Security
    • Overview - Security
    • Subprocessors
    • EU Data Protection
  • Others
    • Content Creator Guidelines
Powered by GitBook
On this page
  • Choosing which tables and fields to sync
  • Read-only fields
  • Limitations
  1. Features

Two-way sync

Stacksync lets you sync your apps in real-time and two-way! Really! 🥳✨

PreviousPipedriveNextEvent triggers

Last updated 6 months ago

Stacksync offers true bidirectional sync. Once set up, you can update data in either connected app and it will sync to the other in real-time.

Enabling two-way sync for a new Stacksync base is a straightforward process. Just switch the direction arrows to the two-way mode:

Choosing which tables and fields to sync

Read-only fields

Some tables contain fields that can only be read, but not written to. We call these managed fields which are read-only.

If you choose two-way sync, the read-only fields will only sync in one direction while the other fields will still sync two-way.

Some examples of read-only fields can be:

  • the record id managed by your CRM

  • last_modified_time managed by your CRM

  • formula or computed fields managed by a certain platform

  • read-only columns defined for a certain database user

Limitations

Two-way sync is not compatible with Database view sync If you are using a database view sync, you can only sync one way from your database to your other app. This is because it is not possible to write data to a view.

Stacksync does not "merge" duplicate records when you first turn on two-way sync

When initially activating two-way sync, duplicate data is not automatically merged. For a smoother experience, we recommend starting with one of your Apps to be empty (e.g. start with an empty database when syncing Postgres and Salesforce, or vice-versa). Once the synchronization is started, subsequent updates will seamlessly sync in both directions. Please refer to the details below for further information:

You can choose which tables and which fields you want to sync. You can choose to sync all the data available in your App (e.g. CRM, ERP, Database,...) if needed, or you can select a subset of data if you only need that for your business use case. By default, Stacksync syncs the most popular tables and fields automatically so you can complete a basic sync setup in a few minutes. You can customize the sync configuration to fit your needs right from the beginning, or anytime as your business use case and data evolve later on.

update the sync configuration
Toggle table sync to two-way sync
Example of read-only field in a base setup.