Import from SQL to Dynamics 365
I have been able to Export data from Dynamics 365 to SQL Server but now I want to do the opposite- Import Data from SQL to Dynamics 365.
Steps followed to achieve this -
1) Create a record in a table called Quotes in SQL. ( Schema for this table was replicated from Dynamics 365 to SQL using a replication map)
2) Create a map to Import data from SQL to Dynamics 365 using appropriate connectors and controls. ( I have attached the map for reference)
The process was successful but the available field values in Dynamics 365 is different from what I had entered in SQL. (Image attached)
a) For "Status" I entered "Active" but it shows up as "Draft"
b) For "Profitability" I entered "Profitable" but it shows up as "Not Profitable"
Please let me what is the best way to sort out this issue.