entityMap|blocks|key|bnp26|text|TSQL+-严格地说不实际上，获取CRM+Online的SQL访问是不可能的。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|42o88|因此，您只能使用Web+API或SDK服务调用。然而，如果你想使用脚本或数据导出服务对本地或Azure+IaaS服务器进行SQL复制，那么你可以继续使用T-SQL查询。|45chv^0|0|0^^$0|$]|1|@$2|3|4|5|6|7|8|F|9|@]|A|@]|B|$]]|$2|C|4|D|6|7|8|G|9|@]|A|@]|B|$]]|$2|E|4|-4|6|7|8|H|9|@]|A|@]|B|$]]]]

TSQL - Strictly No. Actually, its Impossible to get SQL access for CRM Online.

Hence you are limited with Web API or SDK service call. However if you want to do SQL replication to on-premise or Azure IaaS server using Scribe or Data export service, then you can stay with T-SQL queries.

entityMap|0|type|LINK|mutability|MUTABLE|data|url|https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/use-microsoft-dynamics-365-web-api|1|https://docs.microsoft.com/en-us/dynamics365/customer-engagement/admin/replicate-data-microsoft-azure-sql-database|blocks|key|be5cp|text|对于实时连接，您将绑定到Web+API+(OData)端点。Web+API端点的文档可以在here中找到。无法直接连接到Dynamics+365数据库。|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|9qseb|你可以使用数据导出服务将Dynamics+365中的数据复制到Azure+SQL数据库。数据导出服务的文档可以在here中找到。数据导出服务复制几乎是实时进行的。但是，表和列的名称将不会与它们在过滤视图中的名称完全相同，因此更改当前的SQL脚本将不可避免地使您的设置再次工作。|5dvbg^0|19|4|0|0|1K|4|1|0^^$0|$1|$2|3|4|5|6|$7|8]]|9|$2|3|4|5|6|$7|A]]]|B|@$C|D|E|F|2|G|H|P|I|@]|J|@$K|Q|L|R|C|S]]|6|$]]|$C|M|E|N|2|G|H|T|I|@]|J|@$K|U|L|V|C|W]]|6|$]]|$C|O|E|-4|2|G|H|X|I|@]|J|@]|6|$]]]]

For real-time connections you are bound to the Web API (OData) endpoint. The documentation for the Web API endpoint can be found <a href="https://docs.microsoft.com/en-us/dynamics365/customer-engagement/developer/use-microsoft-dynamics-365-web-api" rel="nofollow noreferrer">here</a>. It is not possible to directly connect to the Dynamics 365 database.

You can use the Data Export Service to replicate your data in Dynamics 365 to an Azure SQL database. The documentation for the Data Export Service can be found <a href="https://docs.microsoft.com/en-us/dynamics365/customer-engagement/admin/replicate-data-microsoft-azure-sql-database" rel="nofollow noreferrer">here</a>. The Data Export Service replication happens near real-time. However, the name of the tables and columns won't be exactly the same as they were in the Filtered Views, so changes to your current SQL scripts will be inevitable to get your setup working again.

entityMap|0|type|LINK|mutability|MUTABLE|data|url|https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/cds-sql-query|1|https://markcarrington.dev/2020/05/13/cds-t-sql-endpoint-pt-1-connecting/|blocks|key|tej8|text|现在应该可以使用TSQL访问CDS和D365了，因为微软刚刚宣布了CDS的TSQL端点。您可以在Dynamics上对实体执行SQL，就像下面的例子一样，但只读。|unstyled|depth|inlineStyleRanges|entityRanges|33gu|select+top+5+a.name+as+[VIP+customer],+a.address1_postalcode+as+[ZIP+code]+from+account+a+order+by+a.address1_postalcode+desc|code-block|syntax|javascript|2khkc|下面来自MS的链接描述了如何在SSMS中设置它，|dag55|offset|length|2uest|另外，下面的链接是一个非常有用的关于启动和运行它的博客，您可能需要在组织实体的orgdborgsettings字段中手动将EnableTDSEndpoint标记更新为true。|14io5|1436u|感谢Mark+Carrington|1m8vi^0|0|0|0|0|2E|0|0|0|0|21|1|0|0^^$0|$1|$2|3|4|5|6|$7|8]]|9|$2|3|4|5|6|$7|A]]]|B|@$C|D|E|F|2|G|H|10|I|@]|J|@]|6|$]]|$C|K|E|L|2|M|H|11|I|@]|J|@]|6|$N|O]]|$C|P|E|Q|2|G|H|12|I|@]|J|@]|6|$]]|$C|R|E|8|2|G|H|13|I|@]|J|@$S|14|T|15|C|16]]|6|$]]|$C|U|E|V|2|G|H|17|I|@]|J|@]|6|$]]|$C|W|E|A|2|G|H|18|I|@]|J|@$S|19|T|1A|C|1B]]|6|$]]|$C|X|E|Y|2|G|H|1C|I|@]|J|@]|6|$]]|$C|Z|E|-4|2|G|H|1D|I|@]|J|@]|6|$]]]]

TSQL access to the CDS and D365 should now be possible as MS has just announced a TSQL end point for CDS. You can execute SQL against entities, like the example below, on Dynamics but in read only though.

<pre><code>select top 5 a.name as [VIP customer], a.address1_postalcode as [ZIP code] from account a order by a.address1_postalcode desc
</code></pre>

The link below from MS describes how to set this up in SSMS,

<a href="https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/cds-sql-query" rel="nofollow noreferrer">https://docs.microsoft.com/en-us/powerapps/developer/common-data-service/cds-sql-query</a>

Also, the following link is a very useful blog on getting it up and running, you may have to update EnableTDSEndpoint tag to true manually within the orgdborgsettings field in the organization entity.

<a href="https://markcarrington.dev/2020/05/13/cds-t-sql-endpoint-pt-1-connecting/" rel="nofollow noreferrer">https://markcarrington.dev/2020/05/13/cds-t-sql-endpoint-pt-1-connecting/</a>

Credit to Mark Carrington

I'm helping migrate my company from CRM 2011 to CRM Dynamics online. Many of the applications we use currently run TSQL in order to obtain entities. Is it possible to execute TSQL against this latest new version of Microsoft CRM in order to obtain entities? Am I limited in using the Web API and Org service in order to obtain entities or is there some way for me to execute raw TSQL?

I'd like to have the option to use TSQL if possible. I understand the Web API service is the latest approach to obtaining entities using a REST API. However, I don't want to be limited to this. Is this possible?

How to query CRM Dynamics entities using raw TSQL only instead of Web API and Org Service?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

 我正在帮助我的公司从CRM 2011迁移到CRM Dynamics online。我们使用的许多应用程序当前运行TSQL以获取实体。是否可以对最新版本的Microsoft CRM执行TSQL以获取实体？我是否在使用Web API和Org服务来获取实体方面受到限制，或者是否有某种方法可以执行原始TSQL？ 如果可能的话...

问如何使用原始TSQL而不是Web API和组织服务来查询CRM Dynamics实体？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何使用原始TSQL而不是Web API和组织服务来查询CRM Dynamics实体？EN