You can translate the question and the replies:

Denodo and SSRS json data source

I am trying to use SSRS to connect to Denodo as a data source. The ODBC connection takes far too long to establish the connection - longer than it takes Denodo to return to data and longer than SSRS takes to render the report by an order of magnitude. So, I am trying to find a way to get the data from Denodo without using an ODBC connection. I can easily parse a json file, but don't know how to get SSRS to access a URL directly. Does anyone have a solution to this? ODBC is just terrible.
21-01-2022 12:55:53 -0500

1 Answer

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]( * 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]( 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]( Hope this helps!
Denodo Team
24-01-2022 08:03:45 -0500
You must sign in to add an answer. If you do not have an account, you can register here