Forum Discussion
Solved
Denodo Connection advanced connection settings
trying create a gen 1 dataflow using the built in denodo connector. I am hitting 2 problems, 1 on long running queries i'm hitting the built in Timeout of 15 mins, ive tried overriding this by ...
Your solution didnt help but i have managed to get a solution using the ODBC connector and adding parameters into the connection string for the context, view name and to limit the rows to 0 to just get the schema.
Hi CoffeeAddictMk2,
We appreciate your inquiry on the Microsoft Fabric Community Forum.
Please follow the steps below, which may help resolve the issue:
- Ensure that you are using the latest versions of both the Denodo connector and Microsoft Fabric to prevent compatibility issues.
- Simplify complex queries to reduce execution time and avoid timeouts.
- Verify that the server name entered matches the expected format required by the Denodo connector.
- Ensure that the Denodo server is configured to accept the cache_preload and cache_invalidate context parameters.
- Carefully review any error messages, as they may provide valuable insights into the issue.
If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.
Thank you.