Hevo Activate

Hevo Activate is a data automation platform that enables you to load raw data from your data warehouse to your Target CRM application. This may include data loaded from Sources such as SaaS-based applications, databases, and webhooks. With Hevo Activate, you can build powerful SQL queries to get a unified view of this disparate data, which can then be transformed for use by your CRM application.

---

Key Features

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

SQL Query Editor

The powerful and smart SQL Query Editor enables you to retrieve and transform data from your data warehouse table and load it to a Target object. Its in-built checks ensure that each query you save is valid.

---

Visual Schema Mapper

The intuitive UI-based schema mapping makes it easy for you to map the fields across tables and objects. It also warns you of any incompatible mappings you select.

---

Custom Data Synchronization

Activate allows you to select from a variety of frequencies to schedule an Activation or to run it in real time. You can either deduplicate the data or directly load it to the Target object.

---

Incremental Updates

After the initial loading of the SQL query output to the Target object, Activate loads only changed and new records to it. This ensures faster and more efficient sync operations.

---

Bulk APIs

Hevo Activate uses Bulk APIs to sync your data. These APIs are optimized to fetch only incremental data and data that has changed since the last sync.

---

Data Recovery

If an Activation halts due to loss of connectivity with the Target environment or any other reason, you are immediately notified as per your alert settings. Once the connection is re-established, Activate resumes the data synchronization, so you do not lose any data.

---

Explore Activate

• Activate ConceptsLearn how Hevo Activate handles data ingestion and replication from your data warehouse to the Target.
  • Synchronization Behaviors
  • Data Synchronization Identifiers
  • Field Mapping
  • Bookkeeping
  • Activation Run Statuses
• Familiarizing with the Activate UILearn how to navigate the Activate home page and create your first Activation.
• Working with ActivateLearn how to replicate data from your data warehouse to a Target CRM application with No-Code Activations.
  • Creating an Activation
  • Modifying an Activation
  • Scheduling an Activation
  • Viewing Activation Run Details
  • Common Issues Seen in Activation Runs
• Activate WarehousesLearn about the data warehouses Activate supports as the repository for the data you replicate to your Target.
  • Amazon Redshift
  • Google BigQuery
  • PostgreSQL
  • Snowflake
• Activate TargetsLearn about the CRM applications you can synchronize data to as a Target in Hevo Activate.
  • HubSpot
  • Salesforce