Creating and Modifying Activations
On This Page
Using Hevo Activate, you can create Activations to sync data from your Source data warehouse to a Target CRM application. Activations are incremental in terms of the data that is loaded. 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 data 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, select an existing data warehouse where the data to be activated is present. Else, click ADD WAREHOUSE to configure one now. Data warehouses set up as Destinations for Hevo Pipelines are also available for selection.
Note: Hevo supports Amazon Redshift, Google BigQuery and Snowflake as Activate Warehouses.
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 where the data is to be loaded. 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.
In case of Amazon Redshift and Google BigQuery data warehouses, you must prefix the dataset name to the table name. In the image above,
DEMO.DBis the dataset name.
Note: The UNSAVED CHANGES text is displayed on the SQL Query dialog if you modify a saved query, till it is tested and verified.
In the right pane, select the Target object and verify if it contains the fields to which the corresponding Source fields can be mapped.
Note: If the required Target object does not exist, you can create one in the respective CRM application.
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 Source fields to Target fields
In the Field Mapping page:
In the Select the Sync Behavior field, select an option to define how the data must be loaded:
Add New Rows: Directly add new rows after the last record.
Update Existing Rows: Look for existing records based on primary key information to update them. If no existing records exist, the new fields are inserted as new records.
Insert New and Update Existing Rows: Adds new rows after the last record and updates existing records.
Under Query Fields, select the check box next to the fields to be mapped. All unselected fields are dropped.
If the sync mode is Update Existing Rows or Insert New and Update Existing Rows, you must select at least one unique identifier field based on which the records are updated in the Target CRM application. The unique identifier cannot be changed once the Activation is created and is disabled during the Change Mapping action.
Under Target Fields, select the respective fields to which you want to map the query fields.
Note: Activate automatically selects the best matching Target object fields by default. You can change the selection from the drop-down.
Specify a unique Activation Name.
Click CREATE ACTIVATION.
Modifying an Activation
You can modify an Activation to change the:
Frequency of ingesting data
Mapping of the ingested fields to the CRM object.
SQL Query for fetching data. The UNVERIFIED CHANGES label is displayed till the new query is tested and validated.
Refer to the following table for the list of key updates made to this page:
|Date||Release||Description of Change|
|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.|