tWorkdayInput Standard properties - Cloud - 8.0

Workday

Version
Cloud
8.0
Language
English (United States)
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Business applications > Workday components
Data Quality and Preparation > Third-party systems > Business applications > Workday components
Design and Development > Third-party systems > Business applications > Workday components

These properties are used to configure tWorkdayInput running in the Standard Job framework.

The Standard tWorkdayInput component belongs to the Business and the Cloud families.

The component in this framework is available in all subscription-based Talend products.

Basic settings

Property Type

Select the way the properties will be set.

Two options are provided: Built-In and Repository.

  • Built-In: Use the properties set for the current component in the Basic settings and Advanced settings views.
  • Repository: Use the properties stored in the repository.

Schema and Edit schema

A schema is a row description. It defines the number of fields (columns) to be processed and passed on to the next component. When you create a Spark Job, avoid the reserved word line when naming the fields.

  • Built-In: You create and store the schema locally for this component only.

  • Repository: You have already created the schema and stored it in the Repository. You can reuse it in various projects and Job designs.

Click Edit schema to make changes to the schema.
Note: If you make changes, the schema automatically becomes built-in.
  • View schema: choose this option to view the schema only.

  • Change to built-in property: choose this option to change the schema to Built-in for local changes.

  • Update repository connection: choose this option to change the schema stored in the repository and decide whether to propagate the changes to all the Jobs upon completion. If you just want to propagate the changes to the current Job, you can select No upon completion and choose this schema metadata again in the Repository Content window.

Guess schema

Click this button to generate the schema based on the client data retrieved or Workday client report.

Authentication mode

Select an authentication mode among REST - Client ID authentication mode (deprecated), SOAP - Login authentication mode, and SOAP - WS Security authentication mode.

REST - Client ID authentication mode (deprecated) and SOAP - Login authentication mode are provided by HTTPS protocol. For SOAP - WS Security authentication mode, the authentication information is included in the messages. See WS Security for related information.

Client Identifier

Enter the Client ID of the API Client used to connect to Workday.

This field is available when you select REST - Client id authentication mode (deprecated) from the Authentication mode drop-down list.

Client Secret

Click […] and enter the Client secret key of the API Client used to connect to Workday in double quotation marks.

This field is available when you select REST - Client id authentication mode (deprecated) from the Authentication mode drop-down list.

User login

Enter the username for the SOAP login authentication mode.

This field is available when you select SOAP - Login authentication mode from the Authentication mode drop-down list.

User password

Click […] and enter the password for the SOAP login authentication mode.

This field is available when you select SOAP - Login authentication mode from the Authentication mode drop-down list.

Tenant Alias

Enter the Tenant ID that allows you to connect to Workday. The tenant alias is provided by your Workday administrator. The following gives an example: tenant_alias.

Mode

Select the mode for retrieving client data. You can select Workday Query Language or Report As A Service from the list.

WS-Security Type

Select the WS Security type from the drop-down list: WS Security with basic authentication, WS Security with certificate authentication, or WS Security with JWT authentication.

This option is available when you select SOAP - WS Security authentication mode from the Authentication mode drop-down list.

Note: The WS Security with JWT authentication option is available only when you have installed the R2021-12 Studio Monthly update or a later one delivered by Talend. For more information, check with your administrator.

Login and Password

Enter the username and password for the SOAP - WS Security authentication mode.

These two options are available when you select SOAP - WS Security authentication mode from the Authentication mode drop-down list.

Integration system user

Enter the integration system user.

Creating an integration system user is the first step to build an SOAP request with x509 certificate. You can create an integration system user by carrying out the Create Integration System User task in Workday.

Note: This field is available when you select SOAP - WS Security authentication mode from the WS-Security type drop-down list.

X509 certificate

Enter your X.509 certificate content.

You can create an X.509 certificate by carrying out the Create x509 public key task in Workday.

Note: This field is available when you select SOAP - WS Security authentication mode from the WS-Security type drop-down list.

Private key

Enter the private key.

Note: This field is available when you select SOAP - WS Security authentication mode from the WS-Security type drop-down list.
WQL Query

Enter Workday query language statements for retrieving client data.

This field is available when Workday Query Language is selected from the Mode list.

Report Owner

Enter the report owner for the client data retrieved.

This field is available when Report As A Service is selected from the Mode list.

Report Name

Enter the report name for the client data retrieved.

This field is available when Report As A Service is selected from the Mode list.

Advanced settings

tStatCatcher Statistics

Select this check box to gather the Job processing metadata at the Job level as well as at each component level.

Authentication End Point

Enter the authentication endpoint.

Service EndPoint

Enter the Web service endpoint.

Global Variables

ERROR_MESSAGE

The error message generated by the component when an error occurs. This is an After variable and it returns a string.

NB_LINE

The number of rows processed. This is an After variable and it returns an integer.

Usage

Usage rule

This component is usually used as a start component of a Job or subJob and it always needs an output link.