You can use ADF or Azure Synapse Analytics, both of which offer robust solutions for data movement and transformation.
ADF allows you to create data-driven workflows with connectors that can connect to Workday via its API using HTTP, REST, or OData.
You will need to set up linked services for Workday and Azure Storage, define datasets, and create a pipeline using the Copy Data activity for the data transfer.
For incremental data loads, filter records based on the LastModifiedDate
field or a similar attribute in Workday.
Azure Synapse Analytics integrates these capabilities within its studio, leveraging ADF features for data ingestion and transformation.
All you need to secure connections, optimize for performance, and implement error handling and logging for a seamless data migration process.