Coud to Azure data migration

Anshal 2,251 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.
5,182 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,229 questions
{count} votes

Accepted answer
  1. Amira Bedhiafi 28,381 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.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.