Overview
Unify is built to support custom data models and huge volumes of data. If you have data that lives in an external data system, you can send it over and use it to power anything within Unify. Examples of data systems you can connect to Unify include:- Data warehouses — Snowflake, BigQuery, ClickHouse, Redshift, etc.
- Databases — PostgreSQL, MySQL, MongoDB, etc.
- Data lakes — S3, Databricks, etc.
Modeling data
You can insert data directly into the standard Company and Person objects. However, this loses track of where the data came from. It can also lead to lots of custom attributes being created on those standard objects over time, many of which are not applicable for most records. Instead, Unify recommends defining custom objects to represent external data sources. You can create a custom object which aligns with the data source and then create a reference attribute to link it to the standard objects.ExampleSuppose you have a table of product users in your data warehouse. One thing
you could do is insert them directly into the Person object in Unify:However, a better strategy is to create a new object in Unify called “Product
User” and connect it to the Person object using a reference attribute. Then,
insert the product user records into that object instead:This is how Unify builds its integrations into Salesforce, HubSpot, and more.
Avoid: Directly inserting external data sources into standard objects.
Prefer: Inserting external data sources into custom objects linked to
standard objects.
Getting started
Define objects and attributes
The first step is to define the objects and attributes that will store your
data. This is how you declare the format of the data and how it relates to
other objects.Once the objects are created, you can create, update, and delete records using
the API. They will also become available in any tools that connect to Unify,
such as the Hightouch and Fivetran destinations for Unify.
Manage via API
Create and manage objects, attributes, and records in Unify via API.
Manage via UI
Create and manage objects, attributes, and records within the Unify app.
Sync data into Unify
Once the objects are created, you can sync data into Unify using the API
directly or via a supported integration.
Connect via Hightouch
Sync object records from Hightouch data sources into Unify.
Connect via Fivetran
Sync object records from Fivetran data sources into Unify.
Sync directly via API
Create, update, and link object records using the Unify API and SDKs.