On This Page
Hevo Activate is a data automation platform that enables you to sync 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.
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.
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.
Hevo Activate uses Bulk APIs, and these are optimized to fetch only incremental data, or data that has changed since the last sync.
Intelligent Data Type Conversion
Hevo Activate automatically converts field types of the synced data during the mapping action. Both Auto-Mapping and Manual Mapping provide you with valid data types to select from.
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, Hevo automatically resumes the data sync, so you do not lose any data.
- Articles in this section
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.|