Rules and Guidelines for Workday Operations
Consider the following rules and guidelines for Workday Connector read and write operations:
- •When you configure a Source transformation in a mapping to fetch instant updates from Workday, you must pass the Date Time attributes in Pacific Time. For example, when you specify the update to and from fields, use the yyyy-mm-ddThh:mm:ss format.
- •When you read data from Workday that contains the Date Time attributes and then write to a flat file, the Secure Agent writes the Date Time in Eastern Standard Time (EST).
- •When you use Workday Connector to read or write data, the Secure Agent maps binary data to string. To read documents or images from Workday, you must convert base64 string to binary and then load it to the target. To write images and documents to Workday, you must read the images and documents in binary format from the source, convert it to base64 string, and then load it to the Workday target. If the source contains the base64 string value representing the file, you can directly map the field to the Workday target.
- •When you configure a Workday connection, test connection validates only for the Human Resources module. When you specify a module other than Human Resources in the Workday connection, you can verify that the connection is valid only if the mapping task runs successfully.
- •You do not need to set the WorkdayBatchSize property in the pmrdtm.cfg file. Instead, set the batch size in the advanced source property.
- •When you specify a batch size for a task enabled with input streaming for retrieving a huge volume of data, you must reduce the value of the count element attribute in the request.
- •When you configure a request to retrieve more than one page from Workday, specify the value for As_Of_Entry_DateTime parameter in the XML request to ensure that the data set that you retrieve does not change when you process the data. This parameter filters the data returned in the response property by the date and time when the data was entered into the system. If you do not specify a value, the property value defaults to the current date and time.
JVM Options and Cache Size Configurations for Workday Connector
To read large number of records from Workday, you must perform the following steps:
- •Set the JVM options for type DTM to increase the -Xms and -Xmx values in the system configuration details of the Secure Agent, and then restart the Secure Agent.
- •You can perform one of the following tasks when you specify the cache size:
- - You can increase the cache size for the web service response in the advanced properties of the Workday source transformation to a size equal to or more than the memory required for a SOAP response. The value may differ for different Workday modules and count specified in request.xml.
- - When you specify a cache size value that is smaller than the SOAP response, input streaming is enabled. Input streaming allows you to read large web service responses from Workday.
Reading and Writing Unicode Characters
The Secure Agent reads and writes Unicode data using the UTF-8 code page. The Secure Agent requires that the code page environment variable be set to UTF-8.
Before you run a task to read or write unicode characters, you must set the environmental variable on the machine that runs the Secure Agent.
- 1. Perform the following tasks based on the Windows or Linux 64 machine where you installed the Secure Agent:
- - For Windows, create an environmental variable INFA_CODEPAGENAME under System Variables, and then set it to UTF-8.
- - For Linux 64, set the environmental variable LC_ALL to en_US.utf8. To set the environmental variable, run the following command from Linux 64: setenv LC_ALL en_US.utf8
- 2. Restart the Secure Agent after you set the environmental variable.