How to set up a map to use Changes Only / Change Table Data Source to delete records from a SQL Table once imported into GP
Alyson Frost asked 7 years ago
I have a customer that needs to import Customers and Customer Addresses from external staging tables into Dynamics GP. Once the records are successfully integrated, we’d like to delete them fro mte staging table.
The documentation is so scattered I am having difficulty figuring out how to set up the Change Table Data source and how to include this with the successful record import. Is there any step by step instruction or example of setting something like this up?
The documentation is so scattered I am having difficulty figuring out how to set up the Change Table Data source and how to include this with the successful record import. Is there any step by step instruction or example of setting something like this up?
Answers
Patrick Roth Staff answered 7 years ago
Alyson,
The documentation on setting up a change data table is here:
http://www.eonesolutions.com/Manuals/SmartConnect/SmartConnect%202015/?page=smartconnect_mssql_change_data_source
However I don’t think you really want to do this since this isn’t ongoing. You said you would just put the data In the staging table and then delete when finished.
If it was ongoing (insert/udpates) then a change table would be perfect.
So just set up the change source which sets up a trigger on the target table.
at that point, you would populate the staging table which would populate the change tracking table. SC will run and then mark off the successful ones automatically.
Patrick
eone
The documentation on setting up a change data table is here:
http://www.eonesolutions.com/Manuals/SmartConnect/SmartConnect%202015/?page=smartconnect_mssql_change_data_source
However I don’t think you really want to do this since this isn’t ongoing. You said you would just put the data In the staging table and then delete when finished.
If it was ongoing (insert/udpates) then a change table would be perfect.
So just set up the change source which sets up a trigger on the target table.
at that point, you would populate the staging table which would populate the change tracking table. SC will run and then mark off the successful ones automatically.
Patrick
eone