Question 1

Which Salesloft objects can I write to from ClickHouse?

Accepted Answer

Accounts, people and cadences, where writing to a cadence means adding people to it. The rest of Salesloft is source only, so activity data can be read into the warehouse for reporting but not written back. Those three cover what teams want from this direction: accurate account and person records, and control over who gets worked and when.

Question 2

Can I add people to a cadence from a model?

Accepted Answer

Yes, and missing people are created for you. If someone selected for a cadence is not in Salesloft yet, they are created and then added, so there is no separate seeding step to run first. That makes it practical to define a qualified list in ClickHouse and let enrolment happen as people meet the criteria rather than when somebody remembers to upload a file.

Question 3

What happens when a record fails to write?

Accepted Answer

The run continues. A record level failure is isolated and logged rather than stopping the sync, and it appears in Sync History with the identity value and the error message, usually downloadable. Transient problems retry automatically. Anything needing a fix can be retried by hand from History, or cleared on its own if you enable retrying failed records on the next run.

Question 4

Should the warehouse create people in Salesloft?

Accepted Answer

It depends who owns the record, and it deserves a deliberate choice. Update or create lets the model introduce people, update only enriches those already there and skips the rest, and create only adds new ones without touching matches. If Salesloft is populated from your CRM, update only keeps ownership clear. If the model is where qualified people get identified, letting it create them is the whole point.

Question 5

What changes for a sales team?

Accepted Answer

The list stops being a periodic artefact. Signals worth acting on, a usage spike or a renewal approaching, change weekly, while a manually built cadence list changes whenever somebody finds an afternoon. Tying enrolment to a model means the working list keeps up with the data underneath it, and nobody has to maintain the spreadsheet that used to sit in the middle.

Sync ClickHouse to Salesloft

Sync ClickHouse to Salesloft with Polytomic

Add people to cadences

Accounts, people, cadences

Failed rows can retry

Or sync Salesloft to ClickHouse

Trusted by businesses worldwide

Step-by-step integration guide

Connect ClickHouse in Polytomic

Connect Salesloft in Polytomic

Create a sync between ClickHouse and Salesloft

Map fields and enable the sync

Frequently asked questions

The sync and ETL platform that does it all

Powerful data sync

Advanced analytics

Enterprise security

Easy setup

Ready to connect ClickHouse with Salesloft?