Hi,
I tried connecting Denodo through SSRS using the recommended way(ODBC Driver) and it worked as expected. I would ensure the following:
* Consider updating the latest ODBC driver which is located in <Denodo_Home>\DenodoPlatform8.0\tools\client-drivers\odbc as the driver gets updated with the version update. It is important to update these drivers from the client which is using Denodo as source to avoid any issues.
* Check your DSN configuration to ensure that it follows the steps mentioned in the document [DSN configuration for ODBC connections to VDP](https://community.denodo.com/kb/en/view/document/DSN%20configuration%20for%20ODBC%20connections%20to%20VDP)
* Try consuming denodo from other ODBC clients such as Excel and examine if the connection is taking more time. If the issue is only with ssrs, I would try to fix it from ssrs side. Also, you can try to consume other databases using odbc and examine if the behavior is the same.
* Check if the client is causing any slowness in fetching the records from Denodo. You can have a look at the Knowledge article [Best Practices to Maximize Performance IV: Detecting Bottlenecks](https://community.denodo.com/kb/en/view/document/Best%20Practices%20to%20Maximize%20Performance%20IV%3A%20Detecting%20Bottlenecks%20in%20a%20Query#h.fdz6ggz1c2yu) in a Query to identify the bottlenecks.
Apart from ODBC, Denodo supports JDBC and the rest api. If SSRS supports any of these methods then you could connect using one of these methods.
You can also refer to the below article for configuration and troubleshooting. [How to access Denodo Virtual DataPort from Microsoft SQL Server Reporting Services](https://community.denodo.com/kb/en/view/document/How%20to%20access%20Denodo%20Virtual%20DataPort%20from%20Microsoft%20SQL%20Server%20Reporting%20Services)
Hope this helps!
