• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 731
  • Last Modified:

Best resources to learn SQL back-end of MS Dynamics CRM

Hi All

I'm a SQL Server SSIS developer that is being thrown at a couple of ETL projects moving data in and out of MS Dynamics CRM.

Question:  What are the best resources to learn the SQL back-end of MS Dynamics CRM?

Thanks in advance.
Jim
0
Jim Horn
Asked:
Jim Horn
2 Solutions
 
Chinmay PatelEnterprise ArchitectCommented:
Dynamics CRM uses Sql Database but does not support direct SQL manipulation. You would want to read CRM SDK for insert/update operations. Reading data is fine as long as you are using filtered views OR you know what exactly you need to get and ite implications from Security perspective then you can bypass filtered views and directly query CRM Tables.
0
 
omgangIT ManagerCommented:
Jim, I have also recently become involved in a CRM 2011 deployment and implementation.  As @Chinmay_Patel indicates we really cannot directly access/manipulate the SQL back-end (in my situation we're using CRM Online so no access to the SQL db at all).  For getting data loaded from a legacy SQL Server db I generated import XML files from CRM and populated them from the SQL db data.  Note that new data fields for the entity can be created/added during this process; the import wizard provides for this.
OM Gang
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor Commented:
Thanks guys.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now