Running your first sync is satisfying—you can see your source data appear in the tools and apps your organization lives in. To get there, you need to set a few things up first.
It's best to follow this setup sequence when creating your first sync:
This interactive tour guides you through creating a Snowflake source, Salesforce destination, and a sync to upsert contacts and leads to Salesforce. It assumes you've already configured a model.
If you want to test things out without connecting a production source, you can
use the B2B SaaS or B2C e-commerce Sample datasets. They're available at
the end of the source list.
Enter the relevant credentials. These differ depending on the source. Refer to the relevant source documentation for further details.
Click Continue. Before continuing, Hightouch validates that you have the necessary access and permissions. If the test fails, you need to confirm and re-enter your credentials.
Give your source a Source name. This name is how your source appears in the Hightouch workspace. It helps to include details about the sources' environment, data contents, and owners, particularly if you plan on connecting multiple instances of the same source, for example, a development and prod version.
Click Finish.
Once you've finished, your source appears on the Sources overview page and you can use it set up models.
Choose a modeling method: SQL editor, table selector, dbt model, or Looker Look selector. If you're using one of the Sample dataset sources, the SQL editor comes with pre-populated SQL queries. You can also use the table selector with the Sample datasets.
Before continuing, you must Preview your model to ensure it's querying the data you're interested in. By default, the preview displays the first 100 records. Once you've validated your data, click Continue.
Give your model a Model name. It's best to include details about the model's contents and business purpose so you can easily identify it. Including more information is beneficial if you plan on using your model for multiple syncs or having many team members in your workspace.
Select a Primary key. A primary key should be a column with unique identifiers. A column with unique values is essential for Hightouch to sync data efficiently. Click Finish.
Once you've finished, your model appears on the Models overview page and you can use it to set up syncs.
To set up a sync, you need to connect a destination.
Destinations are the tools and services you want to receive data from your source. You need to connect your destination to Hightouch before you can set up the sync configuration to the destination.
Select the destination you want to add and click Continue.
If you want to test things out without connecting a production destination,
you can use the Google Sheets destination.
Google Sheets is a lite destination
and straightfoward to set up.
Authorize connecting to your destination or enter the relevant credentials and inputs. These differ depending on the destination. Refer to the relevant destination documentation for further details.
Click Continue. Before continuing, Hightouch validates that you have the necessary access and permissions. If the test fails, you need to confirm and re-enter your credentials.
Give your destination a Destination name. This name is how your destination appears in the Hightouch workspace. It helps to include details about the destination's business purposes and owners, particularly if you plan on connecting multiple instances of the destination, for example, a development and prod version.
Click Finish.
Once you've finished, your destination appears on the Destinations overview page and you can use it configure syncs.
Syncs declare how your source data should appear in your destination. To configure one, you need to have set up a source, model, and destination first.
Select the relevant model connected to the source from which you want to pull data. If you need help determining which model to choose, you can select View query to see the model's definition.
Select the destination you want to send data to.
Configure how you want to sync data to your destination. Configuration inputs differ depending on the destination. Refer to the relevant destination documentation for further details. Click Continue.
Set a schedule for the sync. You can learn more about scheduling options in the sync overview docs.
Click Finish.
Once you've finished configuring a sync, you land on that sync's overview page. This page shows previous sync runs and lets you edit its Configuration, Schedule, and set up Alerts. It's also home to the live debugger which helps understand previous runs down to the API request and response level. To learn more about the sync overview page, check out the sync documentation.
To run the sync manually, click Run. Check in your destination to see the fruits of your labor.
Ready to get started?
Jump right in or a book a demo. Your first destination is always free.