What is TDS in Dynamics 365 CE online?

TDS stands for Tabular Data Stream (TDS). TDS is a Protocol and it is an endpoint for the Dataverse.

This endpoint enables us to connect to the Dataverse for accessing the data in Dynamics 365 CE or Power Platform environments. This endpoint allows read-only access to the system for reporting and analytics. TDS endpoint is managed by a System Administrator. Best part is that, you can see the data based on your security roles provided in Dynamics 365 CE.

Using this TDS, you can connect to SSMS (v18.4 and higher) and Power BI applications.

SQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure from SQL Server to Azure SQL Database. This Dataverse TDS endpoint allows us to perform read-only T-SQL queries that runs on the server.

Power BI desktop used to create reports on the data sets. Using this Dataverse TDS, from the Power BI desktop, you can connect to Dynamics 365 CE/ Power Platform environments and create Power BI Dashboards/ Reports with the native security.

Hope you understood about the TDS endpoint in Microsoft Dynamics 365 CE.

Please like and share your valuable feedback on this article.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.