web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Query Dynamics CRM dat...
Microsoft Dynamics CRM (Archived)

Query Dynamics CRM data using R

(0) ShareShare
ReportReport
Posted on by KevinDC 30

Has anyone implemented any solutions for querying CRM data using R? I'm specifically interested in CRM 2015 on prem (yes, I know my client is way behind). I don't think the Xrm.WebAPI is available in that version but just curious at this point and wondering if there are any go-to resources I should look at first. Thanks.

*This post is locked for comments

I have the same question (0)
  • Arun Vinoth Profile Picture
    Arun Vinoth 11,615 Moderator on at

    Instead of R language you should try organizationdata.svc for pulling the data..

    Start here: community.dynamics.com/.../crm-2011-getting-started-with-odata

  • KevinDC Profile Picture
    KevinDC 30 on at

    Thanks for the response. You are correct, that is the approach I would take as well. However, I am asking on behalf of a separate data analytics team that is trying to pull together data from CRM as well as other systems. They currently use R to do this and I'm wondering if there are any standard practices regarding that approach. Thanks.

  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 1,027 Moderator on at

    Hi KevinDC,

    Since you are using Dynamics CRM on-premises, you can access the backend database directly and use the R-SQL server connector package to query the database and get information into R.

    Another option is to use the CData ODBC Driver for Dynamics CRM and the RODBC package to work with remote Dynamics CRM data in R. You can find more on this here.

  • Michael.Xing Profile Picture
    Michael.Xing 10 on at

    Hi Kevin,

    Sure, I am facing the issue.

    Do you find any solution to pull data from Dynamics CRM with R?

    Michael

  • KevinDC Profile Picture
    KevinDC 30 on at

    Michael - I did not end up working on this so I gave up on researching. Although the suggestion about to use the R SQL server connector probably was the best option.

    Kevin

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans