Hevo Activate

Last updated on Jan 17, 2023

Hevo Activate is a data automation platform that enables you to synchronize raw data residing in your data warehouse with your Target CRM application. The data warehouse tables may hold data loaded from different Sources, for instance, SaaS applications, such as Facebook and LinkedIn, or JDBC Sources, such as MySQL, and webhook Sources, such as SendGrid. With Hevo Activate, you can build powerful SQL queries to get a unified view of this disparate data and transform it for use by your CRM application.

Core Concepts

The following are some integral features that make up Hevo Activate:

SQL Query Editor

Use the powerful and smart SQL Query Editor to filter and transform data from your data warehouse table to a Target object. The in-built validation checks ensure each query is validated before you save it.

Visual Schema Mapper

Use the intuitive UI-based schema mapping options to map fields across tables and objects. The mapping feature also warns you of any incompatible mappings you select.

Custom Data Synchronization

Select from a variety of frequencies to schedule an Activation or perform it in real-time. Activate also offers you the flexibility to deduplicate the data or directly load it to the Target object.

Incremental Updates

Subsequent to the initial loading of the output of your SQL queries, Activate uploads only changed and new Events, to ensure faster and more efficient sync operations.

Bulk APIs

Hevo Activate uses Bulk APIs, and these are optimized to fetch only incremental data, or data that has changed since the last synchronization.

Intelligent Data Type Conversion

Hevo Activate automatically converts field types of the synchronized data during the mapping action. Both Auto-Mapping and Manual Mapping provide you with valid data types to select from.

Data Recovery

In case of any disruption to the Activation due to loss of connectivity to the Target environment or any other reason, you are immediately notified as per your communication settings. Once the connection is re-established, Activate automatically resumes the data synchronization, so you do not lose any data.

Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
May-19-2021 1.63 Updated the content to mention that Hevo now supports Snowflake as a Pipeline Destination for creating Activations.

Tell us what went wrong