Share via

Coud to Azure data migration

Anshal 2,186 Reputation points
2024-07-19T14:28:50.7766667+00:00

Hi friends, we have have to move 100gb data from Workday to azure storage , is there connector available for incremental data load?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,670 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,127 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Amira Bedhiafi 19,616 Reputation points
    2024-07-19T16:37:19.85+00:00

    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.

    0 comments