Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / How can I import SQL d...
Microsoft Dynamics CRM (Archived)

How can I import SQL data tables into Dynamics 365 CRM?

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

So far I have been trying to import data into dynamics CRM using SSIS but it doesn't work. Problem is I have SQL data which has no integrity constraints while Dynamics CRM has it. I just want to simulate the SQL Import/Export wizard in my current requirement. Even those tables that don't have corresponding tables in CRM need to be added(client requirement). I know there are paid tools like Scribe etc. We want to achieve this without using any paid tools/subscriptions. Is there any way possible?

*This post is locked for comments

  • Mike Newstown Profile Picture
    Mike Newstown 5 on at
    RE: How can I import SQL data tables into Dynamics 365 CRM?

    Hi everyone!

    Look at another third-party solution - Skyvia cloud-based platform. Its functionality is free and maybe it's enough for your purposes. 

    https://skyvia.com/data-integration/integrate-dynamics-crm-sql-server

  • Mahadeo Matre Profile Picture
    Mahadeo Matre 17,021 on at
    RE: How can I import SQL data tables into Dynamics 365 CRM?

    if you are doing your own development for this integration.. it will take lot of time for planning, development, testing as Ummacrm mentioned and it might be more costly than 3rd party tool.

  • Wayne Walton Profile Picture
    Wayne Walton 13,726 on at
    RE: How can I import SQL data tables into Dynamics 365 CRM?

    They are going to spend a lot more when they realize nothing works like they want and someone is going to have to unravel it.  Make sure you get all these decisions documented, because this kind of thing has a high probability to come back to bite you, even if you're warning them this isn't a good idea.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How can I import SQL data tables into Dynamics 365 CRM?

    Even I suggested my client to let me know the tables which they find suitable for visualizations but he wanted everything into Dynamics.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How can I import SQL data tables into Dynamics 365 CRM?

    Yes, my company is trying to save money.

    I think you are right. Because whatever I found on Google asks to have a third-party tool to do the integration else it is going to be a hectic job.

  • Ummacrm Profile Picture
    Ummacrm 270 on at
    RE: How can I import SQL data tables into Dynamics 365 CRM?

    I replied before I saw this.  There are still some concerns here regarding your approach:  "Moreover most of the tables in Sage either don't match or they are absent in Dynamics CRM" amongst other statments.  That would and should be anticipated.  Migrating data from one system to another requires an immense amount of planning, along with a deep level of expertiese in either both target and source system, or database architecture in general.  I mean, just trying to match a table that says Contact in Sage, and hammering that into Dynamics is not going to result in an excellent outcome

    So how do we help?  I'm not sure man.  This is a big question and the reason most of us get paid to do what we do.  I wish i could help further.

  • Ummacrm Profile Picture
    Ummacrm 270 on at
    RE: How can I import SQL data tables into Dynamics 365 CRM?

    I think Mahadeo is on the right track trying to unpack how to help.  I was thinking it might be helpful to take different approach to better understand what is happening here, with the following question that may be able to help cut through it all:  Why do you want to achieve this without using any paid tools/subscriptions?  KingswaySoft is going to be your best bet here.  Are you trying to save money?  The development man hours that are going to be required to architect and map the relationships and constraints you mention without the help of one of these paid tools will dwarf the amount of money you will have spent on said paid product.  Here is an example:  How are you going to handle activityPointerBase->Email->Attachment imports?  That is an easy one, but just an example.  I was under the impression your client had a small Source CRM system / SQL database you are looking to import, but you mention 100's of tables worth of data.  If you are migrating a large CRM to Dynamics CRM, this is a large project to undertake and i am suspicious of the hesitation to purchase a tool that will make your life and your project many magnitutes easier.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How can I import SQL data tables into Dynamics 365 CRM?

    So here is my overall problem:

    My organisation uses Sage100 CRM portal. I was first asked to get that data into SQL server which I have got. I had to do this using Access as intermediary database because direct import in SQL wasn't working for connectivity with Sage so I had to use the former approach. Now that I have got the data in SQL server, I need to move it to dynamics 365 for analytics and visualization(These are our client requirements). I tried SSRS wherein a specify a for-each loop container for iterating each and every table in SQL server and move to CRM db but this won't work out as I can't keep on matching schemas of all 500 tables and moreover the referential integrity constraint in Dynamics. Moreover most of the tables in Sage either don't match or they are absent in Dynamics CRM.

    I agree with you on the point:

    "Retrieving / insert data from SQL for CRM is not recommend.. you need very good knowledge of CRM data structure to pull data from SQL"

  • Verified answer
    Mahadeo Matre Profile Picture
    Mahadeo Matre 17,021 on at
    RE: How can I import SQL data tables into Dynamics 365 CRM?

    Hi Sahil,

    do you want to move all CRM data to another CRM? like some production data to testing etc.

    If this is the case then you can do just sql database backup and restore to testing evn. and using deployment manager you can create organization.

    if this is not the case.. then do you have access to source CRM system, so that using API you can retrieve data from source CRM and then insert into your target CRM.

    Retrieving / insert data from SQL for CRM is not recommend.. you need very good knowledge of CRM data structure to pull data from SQL

    Please provide more details of your problem

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How can I import SQL data tables into Dynamics 365 CRM?

    @Mahadeo Matre

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans