How do I get data from Dynamics CRM online in to my SQL server using SQL?

sql-server crm dynamics-crm-online
Warren picture Warren · Jan 24, 2014 · Viewed 13.4k times · Source

I can't believe that I have not yet found the answer to this question.

All I want to know is where to start in terms of using SQL tools (queries or SSIS I assume) to query CRM online (2013) and bring data into a table.

Is this even possible?

I want to download data, then I want to transform then I want to put it back. I'm sure I can work out that once I know to start!!!

Many thanks, Warren

Answer

gfritz picture gfritz · Jan 24, 2014

Unfortunately, CRM Online doesn't give you direct access to the database layer via SSMS.

There are some good samples in the CRM SDK that show how to retrieve data if you are up for writing some C#. This is their intro sample for how to connect to your CRM instance, gather some data, display it, and then update the entities. http://msdn.microsoft.com/en-us/library/hh675400.aspx

Once you manage to connect to your CRM instance, you will have access to all of your CRM data objects.

Related questions

Get audit history records of any entity record as per CRM view

I want to display all audit history data as per MS CRM format. I have imported all records from AuditBase table from CRM to another Database server table. I want this table records using SQL query in Dynamics CRM format (…

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More