microsoft / microsoft/Dynamics-365-FastTrack-Implementation-Assets
Synapse link with incremental update Issue
Nobody has claimed this yet.
- Dominant language
- Jupyter Notebook
- Stars
- 494
- Forks
- 296
- Avg merge
- 1d 10h
- Merged PRs (30d)
- 5
Description
Hi all,
I am trying to implement a Synapse Link with csv incremental update to get table data from a UAT D365 F&O environment (this tutorial). The problem is that the target sql DB is not updating with the latest data, while the Synapse WS source DB views are updating correctly, based on the latest Synapse Link sync in Power App. Does anyone know how to solve this problem? Probably the error is within the store procedures provided by the tutorial
Thanks in advance!
Example:
Source DB
Target DB
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start with the provided store procedures in the Analytics/DataverseLink/DataIntegration tutorial and compare the Synapse source DB views with the target SQL DB after the latest sync. Check whether the incremental-update flow processes the changed rows; done means the target DB reflects the latest source data.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- data-engineering, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100