You could query the Denodo server using the Linked server feature available in MS SQL Server Management studio. This Linked server would establish the connection to Denodo server through a Denodo ODBC driver. Refer to the Knowledge Base article for more information [Accessing Microsoft SQL Server Linked Servers](https://community.denodo.com/kb/view/document/Accessing%20Microsoft%20SQL%20Server%20Linked%20Servers?category=Northbound+Connections#h.5wpdxx2v05pz).
I would suggest you to also check the answer provided for a similar question [here](https://community.denodo.com/answers/question/details?questionId=9064u000000CfMVAA0&title=Connecting+Denodo+to+sql+server+management+studio) for more details.
Hope this helps!