Add Update SQL Rows
Denise asked 9 years ago
We would like to allow users to add and update rows from a SQL Server table using SmartConnect. In the mappings, I see the option to ‘Update’, but if I uncheck it, it attempts to read the rows. Is it possible to allow insert/update (and possibly delete) from Excel to SQL using SmartConnect?
Answers
Best Answer
Lorren answered 9 years ago
Lorren answered 9 years ago
Denise,
If you need to do an update or insert then it would be better to write a stored procedure to handle that case and use that stored procedure as your destination.
The Checkbox for Update If Exists is used for setting the flag on Dynamics GP transactions or CRM/Salesforce.com as the API's for those products have that scenario handled. With the SQL Table or SQL Stored Procedure destinations you are effectively handling the business case/logic.
Lorren
If you need to do an update or insert then it would be better to write a stored procedure to handle that case and use that stored procedure as your destination.
The Checkbox for Update If Exists is used for setting the flag on Dynamics GP transactions or CRM/Salesforce.com as the API's for those products have that scenario handled. With the SQL Table or SQL Stored Procedure destinations you are effectively handling the business case/logic.
Lorren