Companies many to many relationshipsCustom Field Select Boxes, Subscription Objects, Line Items, Change OrderOrders and inventory levelslist typeTicket Comment
👉 See all of our destination connectors
Databricks users rejoice! Sync Logs are now available in your favorite lakehouse. To enable, navigate to the Connections page in Census, click to edit your connection, and toggle "Write logs in this warehouse."
Census will begin storing detailed information regarding the success and failure of each record in your syncs directly in your Databricks instance.
ℹ️ Sync Logs are only available on Platform plans.
Now, syncs to Google Sheets (as a destination) can send input exactly as a user would have typed it in the browser, in a more human-readable format.
In this example of a date/time field, this is the difference between before (raw input) and after (parsed):
Before: Raw input
After: Parsed into date/time format
New Syncs
The parse option is now on by default.
Existing Syncs
You can easily turn parsing on in Configuration -> Advanced Configuration. Your data will be updated once you run another sync.
This change is not just limited to dates. With the new behavior, any string that starts with an equals sign = will be treated as a formula. If you want to send a = string and not have that happen, you need to switch off the advanced parsing configuration and use raw input.
No more weird formatting in Google Sheets! 🙌
Webhooks: Now supports destinations that don’t implement HEAD
SendGrid: List Support
Netsuite and Oracle Fusion Cloud: New objects, custom fields
Close: Support for Opportunities
✅ Support for Azure Synapse, Microsoft’s cloud data platform, as a source for Census reverse ETL
✅ A connector for Microsoft Dynamics 365 as a destination, to deliver more engaging experiences using warehouse data in the CRM
👉 Read the blog for use cases and more information
Psst – type sync.new into your URL bar right now.
sync.new in any browser will automatically redirect you to app.getcensus.com/syncs/new to create a new Census sync. If you’re not logged in, you’ll be prompted to log into Census first.
From 3 steps to just 1, now it's even easier and faster to create a new sync.
👉 Read the blog to learn more.
In sync with the Snowflake Summit in Las Vegas, we’re excited to announce support for Snowflake Stream Triggers to kick off a reverse ETL sync only when your data changes — which is especially useful for data that's updated on an irregular frequency but needs to be synced ASAP.
This is a strictly superior way to accomplish continuous syncs that's both cheaper and faster than previous methods. 🙌
