Workday Financial Management

Workday Financial Management is Workday's cloud finance suite, covering accounting, procurement, expenses and spend management. With Weld you can sync your Workday purchase orders and receipts into your data warehouse and combine them with your ERP, budgeting and vendor data to report on committed spend, open orders and goods received.

Features

Data Schema

Setup Guide - ELT

Step 1 - Create an integration system user

1. Sign in to Workday with an administrator account.
2. Search for the task Create Integration System User and run it.
3. Choose a user name and password. Clear Require New Password at Next Sign In.
4. Leave Do Not Allow UI Sessions unchecked if you plan to connect with OAuth, which is the recommended option. Only tick it if you will connect with the username and password instead.
5. Click OK, then Done.

Step 2 - Grant the user read access

1. Search for the task Create Security Group. Pick the type Integration System Security Group (Unconstrained), give it a name and click OK.
2. Add the integration system user you just created as a member of the group.
3. Open the group's related actions and choose Security Group → Maintain Domain Permissions for Security Group.
4. Under Integration Permissions, in Domain Security Policies permitting Get access, add the domains that cover purchase orders and receipts. If you are unsure which domains apply, run View Security for Securable Item for Purchase Order and Receipt and use the domains listed for their Get web service operations.
5. Search for Activate Pending Security Policy Changes, enter a comment, tick Confirm and click OK. Permissions do not take effect until this step is done.

Step 3 - Choose how Weld authenticates

Weld supports two ways of signing in. Use OAuth unless your organisation cannot register API clients.

Option A - OAuth (API client for integrations), recommended

1. Search for the task Register API Client for Integrations and run it.
2. Enter a client name such as Weld.
3. Tick Non-Expiring Refresh Tokens. If you set a refresh token timeout instead, the connection stops syncing when the token expires and you will have to generate a new one and update the connection in Weld.
4. Under Scope (Functional Areas), select the functional areas that contain purchase orders and receipts. Leave Include Workday Owned Scope unchecked.
5. Click OK and copy the Client ID and Client Secret. The secret is only shown once.
6. From the client's related actions choose API Client → Manage Refresh Tokens for Integrations.
7. In Workday Account, select the integration system user from Step 1, tick Generate New Refresh Token and click OK.
8. Copy the Refresh Token.

Option B - Integration system user and password

No further Workday setup is needed. You will enter the user name and password of the integration system user from Step 1 directly in Weld.

Step 4 - Find your hostname and tenant

Both values come from your Workday Web Services URL, which your administrator can look up in Workday under View API Clients or Public Web Services. The URL has the form:

https:///ccx/service//...

• Hostname is the services host, for example wd2-impl-services1.workday.com or services1.wd103.myworkday.com. It always contains a services label. Do not use the host you sign in to in the browser, which has no services part and does not accept API calls.
• Tenant is the path segment right after /ccx/service/.

Step 5 - Create the connection

1. In the Weld app, navigate to Connections and click + New Connection.
2. Search for Workday Financial Management and select it.
3. Enter the destination schema name of your choice. This name is used to identify the connection in future syncs.
4. Pick the authentication method that matches Step 3:
   • OAuth (API client for integrations): enter Hostname, Tenant, Client ID, Client Secret and Refresh Token.
   • Integration system user and password: enter Hostname, Tenant, Username (without the @tenant suffix) and Password.
5. Click Connect to save the connection.

Step 6 - Data To Sync

Select the tables you wish to include in the sync. You can view the schema, remove columns or hash sensitive information.

Two streams are available. Each one writes a parent table plus a set of child tables for its line items and nested details, so selecting a stream brings all of its tables along.

• Purchase orders — purchase_order, with child tables purchase_order_goods_line, purchase_order_goods_line_worktag, purchase_order_goods_line_split, purchase_order_goods_line_split_worktag, purchase_order_goods_line_alternate_item_identifier, purchase_order_goods_line_item_tag, purchase_order_goods_line_close_status, purchase_order_service_line, purchase_order_service_line_worktag, purchase_order_service_line_split, purchase_order_service_line_split_worktag, purchase_order_service_line_close_status, purchase_order_deliverables_line, purchase_order_deliverables_line_worktag, purchase_order_deliverables_line_requisition_line, purchase_order_deliverables_line_split, purchase_order_deliverables_line_split_worktag, purchase_order_deliverables_line_project_phase, purchase_order_deliverables_line_project_phase_task, purchase_order_deliverables_line_project_phase_task_subtask, purchase_order_deliverables_line_close_status, purchase_order_contingent_worker_line, purchase_order_contingent_worker_line_worktag, purchase_order_contingent_worker_line_time_code, purchase_order_tax_code, purchase_order_tax_code_rate, purchase_order_procedure, purchase_order_issue_email, purchase_order_requisition_type
• Receipts — receipt, with child tables receipt_line_goods_item, receipt_line_goods_item_receipt_adjustment, receipt_line_goods_item_split, receipt_line_goods_item_lot, receipt_line_goods_item_lot_serial, receipt_line_service, receipt_line_service_receipt_adjustment, receipt_line_service_split, receipt_line_contingent_worker_hours, receipt_requester, receipt_requisition, receipt_requisition_type, receipt_receipt_adjustment, receipt_tracking_number

Step 7 - Configure sync

1. Select how often you would like the data to sync.
2. Choose a start date. Only purchase orders and receipts updated on or after this date are included in the first sync. Leave it empty to load the full history in your tenant.
3. Provide a unique destination table name.

Weld will take over from here and commence syncing data from your Workday tenant.