Workday RaaS (Edge)

Configure Workday RaaS as a Source in your Pipeline

Perform the following steps to configure your Workday RaaS Source:

1. Click Pipelines in the Navigation Bar.

2. Click + Create Pipeline in the Pipelines List View.

3. On the Select Source Type page, select Workday RaaS.

4. On the Select Destination Type page, select the type of Destination you want to use.

5. In the Configure Source screen, specify the following:

   

   • Source Name: A unique name for your Source, not exceeding 255 characters. For example, Workday RaaS Source.

   • In the Connect to your Workday account section, specify the following:

     • Workday Username: The username of the Integration System User that you created.

     • Workday Password: The password of the Integration System User.

   • In the Report Configuration section, click Add Report, specify the following, and then click Save. Repeat this step for each report that you want to ingest. You can add up to 25 reports.

     

     • Table Name: The name of the Destination table for the report. The name must start with a letter, contain only letters, numbers, and underscores, and be unique across reports. You cannot change it after you create the Pipeline. For example, employee_data.

     • Report URL: The URL of the report that you copied from Workday.

     • Report Format: The format of the report data. Select JSON or CSV. The format must match the format value in the report URL. If the URL does not contain a format value, Hevo appends the selected format to it. Default value: JSON.

     • Enable Dynamic Parameters: Select Enabled to ingest only the data in a date range in each Pipeline run. Hevo passes the dates to the date prompts of the report. Default value: Disabled. If you select Enabled, specify the following:

       • Report Start Date Prompt Name: The name of the prompt that filters the report by start date, exactly as it is in Workday. For example, Start_Date.

       • Report End Date Prompt Name (Optional): The name of the prompt that filters the report by end date, exactly as it is in Workday. For example, End_Date. Leave this field blank if the report has only one date prompt.

       • Report Start Date: The date from which Hevo ingests data in the first Pipeline run, in the MM/DD/YYYY format. For example, 01/15/2024. The date cannot be later than the current date or earlier than 01/01/1990.

       • Sync Strategy: The date range that Hevo ingests in each subsequent Pipeline run. Select one of the following:

         • Sync updates from last sync: Hevo ingests data from the date of the last Pipeline run to the current date. As a result, the data of the day of the last run is ingested again and merged with the existing records. This is the default value.

         • Sync updates from report start: Hevo ingests data from the Report Start Date to the current date in each Pipeline run.

     • Enable Unpacking Nested Columns: If enabled, Hevo loads each field of a nested JSON object to a separate column. Else, Hevo loads the nested object as a JSON string. Lists are always loaded as JSON strings. Default value: Disabled.

     • Use Hevo Generated Primary Key: If enabled, Hevo generates the primary key of each record from the values of all its columns. Enable this option if no column or combination of columns uniquely identifies a record in the report. You cannot use this option with dynamic parameters. Default value: Disabled.

   • In the Primary Key Selection section, select one or more columns that uniquely identify each record of a report. Each tab shows the columns of one report. Reports for which you enabled Use Hevo Generated Primary Key are not shown.

6. Click Test & Continue to test the connection to your Workday RaaS Source. Once the test is successful, you can proceed to set up your Destination.

   When you click this button, Hevo checks the following for each report:

   • The Integration System User can access the report URL.

   • The report returns data in the format that Workday RaaS uses.

   • A primary key is selected, or Use Hevo Generated Primary Key is enabled.

   • If dynamic parameters are enabled, the prompt names match the prompts of the report, and the report start date is valid.

---

Data Replication

Hevo replicates data for all the objects selected on the Configure Objects page during Pipeline creation. Each report that you add to the Pipeline is an object. By default, all the reports are selected. However, you can modify this selection while creating or editing the Pipeline.

Hevo ingests the data of each report as per the sync frequency, as follows:

• Reports without dynamic parameters: Hevo ingests all the data of the report in each Pipeline run.

• Reports with dynamic parameters: In the first Pipeline run, Hevo ingests the data from the Report Start Date to the current date. In each subsequent run, Hevo ingests the data as per the sync strategy that you selected for the report. Hevo passes the dates to the report prompts in the YYYY-MM-DD format.

You can resync each report.

If Workday rejects a request because too many requests were made, or because the service is temporarily unavailable, Hevo retries the request up to three times, at intervals of 30 seconds. Workday limits the number of requests for each tenant based on the number of workers. For example, for a tenant with fewer than 3,500 workers, Workday allows up to 15,000 requests per hour and 75,000 requests per day. For a tenant with more than 100,000 workers, Workday allows up to 100,000 requests per hour and 350,000 requests per day. To understand how Hevo handles such scenarios, read Handling Rate Limit Exceptions.

Note: You can create a Pipeline with this Source only using the Merge load mode. The Append mode is not supported for this Source.

---

Schema and Primary Keys

Hevo discovers the columns of each report from the first record that the report returns. As a result, the schema of each Destination table depends on the fields in your Workday report. Hevo loads the data of all the columns as text (VARCHAR).

The primary key of each table is the set of columns that you select in the Primary Key Selection section. If you enable Use Hevo Generated Primary Key for a report, Hevo adds the _hevo_generated_pk column to the table and uses it as the primary key.

---

Data Model

The following is the list of tables (objects) that are created at the Destination when you run the Pipeline:

---