Overview

Use data sources to connect to the data that matters most for your business.

Source data for all Census Syncs come from your data warehouse. Historically, a data warehouse was the end of the line, where data went to collect dust. But modern cloud data warehouses enable a huge variety of data sources and data size, as well as the flexibility to define how data should be aggregated, joined, and organized specifically for your business. It's this flexibility and scalability that make it the perfect data hub for your operations.

At Census, we refer to Data Sources as exactly that—the data warehouse or database that is used as the single source of truth within your organization.

The menu to the left lists all of the data sources that Census currently supports. If you don't see your data source listed, please let us know!

️ Sync Engines

Census offers two methods of connecting to your data source and keeping track of what's been synced (a.k.a. "state tracking"). We call these Sync Engines. When connecting a data source for the first time, we'll ask you to select either Basic or Advanced Sync Engine.

Select your preferred Sync Engine when connecting a data source.

While your experience of the Census product will be identical either way, there are some important differences between these two options:

Basic Sync EngineAdvanced Sync Engine

State tracking location

Census infrastructure

Your data warehouse

Sync performance

Slower

Faster

Ease of setup

Very easy

Slightly more involved

Warehouse permissions

Read-only access

Read/write access

Ability to switch

Ability to upgrade to advanced (coming soon)

Not possible to downgrade to basic

Some data sources (e.g. Google Sheets and Elasticsearch) only support Basic Sync Engine since writing state back to them is either challenging or impossible.

If you have any questions about which Sync Engine is right for you, please reach out to our support team.

Allowed IP Addresses

Most sources require allowlisting IP Addresses so that Census's systems can unload data from the source. BigQuery and Databricks are notable exceptions, so do check the source-specific docs if you have any questions.

If your source is protected by a firewall, please add Census's IP addresses to the allowlist. You can find Census's set of IP address for your region in Regions & IP Addresses.

Last updated