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

Ash (talk | contribs)
m moved from wiki URL to mediawiki reference links
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.


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


[[OData Feed URLs| OdataLink OData URL structure and query parameters →]]
[[OData Feed URLs| OdataLink OData URL structure and query parameters →]]