Share via

How to load updated tables records from OData source to azure SQL server using Azure data factory

Chinnu 0 Reputation points
2023-04-14T11:09:13.4733333+00:00

I have 5 OData source tables, having some number of rows data loaded into sink side with 5 tables output.i want same source side tables updated records to same sink tables

Azure SQL Database
Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,559 questions
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,375 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,625 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. AnnuKumari-MSFT 34,556 Reputation points Microsoft Employee Moderator
    2023-04-17T16:55:39.9433333+00:00

    Hi Chinnu , Welcome to Microsoft Q&A platform and thanks for posting your query here. As I understand the question, you want to copy data from OData source to SQL server as destination datastore. Please let me know if that is not the ask. Azure data factory supports OData connector , so you can create a linked service pointing to the OData and provide the configuration details. Note: OData connector supports OData version 3.0 and 4.0. Screenshot of the OData connector.

    Screenshot of linked service configuration for an OData store.

    Similarly, add Azure SQL Server as the sink dataset and perform copy using Copy activity in Azure data factory. To copy from multiple source tables , you can parameterize your source and sink dataset path . For more details on copying data from OData kindly checkout these resources: How to Get data by using ODATA Data Store and Web Activity in ADF Azure Data Factory Quick Tip: Transfer data from oData service based API to Azure Cosmos DB Copy data from an OData source by using Azure Data Factory or Synapse Analytics Thankyou. Pease accept the answer if it helped. Let me know in case of any concerns.

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.