Reducing Data Usage and Optimising your OdataLink Feeds: Difference between revisions

Ash (talk | contribs)
mNo edit summary
Ash (talk | contribs)
mNo edit summary
Line 103: Line 103:
# Merge (UPSERT) the result into the target table on the natural key.
# Merge (UPSERT) the result into the target table on the natural key.


<q>This pattern works in **SSIS** (OData Source component, parameterised URL), **Azure Data Factory** / **Fabric Data Pipelines** (Copy Activity with dynamic OData query), and any custom .NET / Python loader.</q>
<span style="color:navy"><blockquote>This pattern works in **SSIS** (OData Source component, parameterised URL), **Azure Data Factory** / **Fabric Data Pipelines** (Copy Activity with dynamic OData query), and any custom .NET / Python loader.</blockquote></span>


[https://help.odatalink.com/index.php?title=OData_URLs OdataLink OData URL structure and query parameters →]
[https://help.odatalink.com/index.php?title=OData_URLs OdataLink OData URL structure and query parameters →]