Hive

Last updated on May 30, 2023

Prerequisites

An Active Hive account from which data to be ingested exists.
You are assigned the Team Administrator, Team Collaborator, or Pipeline Administrator role in Hevo to create the Pipeline.
The API credentials are available to authenticate Hevo on your Hive account.

Hevo uses the Hive user ID, API key, and workspace ID for authentication purposes.

Perform the following steps to obtain these API credentials from your Hive account:

Log in to your Hive account.
In the top right corner, click on your username icon, and select Edit profile from the drop-down menu.
In the left navigation pane, click API info.
From the API info page, copy the API Key, User ID, and Workspace ID, and save them securely like any other password.

You have successfully obtained your API credentials. Use these credentials for creating Hevo Pipelines.

Perform the following steps to configure Hive as the Source in your Pipeline:

Click PIPELINES in the Navigation Bar.
Click + CREATE in the Pipelines List View.
In the Select Source Type page, select Hive.
In the Configure your Hive Source page, specify the following:
- Pipeline Name: A unique name for the Pipeline, not exceeding 255 characters.
- API Key: The API key that you obtained from your Hive account.
- User ID: The user ID that you obtained from your Hive account.
- Workspace ID: The ID of the Hive workspace from where you want to ingest data.
Click TEST & CONTINUE.
Proceed to configuring the data ingestion and setting up the Destination.

Default Pipeline Frequency	Minimum Pipeline Frequency	Maximum Pipeline Frequency	Custom Frequency Range (Hrs)
1 Hr	1 Hr	24 Hrs	1-24

Note: You must set the custom frequency in hours as an integer value. For example, 1, 2, 3 but not 1.5 or 1.75.

Hevo ingests all the objects in Full Load mode in each run of the Pipeline.

Hevo uses the following schema to upload the records in the Destination database:

The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:

Object	Description
Projects	Contains details about the containers used for organizing actions in your Hive account.
Actions	Contains details of the tasks assigned to different users in your Hive account.
Users	Contains details about the individuals who have access to log into your Hive account and manage certain features depending on their user permissions.
Teams	Contains details of the different user groups in your Hive account.
Labels	Contains details about the different color tags used to filter and sort actions in Hive.
Groups	Contains the list of all the chat groups created by users in your Hive account.
Custom Fields	Contains details of the customized fields added by a user to capture some additional data.
Project Statuses	Contains the list of current statuses of projects in your Hive account.
Resource Assignments	Contains details of the time windows allocated to users to complete certain projects.
Project Tags	Contains details about the tags assigned to projects.
Role Tags	Contains details about the roles that can be assigned to users to allow them to access features in Hive.
User Tags	Contains details of all the possible tags that a user can have in your Hive account.

Read the detailed Hevo documentation for the following related topics:

Pagination: Each API call for a Hive object fetches one page with up to 200 records for Actions, Labels, Project Statuses & Project Assignments objects and 100 records for all other objects.
Rate Limit: Hive imposes a limit of 50 API calls per minute per account to ensure that their system remains stable for usage by all users.

Hevo does not capture information for records deleted in the Source objects.
Resource Assignments, Project Tags, User Tags & Role Tags objects are available only when Resourcing has been enabled. In addition, these objects are available only if you are subscribed to a paid plan in Hive.

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

Date	Release	Description of Change
Dec-20-2022	2.04	New document.