This is XRMToolBox Plugin to insert MYSQL record in Dynamic CRM 365. This is easyest way to import data.
These instructions will get you a copy of the project up and running on your local machine for development and testing purposes.
First, Download XRM tool box from here: https://github.com/MscrmTools/XrmToolBox/releases/download/v.1.2018.7.28/XrmToolbox.zip.
A step by step series of examples that tell you how to use this tool.
-
Download plugin(MS Sql To CRM Import) from xrm plugin store. XRMToolBox -> Tools -> Plugin Store.
-
Search in Plugins Tab (MS Sql To CRM Import) of XRMToolBox.
-
Click on Plugin and Connect with you dynamic CRM Instance.
-
Now, Click on Load MS Sql Tables button and Connect with MS SQL server with Connection String or Database Credentails.
-
Select Tables that you want to import into CRM.
-
You get selected table column in List.
-
Same selection process doing at select Entities end.
-
Now, select column mapped with Entites Fiels.
-
You can up and down posiion of table and Entites column.
-
Insert Bulk record Import size(Max. 1000).
-
Click on Start Import.Now, Import Processing started.
Notes: If you got any issue in this steps you can contact at hemant.tiwari at dotsquares.com.