When you select a Workday connection for a Target transformation, you can select an operation based on the imported WSDL.
You can add multiple input groups into the Workday target and define the primary and foreign key relationships between the multiple input groups before the mapping. View the request structure from the WSDL and map the input groups to the hierarchical structure before you write data to Workday.
Workday Target transformation properties
You can configure target properties, such as target details and advanced properties, based on the connection type you select. Configure target properties on the Target tab of the Properties panel.
When you select a Target transformation, the Properties panel displays the following areas and information:
•General. Defines the transformation name and a description.
•Incoming Fields. Includes the field rules that define the data written to the target. Allows a preview of target fields.
•Target. Defines the target connection, operation, and advanced options.
•Target Fields. Not applicable for Web Service targets.
•Input Settings. Defines whether the input data is presorted.
•Field Mapping. Defines the field mappings from the upstream transformation to the target.
Workday advanced target properties
In a mapping, you can configure a Target transformation to represent a Workday target. For Workday target connections used in mapping tasks, you can configure advanced properties in the Targets page of the Mapping Task wizard.
The following table describes the advanced properties that you can configure in a Target transformation:
Property
Description
Cache Size for Web Service Request (KB)
Memory available for the web service request. If the web service request contains many rows or columns, you might want to increase the cache size. Default is 100 KB.
Transaction Commit Control
Control to commit or roll back transactions based on the set of rows that pass through the transformation. Use the transaction commit control if you have a large amount of data and you want to control how it is processed.
Input settings properties
You can enable Sorted Input under Input Settings. Sorted Input indicates that input data is presorted. Default is disabled.
Enable sorted input for better performance.
Note: When Sorted Input is enabled and the input is not sorted, the Secure Agent does not process input and the mapping fails.
Target transformation mapping example
You are a human resources administrator and you want to update the legal name of an employee in Workday.
To update a legal entry for an employee in Workday from a flat file, perform the following tasks:
1Create a flat file connection to read data from the flat file.
The following table shows the last name, Chu, in the flat file that you want to update in Workday:
Field
Value
wkrref_worker_descriptor
chu
wkrref_worker_id
cf9f717959444023b9bc9226a2556661
wkrref_worker_type
WID
wkrref_FK_worker
42
Country_descriptor
United States of America
country_id
bc33aa3152ec42d4995f4791a106ed09
country_type
WID
FK_worker
42
First_Name
Lillian
Last_Name
Chu
PK_Worker
42
You need to prepare the file to include the corresponding reference information required for updating legal data in Workday. For more information, see File preparation for a target transformation.
2Create a Workday connection to write data to Workday. Verify that you select Human Resources as the Module name and specify the WSDL version in the connection properties.
The following image shows the configured Workday connection:
3Create a Workday mapping.
The following image shows the Workday mapping:
4Add a Source transformation to include the flat file object that contains the legal information. Add the flat file connection.
5Add an Expression transformation to add the required processing options for the business process and define the calculations that you want to perform:
- Auto_complete = true. Indicates that the business process is automatically processed.
- Run_now = true. Indicates that the transaction processes to completion before the response generates.
The following image shows the configured Expression transformation:
For more information on the required business process parameters to perform an operation in Workday, see the request parameters under the listed operations in the Workday Web Services (WWS) Directory.
6Add a Target transformation to write the legal data to Workday. Perform the following tasks on the Target tab:
aIn the Connection field, select the Workday connection to connect to Workday.
bIn the Operation field, select Change_Legal_Name as the operation.
The following image shows the Change_Legal_Name in the list of write operations:
cIn the Advanced Properties section, set the cache size and the transaction commit interval.
7On the Field Mapping tab, select the input elements to map to the target fields.
The following image shows all the mapped fields between the input file and the Workday target:
8When you save and run the mapping in a mapping task, the Secure Agent updates the legal name in Workday.
The following image shows the updated legal name in Workday:
