Harvest Forecast

Harvest Forecast is a web-based project management and resource scheduling tool that helps teams plan, track, and allocate their people and time efficiently across multiple projects.

Harvest Forecast integration replicates data using the Harvest Forecast Experimental API.

See the Schema section for a list of objects available for replication.

Présentation générale de ce connecteur, y compris des liens utiles et les fonctions supportées.

Caractéristique/Fonctionnalité	Détails du support
Projets Qlik Talend Data Integration supportés	Projets de réplication uniquement. Les projets de pipeline de données ne sont pas supportés.
Méthodes de mise à jour de la cible	Tâches de réplication : Appliquer les modifications Stocker les modifications Tâches de dépôt temporaire de données dans un lac de données : Change Data Capture (CDC)
Gestion des métadonnées	La génération manuelle de métadonnées n'est pas nécessaire.
Évolution du schéma	Seule l'opération Modifier le type de données de la colonne est supportée.
Réplication de colonnes LOB (NCLOB, CLOB et BLOB)	Non supporté.
Opération CDC planifiée	Requis. C'est ainsi que la cible est mise à jour en fonction des modifications apportées à la source. Pour les tâches de réplication, consultez Planification de tâches . Pour les tâches de dépôt temporaire dans un lac, consultez Planification de CDC pour les tâches de dépôt temporaire dans un lac.
Notifications	Partiellement supporté Définition de notifications en cas de modifications du fonctionnement
Monitoring	CDC uniquement, car Chargement complet n'est pas pertinent pour ce connecteur. Surveillance d'une tâche de données individuelle
Désimbrication automatique des charges utiles des colonnes JSON	Non supporté. Les charges utiles des colonnes JSON des jeux de données sources ne sont pas automatiquement désimbriquées sur la cible.

Preparing for authentication

To access your data, you need to authenticate the connection with your account credentials.

Assurez-vous que le compte que vous utilisez dispose d'un accès en lecture sur les tables à récupérer.

Creating the connection

For more information, see Connexion à des applications SaaS.

Click Authenticate when you have filled in the required connection settings.
You may be asked to log in to the source application.
A window is displayed with an authentication code.
Copy the code to the clipboard and return to the connection dialog.
Paste the code in Complete authentication with the code provided by the source and click Verify.
Note ConseilYou may need to scroll down to see this field.
When status is Verified, the authentication is verified.
Provide a name for the connection in Connection name.
Select Open connection metadata to define metadata for the connection when it has been created.

Connection settings
Setting	Description
Data gateway	Sélectionnez une Passerelle de déplacement des données si cela est nécessaire pour votre cas d'utilisation. Note Informations Ce champ n'est pas disponible avec l'abonnement Démarreur Qlik Talend Cloud, car il ne supporte pas Passerelle de déplacement des données. Si vous avez un autre niveau d'abonnement et si vous ne souhaitez pas utiliser Passerelle de déplacement des données, sélectionnez Aucune. Pour des informations sur les avantages de Passerelle de déplacement des données et les cas d'utilisation qui la nécessitent, consultez Passerelle de données Qlik - Déplacement des données.
Start Date	Saisissez la date, au format `MM/DD/YYYY`, à partir de laquelle les données doivent être répliquées de votre source vers votre cible.
Account ID	Account ID.
Client ID	Client ID.
Client Secret	Client secret.

Schema

Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.

The schema and info displayed below is for version 1.

Depending on your destination, table and column names may not appear as they are outlined below.

assignments

The assignments table contains info about the assignments assigned to the people in your Harvest Forecast account.

Replication Method

Full Table

Primary Key

Useful links

Harvest Forecast documentation

Join assignments with	on
clients	assignments.person_id = clients.updated_by_id assignments.updated_by_id = clients.updated_by_id
milestones	assignments.person_id = milestones.updated_by_id assignments.updated_by_id = milestones.updated_by_id assignments.project_id = milestones.project_id
people	assignments.person_id = people.id assignments.updated_by_id = people.id assignments.person_id = people.updated_by_id assignments.updated_by_id = people.updated_by_id
projects	assignments.person_id = projects.updated_by_id assignments.updated_by_id = projects.updated_by_id assignments.project_id = projects.id
placeholders	assignments.person_id = placeholders.updated_by_id assignments.updated_by_id = placeholders.updated_by_id assignments.placeholder_id = placeholders.id
roles	assignments.person_id = roles.updated_by_id assignments.updated_by_id = roles.updated_by_id assignments.placeholder_id = roles.placeholder_ids

active_on_days_off

BOOLEAN

allocation

INTEGER

end_date

DATE-TIME

INTEGER

notes

STRING

person_id

INTEGER

placeholder_id

INTEGER

project_id

INTEGER

repeated_assignment_set_id

INTEGER

start_date

DATE-TIME

updated_at

DATE-TIME

updated_by_id

INTEGER

clients

The clients table contains info about the clients in your Harvest Forecast account.

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Harvest Forecast documentation

Join clients with	on
projects	clients.id = projects.client_id clients.updated_by_id = projects.updated_by_id
assignments	clients.updated_by_id = assignments.person_id clients.updated_by_id = assignments.updated_by_id
milestones	clients.updated_by_id = milestones.updated_by_id
people	clients.updated_by_id = people.id clients.updated_by_id = people.updated_by_id
placeholders	clients.updated_by_id = placeholders.updated_by_id
roles	clients.updated_by_id = roles.updated_by_id

archived

BOOLEAN

harvest_id

INTEGER

name

STRING

updated_at

DATE-TIME

updated_by_id

INTEGER

milestones

The milestones table contains info about the project milestones in your Harvest Forecast account.

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Harvest Forecast documentation

Join milestones with	on
assignments	milestones.updated_by_id = assignments.person_id milestones.updated_by_id = assignments.updated_by_id milestones.project_id = assignments.project_id
clients	milestones.updated_by_id = clients.updated_by_id
people	milestones.updated_by_id = people.id milestones.updated_by_id = people.updated_by_id
projects	milestones.updated_by_id = projects.updated_by_id milestones.project_id = projects.id
placeholders	milestones.updated_by_id = placeholders.updated_by_id
roles	milestones.updated_by_id = roles.updated_by_id

date

DATE-TIME

INTEGER

name

STRING

project_id

INTEGER

updated_at

DATE-TIME

updated_by_id

INTEGER

people

The people table contains info about the people in your Harvest Forecast account.

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Harvest Forecast documentation

Join people with	on
assignments	people.id = assignments.person_id people.updated_by_id = assignments.person_id people.id = assignments.updated_by_id people.updated_by_id = assignments.updated_by_id
clients	people.id = clients.updated_by_id people.updated_by_id = clients.updated_by_id
milestones	people.id = milestones.updated_by_id people.updated_by_id = milestones.updated_by_id
projects	people.id = projects.updated_by_id people.updated_by_id = projects.updated_by_id
placeholders	people.id = placeholders.updated_by_id people.updated_by_id = placeholders.updated_by_id people.roles = placeholders.roles
roles	people.id = roles.updated_by_id people.updated_by_id = roles.updated_by_id people.roles = roles.id

admin

BOOLEAN

archived

BOOLEAN

avatar_url

STRING

color_blind

STRING

email

STRING

first_name

STRING

harvest_user_id

INTEGER

last_name

STRING

login

STRING

personal_feed_token_id

INTEGER

roles

ARRAY

This is a nested data structure.

subscribed

BOOLEAN

updated_at

DATE-TIME

updated_by_id

STRING

weekly_capacity

INTEGER

working_days

OBJECT

This is a nested data structure:

friday: BOOLEAN
monday: BOOLEAN
saturday: BOOLEAN
sunday: BOOLEAN
thursday: BOOLEAN
tuesday: BOOLEAN
wednesday: BOOLEAN

placeholders

The placeholders table contains info about the placeholders in your Harvest Forecast account.

Replication Method

CDC

Primary Key

Replication Key

updated_at

Join placeholders with	on
assignments	placeholders.updated_by_id = assignments.person_id placeholders.updated_by_id = assignments.updated_by_id placeholders.id = assignments.placeholder_id
clients	placeholders.updated_by_id = clients.updated_by_id
milestones	placeholders.updated_by_id = milestones.updated_by_id
people	placeholders.updated_by_id = people.id placeholders.updated_by_id = people.updated_by_id placeholders.roles = people.roles
projects	placeholders.updated_by_id = projects.updated_by_id
roles	placeholders.updated_by_id = roles.updated_by_id placeholders.id = roles.placeholder_ids placeholders.roles = roles.id

archived

BOOLEAN

INTEGER

name

STRING

roles

ARRAY

This is a nested data structure.

updated_at

DATE-TIME

updated_by_id

INTEGER

projects

The projects table contains info about the projects in your Harvest Forecast account.

Replication Method	CDC
Primary Key	id
Replication Key	updated_at
Useful links	Harvest Forecast documentation

Join projects with	on
clients	projects.client_id = clients.id projects.updated_by_id = clients.updated_by_id
assignments	projects.updated_by_id = assignments.person_id projects.updated_by_id = assignments.updated_by_id projects.id = assignments.project_id
milestones	projects.updated_by_id = milestones.updated_by_id projects.id = milestones.project_id
people	projects.updated_by_id = people.id projects.updated_by_id = people.updated_by_id
placeholders	projects.updated_by_id = placeholders.updated_by_id
roles	projects.updated_by_id = roles.updated_by_id

archived

BOOLEAN

client_id

INTEGER

code

STRING

color

STRING

end_date

DATE-TIME

harvest_id

INTEGER

name

STRING

notes

STRING

start_date

DATE-TIME

tags

ARRAY

This is a nested data structure.

updated_at

DATE-TIME

updated_by_id

INTEGER

roles

The roles table contains info about the roles in your Harvest Forecast account.

Replication Method

Full Table

Primary Key

Join roles with	on
assignments	roles.updated_by_id = assignments.person_id roles.updated_by_id = assignments.updated_by_id roles.placeholder_ids = assignments.placeholder_id
clients	roles.updated_by_id = clients.updated_by_id
milestones	roles.updated_by_id = milestones.updated_by_id
people	roles.updated_by_id = people.id roles.updated_by_id = people.updated_by_id roles.id = people.roles
projects	roles.updated_by_id = projects.updated_by_id
placeholders	roles.updated_by_id = placeholders.updated_by_id roles.placeholder_ids = placeholders.id roles.id = placeholders.roles

harvest_role_id

INTEGER

name

STRING

person_ids

ARRAY

This is a nested data structure.

placeholder_ids

ARRAY

This is a nested data structure.

updated_at

DATE-TIME

updated_by_id

INTEGER

Cette page vous a-t-elle aidé ?

Si vous rencontrez des problèmes sur cette page ou dans son contenu – une faute de frappe, une étape manquante ou une erreur technique – faites-le-nous savoir.

Laissez vos commentaires ici