Packed with features loved by data teams
GitLink (Configuration as Code)
Manage all your Reverse ETL and data activation workflows in Git. Bring software engineering best practices like version control, peer review, and testing to business operations.
Notifications
Automatically trigger alerts in Slack or Microsoft Teams for real-time updates on customer activity. Use fields in your data warehouse to customize your message content in our rich visual builder.
SQL Model Builder & Editor
You define what data to sync. Query any data warehouse resource, write powerful filters or transform the data. Just write SQL, preview the results, and save.
Multiple Sync Behaviors
Each sync is different. Whether you need to create new leads in SFDC or update an account with their PQL score, our modes can help you sync just the right data (Enrich, Mirror, Upsert, or Create).
Automatic Recovery
If Census loses connections to databases or apps, we notify you via email and automatically resume the sync when we re-connect. You never lose data and your stack stays in sync.
Daily Data Trends Reports
We make it easy to maintain and keep an eye on your sync with daily & weekly reports that highlight trends in errors, skipped, created or updated records.
Typecasting from your column to fields
We automatically convert field types for you. If you store "deal size" as an integer in your warehouse and a string in Salesforce, we manage the conversion for you automatically.
Data Orchestration API
Hourly? Daily? On-demand? Trigger syncs exactly when you want via the Trigger Sync API from tools like Airflow, Dagster, dbt Cloud & more.
Visual Data Mapper
From Leads to Custom Objects, Census makes it easy for you to configure how data is mapped into your target tools. We take care of all the translation details to keep data flowing smoothly.
Scheduled & Continuous Sync
You can customize how often data is synced. From realtime all the way to monthly or manual; you can pick different schedules for different syncs.
Optimize API Calls
You shouldn't have to go past your Salesforce API quota just because your team needs better data. Census uses bulk APIs and only syncs records that have pending changes.
Support For dbt
We love dbt, and we know you love it too. Keep writing dbt models to make the most of your data and use Census to operationalize the data across your tools.
Detailed Observability & Logging
Every sync comes with a historical log where you can dive into what caused errors or why an application rejected updates.
