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.

Immagine di alto livello di questo connettore, inclusi collegamenti utili e funzionalità supportate.

Funzionalità/Capacità	Dettagli del supporto
Progetti Qlik Talend Data Integration supportati	Solo i progetti di replica. I progetti delle pipeline di dati non sono supportati.
Metodi di aggiornamento della destinazione	Attività di replica: Applica modifiche Archivia modifiche Trasferimento dei dati nelle attività di un data lake: Change Data Capture (CDC)
Gestione dei metadati	La generazione manuale dei metadati non è richiesta.
Evoluzione dello schema	È supportata solo l'operazione Cambia tipo di dati colonne.
Replica delle colonne LOB (NCLOB, CLOB e BLOB)	Operazione non supportata.
CDC pianificato	Operazione richiesta. In questo modo la destinazione viene aggiornata con le modifiche apportate alla sorgente. Per le attività di replica, vedere Attività di pianificazione Per le attività di trasferimento su data lake, vedere Pianificazione delle attività CDC per i processi di trasferimento su data lake
Notifiche	Operazione parzialmente supportata Impostare notifiche quando vengono apportate modifiche al funzionamento
Monitoraggio	Solo attività CDC, in quanto il caricamento completo non è rilevante per questo connettore. Monitoraggio di un'attività dati individuale
Annullamento automatico della nidificazione dei payload nelle colonne JSON	Operazione non supportata. La nidificazione per i payload della colonna JSON nei set di dati di origine non viene annullata automaticamente nella destinazione.

Preparing for authentication

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

Assicurarsi che l'account utilizzata disponga di accesso di lettura per le tabelle che si desidera recuperare.

Creating the connection

For more information, see Connessione alle applicazioni 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.
Nota di suggerimentoYou 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	Selezionare un Gateway Data Movement se richiesto dal proprio caso di utilizzo. Nota informatica Questo campo non è disponibile con la sottoscrizione a Avvio Qlik Talend Cloud, poiché non supporta il Gateway Data Movement. Se si dispone di un altro livello di sottoscrizione e non si desidera utilizzare il Gateway Data Movement, selezionare Nessuno. Per informazioni sui vantaggi del Gateway Data Movement e quando è richiesto, vedere Qlik Data Gateway - Movimento dati.
Start Date	Inserire la data, nel formato `MM/DD/YYYY`, a partire dalla quale i dati devono essere replicati dalla sorgente alla destinazione.
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

Hai trovato utile questa pagina?

Se riscontri problemi con questa pagina o con il suo contenuto – un errore di battitura, un passaggio mancante o un errore tecnico – ti pregiamo di farcelo sapere!

Lascia qui il tuo feedback