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.

Una visión detallada de este conector, incluye enlaces útiles y funcionalidad compatible.

Función/Capacidad	Detalles de compatibilidad
Compatibilidad con proyectos de Qlik Talend Data Integration	Solo proyectos de replicación. No se admiten proyectos de canalización de datos.
Métodos de actualización de destinos	Tareas de replicación: Aplicar los cambios Guardar cambios Tareas de aterrizaje de datos en un lago de datos: Captura de datos de cambios (CDC)
Administrar los metadatos	No es necesario generar metadatos manualmente.
Evolución del esquema	Solo se admite la operación Cambiar tipo de datos de columna.
Replicación de columnas LOB (NCLOB, CLOB y BLOB)	No admitido.
CDC programado	Obligatorio. Así es como el destino se mantiene actualizado con los cambios en la fuente. Para tareas de replicación, vea Programar tareas Para tareas de aterrizaje en un lago de datos, vea Programación de CDC para tareas de destino/aterrizaje en un lago de datos
Notificaciones	Parcialmente compatible Configuración de notificaciones sobre cambios
Supervisión	Solo CDC, ya que la carga completa no es relevante para este conector. Supervisar una tarea individual de datos
Descarte automático de cargas útiles de columnas JSON	No admitido. Las cargas útiles de columnas JSON en los conjuntos de datos de origen no se deniegan automáticamente en el destino.

Preparing for authentication

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

Asegúrese de que la cuenta que utiliza tenga acceso de lectura a las tablas que desea recuperar.

You must have administrative privileges to create an OAuth2 App in your Harvest account.

To create your client ID and secret:

Log into your Harvest account.
Go to the Developers tab.
In the new OAuth2 application section, specify the following requirements:
- Name: Enter a name.
- Redirect URL: Set it to https://connector.qlik.com/auth/oauth/v3.htm.
- Access: Select the account from which you want to replicate data.
- Products: Select the Harvest and Forecast products.
Click Create application.
Copy and paste your client ID and secret into a secured file.

To retrieve your account ID:

Log into your Harvest account.
Go to the Developers tab.
Click Create new personal access token.
Enter a name for the token.
Copy and paste your account ID into a secured file.

Creating the connection

Para más información, vea Conectar con aplicaciones SaaS.

Haga clic en Autenticar cuando haya completado la configuración de conexión requerida.
Es posible que se le solicite que inicie sesión en la aplicación de origen.
Se mostrará una ventana con un código de autenticación.
Copie el código en el portapapeles y regrese al cuadro de diálogo de conexión.
Pegue el código en Autenticación completa con el código proporcionado por la fuente y haga clic en Verificar.
Nota de sugerenciaEs posible que tenga que desplazarse hacia abajo para ver este campo.
Cuando el estado es Verificado, se verifica la autenticación.
Proporcione un nombre para la conexión en Nombre de la conexión.
Seleccione Abrir metadatos de conexión para definir metadatos para la conexión cuando se haya creado.

Connection settings
Setting	Description
Data gateway	Seleccione una Data Movement gateway si su caso de uso así lo requiere. Nota informativa Este campo no está disponible con la suscripción Qlik Talend Cloud Starter porque Data Movement gateway no se admite. Si tiene otro nivel de suscripción y no desea utilizar Data Movement gateway, seleccione Ninguna. Para obtener información sobre las ventajas de Data Movement gateway y los casos de uso que lo requieren, consulte Pasarela de movimiento de datos de Qlik.
Start Date	Indique la fecha, en el formato `MM/DD/YYYY`, a partir de la cual deben replicarse los datos de su fuente a su destino.
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

¿Esta página le ha sido útil?

Si encuentra algún problema con esta página o su contenido (errores tipográficos, pasos que faltan o errores técnicos), no dude en ponerse en contacto con nosotros.

Deje aquí sus comentarios