Creating an Activation
On This Page
Using Hevo Activate, you can create Activations to synchronize data from your Activate Warehouse with a Target CRM application. Activations are incremental in terms of the data that is synchronized. You can schedule an Activation to run at a pre-defined frequency. However, you can also restart an (incremental) Activation or use the Run Now option to run it on-demand.
- A CRM database is configured as the Target system.
Creating an Activation
Perform the following steps to create an Activation:
Select the Warehouse to load data from
In the Asset Palette, click ACTIVATE.
If you are creating your first Activation, click +CREATE ACTIVATION in the Activate home page.
Else, click + CREATE ACTIVATION in the Activations List View.
In the Select Warehouse page, do one of the following:
Select an existing data warehouse that holds the data to be activated. This could be an Activate Warehouse or a data warehouse configured as a Destination for Hevo Pipelines. Hevo supports Amazon Redshift, Google BigQuery, and Snowflake as Activate Warehouses.
Hevo validates the permissions granted to the configured database user in the selected Warehouse. If the database user does not have the necessary permissions to access the selected Warehouse, then an error as shown in the following image is displayed:
Click +ADD WAREHOUSE to configure a new data Warehouse.
Read Activate Warehouses for detailed steps to configure the data warehouses.
Specify the Target details
In the Select a Target page, select a Target CRM application with which you want to synchronize the data. Alternatively, click + ADD TARGET to configure one now.
Read Activate Targets.
Select the Data to be Synchronized
In the Select the Data to Synchronize page:
Create the SQL QUERY to fetch data from one or multiple tables of your data warehouse. When selecting the columns in your SQL query, you should ensure that the column names do not contain any special characters or reserved keywords, as this may cause the Activation run to fail. However, if your selected Warehouse allows special characters in the column names, to include those columns in your SQL query, you must alias the column names. Read Common Issues Seen in Activation Runs for the steps to do this or your data warehouse documentation.
In the case of Amazon Redshift and Google BigQuery data warehouses, you must prefix the dataset name to the table name. For example, in the image above, the dataset name is demo.
Note: The UNVERIFIED CHANGES label is displayed on the SQL QUERY dialog if you modify a saved query until the changes are validated and saved.
In the right pane, select the Target object. You can select from the displayed STANDARD or CUSTOM objects. For the selected object, verify that it contains the fields to which you want to map the corresponding Activate Warehouse fields.
- If you have added a new field to your Target object, click the Refresh icon to get the changes. For Salesforce objects, read Salesforce Target Considerations if newly added fields are not visible even after a refresh.
- For some Targets, you do not need to select a Target object here. For example, while configuring Google Sheets as a Target, you select a worksheet (Target object) only in the Field Mapping page.
Click TEST QUERY to validate the query.
Note: For a Google BigQuery data warehouse, you must have an active Google Service Account.
After the query is successfully tested, click TEST & MAP FIELDS.
Map Warehouse fields to Target fields
Perform the following steps to map the Warehouse fields with the Target fields. For some Targets, the Field Mapping page may differ. Read the respective Target’s Field Mapping section for the specifics.
In the Field Mapping page, specify the following:
Select the Target Object: Select the Target object to synchronize data with. You can select from the displayed STANDARD or CUSTOM objects. Once you do this, the synchronization behaviors get enabled for selection. If you had selected a Target object in the Select the Data to be Synchronized step, the same object is displayed here. You can change this value.
Select the Sync Behavior: Select an option to define how the data must be synchronized.
Query Field(s): Select the check box next to the fields to be mapped. All mapped fields are automatically disabled for selection. Once the Activation is created, all unselected fields are dropped.
Note: In most Targets, for all sync behaviors except Insert, you must select at least one identifier field. Activate updates the records in the Target object based on these identifiers. The identifiers cannot be changed once the Activation is created and are disabled during the Update Existing Mapping action. Read the Data Model section of the respective Target for the identifiers that you can use.
Target Object Field(s): Select the respective fields to which you want to map the query fields. You must map the Target object fields to compatible query fields. The mapping categories are:
Fields you must map (Required): Map all the fields in this category. In the case of identifiers, whether unique or composite, and mandatory fields, the Target field(s) are automatically selected and you must map them to compatible type(s) from the query field(s). You can select a field from the drop-down only if there is more than one identifier available for the selected object.
For example, to synchronize data with the Zendesk Organizations object in the Upsert sync behavior, you can use
name. Therefore, both these fields will be available for selection from the drop-down.
Fields you want to map (Optional): Select the check box next to the query fields that you want to map with the Target object fields.
- Activate automatically selects the best matching Target object fields by default. You can change the selection from the drop-down.
- Once a Target field is mapped, it is disabled for selection from the drop-down.
- The mapping categories do not apply to Google Sheets. Read Field Mapping in Google Sheets.
Specify a unique Activation Name.
Click CREATE ACTIVATION.
Refer to the following table for the list of key updates made to this page:
|Date||Release||Description of Change|
|Jul-27-2022||NA||Updated the Select the Data to be Synchronized section to add information about special characters and reserved keywords in the SQL query.|
|Mar-21-2022||1.84 & 1.85||Updated the sections, Select Data to be Synchronized and Map Warehouse fields to Target fields to add information about segregated display of Target objects.|
|Mar-07-2022||1.83||- Created as a new document.
- Updated the sections, Select Data to be Synchronized and Map Warehouse fields to Target fields to add information explaining the changed functionality while displaying Target object fields.
- Moved section, Modifying an Activation to a new page.
|Feb-21-2022||NA||- Updated section, Select the Data to be Synchronized to include a reference to the Target behavior.|
|Jan-24-2022||NA||Updated section, Map Warehouse fields to Target fields to include a reference to the Target documentation pages.|
|Dec-06-2021||NA||Updated the screenshots and content to reflect the latest user interface and functionality.|
|Nov-22-2021||1.76||- Renamed the section, Map Source fields to Target fields to Map Warehouse fields to Target fields
- Updated the step, Select the Sync Behavior to include the new sync modes and inform about them being dynamically displayed.
- Updated the screenshots to reflect the latest user interface and functionality.
|Aug-23-2021||1.70||Modified the note in Step 2 of section, Select the Data to be Synchronized to inform about refreshing the Target schema.|
|Jul-12-2021||1.67||Updated the steps for creating an Activation.
- Moved Scheduling an Activation to a new section.
|May-18-2021||1.63||Updated the content to reflect the latest user interface.|