Skip to main content

Varicent ELT Assistant

Workday export

Connect your Varicent ELT and Workday accounts to export your data to your Workday account. This connection allows Varicent ELT to write data to Workday.

Set up the connector to be available for use with the Export tool. You only need to set up the connection once. After the connection is set up, Varicent ELT, can export data to your Workday account.

Note

When you create the import connector, if you want to preserve any dates in the out-of-bounds range during export, select Preserve out of bounds dates to maintain dates outside the range 12/31/9999.

Workday export fields

The following fields are available to export within the Workday export:

"employee_id"

"start_date"

"end_date"

"run_category"

"earning_code"

"amount"

"comment"

"batch_id"

Create the connection

Create the connection between Varicent ELT and Workday. Generate a new Workday connection or use an existing one.

Creating a new connection

  1. In Varicent ELT, from the sidebar navigation pane, select the Pipe module, and then go to your pipe.

  2. Add the Export tool.

  3. In the Export tool configuration section, click the Connection drop-down.

  4. In the connection drop-down, click + New connection.

  5. On the Create a connection page, click Workday.

  6. On the Connect to your database page, under Connector name, enter the name of the connection.

  7. Under Domain, enter the Workday domain name.

  8. Under Tenant, enter the Workday tenant, such as tenantTest.

  9. Under Authentication, select the type of authentication from the drop-down list: Basic (ISU username and password) or OAuth 2.0 (Workday API Client).

    • Basic (ISU username and password):

      • Under Username, enter the user name to access the connection, such as testUser@tenantTest.

        Note

        The username consists of username@tenant_name. For example, if the username is testUser, and the tenant name is tenantTest, the username that needs to be entered is testUser@tenantTest.

      • Under Password, enter the password to access the connection.

    • OAuth 2.0 (Workday API Client):

      • Under Client ID, enter the Workday Client ID to identify your Workday account.

      • Under Client Secret, enter the Workday Client Secret to identify and authenticate your Workday account.

      • Under Token endpoint URL, enter the Workday URL.

      • Under Token endpoint client authentication, select the authentication method to identify the authorization to request an access token:

        • HTTP Basic (Authorization header): Securely call and receive your custom reports from Workday through a URL.

        • Form body (client_id and client_secret): Authenticate with your client ID and secret.

      • Under Scopes, optionally select the functional areas.

      • Under Refresh token, enter the integer that specifies how long the refresh token is valid for in seconds. This value is used to periodically expire the refresh token.

  10. Click Next.

  11. On the Export tool configuration panel, enter the Batch Id.

  12. Click the Add timestamp suffix to select the Dynamic timestamp checkbox to append a timestamp at the end of the batch ID.

    The dynamic timestamp has the format: static_text_{YYYY-MM-DDThh_mm_ss.msZ}. For example, PAYROLL_RUN_2026-06-08T14_30_00.000Z.

  13. Click Export now.

    The data is now available to use in the Export tool. For more information about the tool, see Export.

Using your existing Workday connection

  1. In Varicent ELT, from the sidebar navigation pane, select the Pipe module, and then go to your pipe.

  2. Add the Export tool.

  3. In the Export tool configuration section, click the Connection drop-down.

  4. Search for and select your existing Workday export connection.

  5. In the Batch ID field, enter a name for the batch ID.

  6. Click the Add timestamp suffix to select the Dynamic timestamp checkbox to append a timestamp at the end of the batch ID.

    The dynamic timestamp has the format: static_text_{YYYY-MM-DDThh_mm_ss.msZ}. For example, PAYROLL_RUN_2026-06-08T14_30_00.000Z.

  7. Click Export now.

    The data is now available to use in the Export tool. For more information about the tool, see Export.

Error handling

The following errors may appear during the export process:

Error

Description

Export failed with the following error: message.

Export failed with an error.

WorkdayTotalFailureError

The error could be related to the not properly set column names. Workday requires either employee_id or contingent_worker_id as key column.

To export to the Workday Payroll report, the column names should also contain start_date, end_date, run_category, earning_code and amount.

Important

If you don't have all of the required columns, the export will fail with all the rows.