Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, PowerApps, Microsoft Flow, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
what possibilities I have to import big amount of data from Excel, CSV, or SQL Server ?
The standard import function only allows 10000 rows and I would have to split it. This is not an option.
We used 3rd party software from Scribe to import anything of that size. We also continue to use Scribe for automating daily data pushes into CRM from our other systems.
I would highly recommend Kingswaysoft's SSIS toolkit - www.kingswaysoft.com/.../ssis-integration-toolkit-for-microsoft-dynamics-crm
It is the most efficient at doing large imports since it supports bulk insert.
Hope this helps
I'd also suggest another 3rd party tool. eOne SmartConnect.
It doesn't have all the bells and whistles that Scribe does in terms of the advanced "step logic," but it will do the job of importing records at a fraction of the price.
You can also try "ModifyMaxExport". This tool will help you increase the number of rows to import data.
Hope this help you.
Microsoft Dynamics™ CRM Support Engineer
"Please mark my answer as verified if you found it helpful"
Just like scott Durow says, you can use SSIS to import a lot data into MS CRM. Use Kingswaysoft SSIS Toolkit to facilitate you making SSIS project
Take a look at Skyvia. It`s also a cloud-based solution for no-coding integration with broad mapping and flexible scheduling features. Moreover, it`s free up to export/import of 100K CSV records.
If you have the budget for it, I recommend Scribe. If you're familiar with SSIS, you could use KingwaySoft or CozyRoc. If you're comfortable with C#, you could also write your own Script Tasks in SSIS to handle the import.
Business Applications communities