I’m working on pricing integration from D365 F&O to DW10. I have it pretty much working, except for updates.
The full migration/integration is setup as a scheduled task, and has 5 sub tasks:
- Empty staging table
- Pull 'GROUP1' pricing from D365 into staging table
- Pull 'GROUP2' pricing from D365 into staging table
- Pull 'GROUP3' pricing from D365 into staging tableDyna
- Using a view on top of the staging table, the data is mapped to table EcomPrices, using the DynamicWeb provider.
The only box checked in the ‘Destination’ tab of the integration task for EcomPrices is ‘Create Missing groups’
The problem is that it does not update existing records, if I run the migration for a second time, it just doubles up the records in EcomPrices.
I want to do a full pull each time in case existing records in D365 are updated.
I was hoping that by setting multiple columns as ‘key’ columns it would interpret that as a combined key and use that to uniquely identify a record,
and as such it would update it.
Note that I need it to both update existing records AND add new records.
Any idea how I can achieve this?
