DealCloud

Polytomic connects DealCloud to your data warehouse, databases, and SaaS tools for ETL and reverse ETL. Replicate the entry types your firm configured into Snowflake or BigQuery, and write enriched data back onto entries, without writing code.

DealCloud logo

Your firm's own schema

Entry types and fields are read from your tenant rather than a fixed list, so bespoke configuration comes through.

Incremental on modified date

Entry types carrying a modified date resume from a checkpoint instead of being reread each run.

Create, update, and upsert

Write back to entries matched on EntryId or the key fields your tenant defines.

Example workflows

Replicate DealCloud entry types into Snowflake, BigQuery, or Databricks

What you can sync

Move data between DealCloud and your data warehouse, databases, and SaaS tools, in both directions.

From DealCloud

Every entry type configured in your tenant
Fields discovered from your tenant's own schema
Choice, reference, and user values with their ID and name
Money values carrying amount and currency
Incremental reads on entry types with a modified date

To DealCloud

Entries on any writable entry type
Create, update, and create or update
Matching on EntryId or your tenant's key fields
Writable fields resolved from your tenant, calculated ones excluded

How it works

DealCloud is configured differently at every firm, so Polytomic reads your tenant's schema rather than assuming a standard object model. Entry types and their fields are discovered from your own configuration, which means the entries your firm built appear alongside the familiar ones.

Reads and writes both run against those discovered entry types. Writable fields are resolved from your tenant too, so calculated and read only fields are excluded from mapping automatically rather than failing when a sync runs.

  • Connect DealCloud with an API key or OAuth client credentials
  • Entry types and fields discovered from your tenant's schema
  • Read any entry type, including ones your firm configured
  • Sync incrementally on entry types that carry a modified date
  • Write entries with create, update, and create or update
  • Monitor sync health, record volume, and failures from one interface

How to set up

Two authentication routes are available: a DealCloud API key sent as a bearer credential, or OAuth client credentials scoped for data access. Once connected, Polytomic reads your tenant's entry types and fields, so the object list reflects your firm's configuration rather than a generic model.

How to get connected
  1. 1In DealCloud, generate an API key or register OAuth client credentials
  2. 2In Polytomic, navigate to Connections, then Add Connection, then DealCloud
  3. 3Enter your site address and credentials
  4. 4Test the connection and review the discovered entry types
  5. 5For reads, select the entry types you want and choose a destination
  6. 6For writes, build a model, set your identity field, and click Save

Frequently asked questions

Why teams choose Polytomic

No engineering required

Set up and manage syncs without writing code.

Flexible data modeling

Use SQL to define exactly what data gets synced.

Handles scale automatically

Supports large datasets with incremental syncs and bulk APIs.

Start syncing your data with DealCloud in minutes

No credit card required. Free trial available.

More integrations beyond DealCloud