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)

 

For example

 

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.

(2) Answers

Login