http://powerwiki.net/api.php?action=feedcontributions&feedformat=atom&user=MarkMpn 2026-04-04T02:00:48Z User contributions MediaWiki 1.35.1 http://powerwiki.net/index.php?title=TDS_endpoint&diff=4288 2021-02-01T12:32:26Z

<p>MarkMpn: Created page with &quot;TDS endpoint makes it possible to query your Dataverse data using SQL. You can use Power BI in DirectQuery mode to ensure your reports are using live data instead of perio...&quot;</p> <hr /> <div>TDS endpoint makes it possible to query your Dataverse data using [[SQL]]. You can use Power BI in DirectQuery mode to ensure your reports are using live data instead of periodically refreshed data, or you can do bespoke queries from SQL Server Management Studio (SSMS) or your own custom applications.<br /> <br /> Although it does not give a direct connection to the underlying SQL database, the connection is made using the same SQL Server protocol (TDS), so client applications such as SSMS do not need to know the difference. Some rewriting/sanitization of the query is done by the TDS endpoint before it is ultimately passed to the SQL database to be executed, so not all SQL features are available. Notably, the database is read-only so only SELECT queries are usable.<br /> <br /> You can connect to the TDS endpoint for a Dataverse instance using the same URL, e.g. contoso.crm.dynamics.com. Some examples will show using port 5558 for the connection - this was required at the start of the preview, but you can now connect on the default port 1433 as well.<br /> <br /> == Microsoft Resources ==<br /> * [https://docs.microsoft.com/en-us/powerapps/developer/data-platform/dataverse-sql-query Use SQL to query data]<br /> <br /> == Community Resources ==<br /> <br /> === Articles ===<br /> * [https://markcarrington.dev/2020/05/13/cds-t-sql-endpoint-pt-1-connecting/ Connecting to TDS endpoint] by Mark Carrington<br /> <br /> * [https://markcarrington.dev/2020/08/04/msdyn365-internals-t-sql-endpoint/ TDS endpoint internals] by Mark Carrington<br /> <br /> * [https://markcarrington.dev/2020/08/09/cds-t-sql-performance/ TDS endpoint performance] by Mark Carrington<br /> <br /> === Tools ===<br /> * [https://markcarrington.dev/sql-4-cds/ SQL 4 CDS] by Mark Carrington<br /> <br /> [[Category:Developer]]</div>

MarkMpn http://powerwiki.net/index.php?title=Custom_APIs&diff=4285 2021-02-01T12:13:23Z

<p>MarkMpn: Added comparisons with Custom Actions</p> <hr /> <div>Custom APIs offer a new code-first way to define messages that you can add to Dataverse web services. Conceptually, Custom APIs are an extension to Custom Actions that have provided a no-code way to include custom messages. <br /> <br /> Please note that Custom APIs is still a feature in preview. <br /> <br /> While Custom Actions allowed you to define your API using the synchronous workflow engine, Custom APIs uses a plugin instead. Custom APIs also add a lot of extra configuration options compared to Custom Actions, including the ability to require a specific privilege to call the API, restrict how custom plugins can be attached to it or hide it from metadata discovery entirely.<br /> <br /> == Microsoft Resources ==<br /> * [https://docs.microsoft.com/powerapps/developer/data-platform/custom-api Create and use Custom APIs]<br /> <br /> == Community Resources ==<br /> <br /> === Articles ===<br /> [https://itmustbecode.com/customapi-manager-for-xrmtoolbox/ Custom API Manager for XrmToolBox] by David Rivard<br /> <br /> [https://jonasr.app/2020/12/xit/ XrmToolBox Integration Tester] by Jonas Rapp<br /> <br /> [https://markcarrington.dev/2020/10/22/cds-custom-apis/ CDS Custom APIs] by Mark Carrington<br /> <br /> === Tools ===<br /> [https://www.xrmtoolbox.com/plugins/XTB.CustomApiManager/ Dataverse Custom API Manager] by David Rivard<br /> <br /> [https://www.xrmtoolbox.com/plugins/Rappen.XrmToolBox.CustomAPITester/ Custom API Tester] by Jonas Rapp<br /> <br /> [[Category:Developer]]</div>

MarkMpn