Workday Financial Management to Microsoft SQL Server integration

Connect Workday Financial Management to Microsoft SQL Server and automatically sync your finance & accounting data.

Get started free Workday Financial Management connector

Workday Financial Management

Data source

Authenticating...

Ready to connect

CONNECTOR SOURCE

Workday Financial Management to Microsoft SQL Server

Connect Workday Financial Management to Microsoft SQL Server and automatically sync your finance & accounting data. Weld extracts Invoices, Payments, Accounts, and Transactions from Workday Financial Management, loads them into Microsoft SQL Server, and lets you transform the data using SQL or dbt, no custom scripts required.

Workday Financial Management data schema

Open full-page schema explorer

45tables

762fields

exclude_from_mass_close

boolean

document_number

string

purchase_order_document_status_id

string

purchase_order_document_status_descriptor

string

purchase_order_document_status_code

string

purchase_order_goods_line

purchase_order_id

string

goods_purchase_order_line_id

line_company_descriptor

string

line_company_code

string

purchase_order_goods_line_worktag

string

purchase_order_id

string

goods_purchase_order_line_id

purchase_order_goods_line_split

purchase_order_id

string

goods_purchase_order_line_id

string

business_document_line_split_id

string

business_document_line_split_reference_id

string

business_document_line_split_reference_descriptor

string

business_document_line_split_reference_code

purchase_order_goods_line_split_worktag

string

purchase_order_id

string

goods_purchase_order_line_id

string

business_document_line_split_id

purchase_order_goods_line_alternate_item_identifier

purchase_order_id

string

goods_purchase_order_line_id

string

item_identifier_type_id

string

item_identifier_type_descriptor

string

item_identifier_type_code

string

alternate_item_identifier_value

string

unit_of_measure_id

string

unit_of_measure_descriptor

manufacturer_descriptor

purchase_order_goods_line_item_tag

string

purchase_order_id

string

goods_purchase_order_line_id

purchase_order_goods_line_close_status

purchase_order_id

string

goods_purchase_order_line_id

reason_code_descriptor

purchase_order_service_line

purchase_order_id

string

service_order_line_id

line_company_descriptor

string

line_company_code

string

purchase_order_service_line_worktag

string

purchase_order_id

string

service_order_line_id

purchase_order_service_line_split

purchase_order_id

string

service_order_line_id

string

business_document_line_split_id

string

business_document_line_split_reference_id

string

business_document_line_split_reference_descriptor

string

business_document_line_split_reference_code

purchase_order_service_line_split_worktag

string

purchase_order_id

string

service_order_line_id

string

business_document_line_split_id

purchase_order_service_line_close_status

purchase_order_id

string

service_order_line_id

reason_code_descriptor

purchase_order_deliverables_line

purchase_order_id

string

deliverables_order_line_id

line_company_descriptor

purchase_order_deliverables_line_worktag

string

purchase_order_id

string

deliverables_order_line_id

purchase_order_deliverables_line_requisition_line

string

purchase_order_id

string

deliverables_order_line_id

purchase_order_deliverables_line_split

purchase_order_id

string

deliverables_order_line_id

string

business_document_line_split_id

string

business_document_line_split_reference_id

string

business_document_line_split_reference_descriptor

string

business_document_line_split_reference_code

purchase_order_deliverables_line_split_worktag

string

purchase_order_id

string

deliverables_order_line_id

string

business_document_line_split_id

purchase_order_deliverables_line_project_phase

purchase_order_id

string

deliverables_order_line_id

string

project_plan_phase_id

string

project_plan_phase_descriptor

string

project_plan_phase_code

string

_weld_synced

date

purchase_order_deliverables_line_project_phase_task

purchase_order_id

string

deliverables_order_line_id

string

project_plan_phase_id

string

project_plan_task_id

string

project_plan_task_descriptor

string

project_plan_task_code

string

_weld_synced

date

purchase_order_deliverables_line_project_phase_task_subtask

purchase_order_id

string

deliverables_order_line_id

string

project_plan_phase_id

purchase_order_deliverables_line_close_status

purchase_order_id

string

deliverables_order_line_id

reason_code_descriptor

purchase_order_contingent_worker_line

contingent_worker_descriptor

string

contingent_worker_code

purchase_order_contingent_worker_line_worktag

purchase_order_contingent_worker_line_time_code

purchase_order_tax_code

tax_applicability_descriptor

string

tax_applicability_code

purchase_order_tax_code_rate

tax_recoverability_id

string

tax_recoverability_descriptor

string

tax_recoverability_code

string

purchase_order_procedure

medical_record_number

supplier_representative

string

supplier_sales_order_number

double

additional_procedure_details

string

_weld_synced

date

purchase_order_issue_email

purchase_order_requisition_type

receipt_creation_source_id

string

receipt_creation_source_descriptor

string

receipt_creation_source_code

receipt_line_goods_item

receipt_id

string

purchase_order_line_id

string

purchase_order_line_descriptor

string

purchase_order_line_code

string

supplier_contract_line_id

string

supplier_contract_line_descriptor

string

supplier_contract_line_code

string

line_company_id

string

line_company_descriptor

string

receipt_line_goods_item_receipt_adjustment

string

receipt_id

string

purchase_order_line_id

receipt_line_goods_item_split

receipt_id

string

purchase_order_line_id

string

line_split_allocated_from_id

line_split_allocated_from_descriptor

string

line_split_allocated_from_code

string

_weld_synced

date

receipt_line_goods_item_lot

receipt_id

string

purchase_order_line_id

receipt_line_goods_item_lot_serial

receipt_id

string

purchase_order_line_id

purchase_order_line_id

string

purchase_order_line_descriptor

string

purchase_order_line_code

string

supplier_contract_line_id

string

supplier_contract_line_descriptor

string

supplier_contract_line_code

string

line_company_id

string

line_company_descriptor

string

receipt_line_service_receipt_adjustment

string

receipt_id

string

purchase_order_line_id

receipt_line_service_split

receipt_id

string

purchase_order_line_id

string

line_split_allocated_from_id

line_split_allocated_from_descriptor

string

line_split_allocated_from_code

string

_weld_synced

date

receipt_line_contingent_worker_hours

receipt_requisition_type

receipt_receipt_adjustment

receipt_tracking_number

Open full-page schema explorer

Everything you need to get started

Workday Financial Management

Setup guide Data schema45 tables Connector page

Microsoft SQL Server

Setup guide Connector page

Weld Connect API

Set up programmatically

Use the Weld Connect REST API to create Workday Financial Management connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.

Explore Weld Connect API reference

POST/elt_syncs

# Create a Workday Financial Management ELT sync
curl -X POST https://connect.weld.app/elt_syncs \
  -H "x-api-key: $API_KEY" \
  -d '{
    "connection_id": "conn_abc123",
    "integration_id": "workday-financial-management",
    "destination_schema_name": "workday-financial-management_data",
    "sync_interval": "0 * * * *"
  }'
▌

FAQs

How do I sync Workday Financial Management data to Microsoft SQL Server?

Sign up for Weld, connect Workday Financial Management as a source and Microsoft SQL Server as a destination. Weld handles the extraction, loading, and lets you transform data using SQL or dbt.

What Workday Financial Management data can I sync to Microsoft SQL Server?

You can sync Invoices, Payments, Accounts, Transactions, and Customers. The available objects depend on your Workday Financial Management account permissions and configuration.

How often does Weld sync data from Workday Financial Management?

Sync frequency depends on your Weld plan. Schedules range from every 5 minutes to daily intervals. Each sync processes only new and changed data.

Can I transform Workday Financial Management data before it lands in Microsoft SQL Server?

Yes. Weld supports SQL-based transformations in the platform and integrates with dbt Cloud. You can clean, join, and model your data before analysis.

Is the Workday Financial Management to Microsoft SQL Server integration secure?

Yes. Weld encrypts all data in transit and at rest, is SOC 2 Type II certified, and supports IP whitelisting. Credentials are stored encrypted and never logged.