Forum Discussion

pmscorca's avatar
pmscorca
Icon for Post Prodigy rankPost Prodigy
1 year ago
Solved

Importing data from a Dynamics 365 CRM solution into Fabric

Hi,

I need to evaluate the possible methods to import data from a Dynamics 365 CRM solution into Fabric.

I hope that it exists a direct connection to use in order to accomplish a such task and it exists a method as better as possible in terms of performance and costs.

Any suggests to me, please? Thanks

7 Replies

  • We set this up for a client several months back but for the life of my I couldn't recall the exact steps. I do know, however, that we STARTED in Dynamics CRM with a Sync Agent and during configuration specified the Fabric Workspace to target the synchronized data. What we got was a lakehouse named something like this: 

    It synchronizes ALL data from ALL tables with no additional programming overhead. (But it did take a few days to get the initial data load completed.)

     

    Side note: If you are using Dynamics Business Central, that is a whole different animal and does NOT support this type of sync agent. You need to use Dataflow to go PULL the data you specifically want. 

     

    Hope that helps.

  • v-prasare's avatar
    v-prasare
    Icon for Community Support rankCommunity Support

    Hi ToddChitt,

    We would like to follow up to see if your query got resolved? Please let us know if you need any further assistance.

     

     

     


    Thanks,

    Prashanth Are

    MS Fabric community support

  • v-prasare's avatar
    v-prasare
    Icon for Community Support rankCommunity Support

    Hi @ToddChitt,

    We would like to follow up to see if your query got resolved? Please let us know if you need any further assistance.

     

     

     


    Thanks,

    Prashanth Are

    MS Fabric community support

  • v-prasare's avatar
    v-prasare
    Icon for Community Support rankCommunity Support

    We would like to confirm if you've successfully resolved this issue or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.

     

    Thank you for your patience and look forward to hearing from you.
    Best Regards,

    Prashanth Are