Scheduling Workday Report Delivery to Tabulera via SFTP

Set up an outbound Workday EIB that delivers your TCensus and TPayroll reports to Tabulera over SFTP on a weekly, monthly or daily schedule.

Table of contents

See it in action

Key takeaways

  • Workday delivers reports to external SFTP servers through an outbound EIB, not through Schedule a Report.
  • The custom report must be enabled as a web service before an EIB can read it.
  • Set the effective-date prompt to Determine Value at Runtime so every scheduled run picks up a fresh snapshot.
  • Delivery frequency is a client decision and can be changed later with Change Schedule, without rebuilding the EIB.

Before You Start

[[Warning]]The user setting up the EIB needs Modify access to the Integration Build and Custom Report Creation domains, View and Modify on Integration Event, and View on Integration Process, in addition to the report data domains listed in the report set-up article.[[/Warning]]

Tabulera Support issues one set of SFTP credentials per client. Every value below is an illustrative placeholder; use the credentials from your Tabulera welcome email.

SettingExample value (replace with yours)
SFTP addresssftp://sftp.tabulera.com:22
Enrollment directory/inbound/workday/enrollment
Payroll directory/inbound/workday/payroll
User IDacme_workday
AuthenticationUser name and password (SSH key on request)
File namesTCensus_AcmeCorp.csv, TPayroll_AcmeCorp.csv

Prerequisite: Enable the Report as a Web Service

An EIB can only read a custom report that is exposed as a web service. Do this once for TCensus and once for TPayroll.

  1. Search for the Edit Custom Report task and select the report.
  2. Open the Advanced tab and scroll to Web Services Options.
  3. Tick Enable As Web Service. Leave the API version and namespace Workday fills in.
  4. Click OK.
Workday Edit Custom Report, Advanced tab, with Enable As Web Service ticked

[[Note]]If the report does not appear later in the EIB’s Custom Report prompt, this box was not ticked.[[/Note]]

Create the Outbound EIB

Step 1: Start the Create EIB Task

Search for the Create EIB task, give it a descriptive name such as Tabulera - TCensus SFTP Delivery, select Outbound and click OK. Workday opens a five-step wizard: General Settings, Get Data, Transform, Deliver, Review and Submit.

Searching for the Create EIB task in Workday

Step 2: General Settings

Name and ID are pre-filled. Add a short comment describing the purpose of the integration and click Next.

EIB wizard General Settings step with name, ID and comment

Step 3: Get Data

FieldValue
Data Source TypeCustom Report
Custom ReportTCensus (only web-service-enabled reports are listed)
Details > Alternate Output FormatCSV
Details > Run As System UserLeave blank unless your security team requires an integration system user

Expand Details to reach Alternate Output Format. CSV is the format Tabulera’s Sources loader expects for automated delivery.

EIB Get Data step showing the Alternate Output Format options
EIB Get Data step with Custom Report TCensus and CSV output selected

Step 4: Transform

Leave Transformation Type as None. The CSV chosen in Step 3 is already the final format.

EIB Transform step with Transformation Type set to None

Step 5: Deliver

Change Delivery Method from the default Workday Attachment to SFTP and complete the transport fields with the credentials Tabulera provided.

EIB Deliver step showing the Delivery Method options including SFTP
EIB Deliver step showing SFTP Authentication Method options
EIB Deliver step completed with Tabulera SFTP address, directory, user ID and file name
FieldValue
Delivery MethodSFTP
SFTP Addresssftp://sftp.tabulera.com:22
Directory/inbound/workday/enrollment (payroll directory for TPayroll)
Use Temp FileTicked. Workday uploads to a temporary name and renames on completion, so Tabulera never picks up a half-written file
Authentication MethodUser Name / Password
User Idacme_workday
New Password / Verify PasswordPassword from your Tabulera welcome email
File NameTCensus_AcmeCorp.csv
Document Retention Policy (in Days)30

Two optional settings under Details are worth knowing: Sequence Generator for Filename adds a date or counter so earlier files are never overwritten on the server, and Encrypt using applies a PGP key if your policy requires encryption at rest. Ask Tabulera Support for the key.

EIB Deliver step Details section with Sequence Generator and Encrypt using options

Step 6: Review and Submit

Check the summary and click OK. Workday creates the integration system and opens its View Integration System page.

EIB wizard Review and Submit summary
Workday View Integration System page for the Tabulera TCensus SFTP Delivery EIB

Schedule the Integration

Step 7: Open Launch / Schedule

From the integration system’s related actions menu (the ... next to its name) choose Integration > Launch / Schedule. Set Run Frequency to the cadence agreed with Tabulera, here Weekly Recurrence, and click OK.

Related actions menu with Integration, Launch / Schedule selected

Step 8: Integration Criteria

The tab lists the report prompts plus the file and SFTP parameters. File and SFTP rows can stay on Use System Default. For a recurring job the effective date must not be fixed, otherwise every run returns the same snapshot:

PromptValue TypeValue
Effective as of DateDetermine Value at RuntimeToday
CurrencySpecify ValueUSD
File Name / Directory / AddressUse System Default
Integration Criteria prompt with Determine Value at Runtime date options
Integration Criteria tab with Effective as of Date set to Today and Currency USD

[[Note]]If Tabulera has asked you to snapshot the first of the month rather than the run date, pick a "first day of current month" calculated field instead of Today.[[/Note]]

Step 9: Schedule

Monday at 6:00 AM gives Tabulera a fresh snapshot at the start of each working week.

FieldValue
Recurs Every x Week(s)1
Day(s) of the WeekMonday
Start Time6:00 AM (tenant time zone)
Catch Up BehaviorRun Once
Range of Recurrence: Start DateFirst delivery day
Range of Recurrence: End Date12/31 of next calendar year
Schedule tab set to weekly recurrence on Monday at 6:00 AM

[[Warning]]Workday rejects a schedule that runs more than five times after the end of the next calendar year. Set the end date to December 31 of next year and extend it each fall.[[/Warning]]

Click OK. The confirmation page shows the request with Status Active.

Scheduled Future Process confirmation showing Weekly Recurrence with status Active

Test and Monitor

Before the first scheduled run, choose Integration > Test Transport from the same related actions menu to confirm Workday can log in to the SFTP server. After the first run, open Process Monitor, filter Process Type to Integration and confirm the request completed. Tabulera Support can confirm receipt on their side; the file then appears under the Sources menu for the matching billing period.

Workday Process Monitor prompt filtered to Process Type Integration

The cadence is not locked in. Open Scheduled Future Processes, find the EIB and use Change Schedule from its related actions to switch between daily, weekly and monthly, or Run Now for an ad-hoc delivery before a billing close.

Repeat for the Payroll Report

Follow the prerequisite and Steps 1 to 9 again for TPayroll, changing only these values:

FieldTPayroll value
EIB NameTabulera - TPayroll SFTP Delivery
Custom ReportTPayroll
Directory/inbound/workday/payroll
File NameTPayroll_AcmeCorp.csv
Report promptsPay Group and Period prompts on Determine Value at Runtime where a suitable field exists; otherwise Specify Value and review annually

Troubleshooting

SymptomWhat to check
Report not listed in the Custom Report promptEnable As Web Service is not ticked on the report’s Advanced tab
Test Transport fails with an authentication errorUser ID or password typed incorrectly; passwords are case sensitive
Test Transport fails with a connection errorAddress must include the sftp:// prefix and port 22
Process completes but the file is emptyPrompts resolved to a date with no data, or the running user lacks the data domains
Same data on every runEffective date prompt is Specify Value. Change it to Determine Value at Runtime: Today
Schedule rejected on saveEnd date is more than five runs beyond the end of next year
File not visible in Tabulera SourcesDirectory path differs from the one Tabulera issued. Contact Tabulera Support

Summary

With both EIBs scheduled, the enrollment and payroll reports land in Tabulera automatically at the cadence your reconciliation cycle needs. Nobody logs in to Workday to run or upload a file, the effective date moves with each run, and the frequency can be adjusted in one dialog whenever the client’s needs change.

Not built the reports yet? Start with Reconciling Benefit Invoices against Workday Reports.

Written by
Andrey Brych
Head of Marketing
Andrey is a Head of Marketing at Tabulera
Linkedin

Blog & Insights

Most read this month.

Blog

HR Process Improvement Guide: Best Strategies & Examples

Learn how to improve HR workflows with proven HR process improvement strategies, examples, automation ideas, and step-by-step optimization tips.

September 10, 2026
Read Guide
Blog

Managed EDI vs. Self-Service EDI: Which Model Does Your Benefits Team Need?

Compare managed EDI vs. self-service EDI for benefits administration: what each model covers, real costs, carrier connection workload, and how to choose.

August 26, 2026
Read Guide
Blog

Self-Funded vs. Fully Insured Health Plans: Complete Guide

Learn the difference between self-funded and fully insured health plans, compare costs, risks, compliance, and discover which option fits your business.

August 21, 2026
Read Guide

From carrier connection to premium payment. 

One platform.

30-day EDI go-live

1M+ Lives Processed

SOC 1 Certified

Workday Innovation Partner

NAPEO Member