How to access data in Dynamics CRM?

Question

What is the best way in terms of platform speed and read-only support for data access in Dynamics CRM 4? I did all three, but was interested in the opinions of the crowd.

• Via API
• Via web services directly
• Through DB calls to views

... and why?

My thoughts usually center around DB calls on looks, but I know there are purists.

Answer 1

Given both requirements, I would say that you want to call submissions. Properly processed SQL queries will fly.

API , , , . , , , . SQL- .

, TDS , SOAP-, API -.

UPDATE

CRM : CRM ( ?). , loadload, , . .

Answer 2

jake, , (* base * extensionbase) .

:

• filterd
• api

Answer 3

:

, API. , API . , :

- , .

-Modification .

, , API . , , SQL- - .

XVargas .

Unfiltered Views vs Tables: , .

vs Filtered views: , 15 . 10 . , 8 , 80 .

Unfiltered Views vs API: API , API SQL. API , . , , , , .