Denodo Connection advanced connection settings

[CoffeeAddictMk2]

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 adding in CommandTimeout = #duration(0,1,0,0),ConnectionTimeout=#duration(0,1,0,0) into the Mcode of the source line as below

  Source = Denodo.Contents("servername", false, [CommandTimeout=#duration(0,1,0,0),ConnectionTimeout=#duration(0,1,0,0)])

The other issue im having is i need to also pass a context to the server to populate the cache 

CONTEXT ('cache_preload' = 'true', 'cache_invalidate' = 'all_rows')"

i need to pass this as part of the query but cant find out how i could add this into the advanced configurations.

I can get it to work with ODBC connectors but that is throwing up other issues with saving the dataflow before they timeout.

[v-pnaroju-msft]

Hi @CoffeeAddictMk2,

We are pleased to know that you have found a solution to the issue and successfully resolved it. Kindly mark the response that addressed your query as the accepted solution. This will help other community members facing similar challenges in finding solutions more efficiently.

Please continue to utilise the Fabric Community for any further assistance with your queries.

Thank you.

[CoffeeAddictMk2 · Accepted solution]

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.

[v-pnaroju-msft]

Hi CoffeeAddictMk2,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[v-pnaroju-msft]

Hi CoffeeAddictMk2,

We have not received a response from you regarding the query and were following up to check if you have found a resolution. If you have identified a solution, we kindly request you to share it with the community, as it may be helpful to others facing a similar issue.

If you find the response helpful, please mark it as the accepted solution and provide kudos, as this will help other members with similar queries.

Thank you.

[v-pnaroju-msft]

Hi @CoffeeAddictMk2,

We appreciate your inquiry on the Microsoft Fabric Community Forum.

Please follow the steps below, which may help resolve the issue:

1. Ensure that you are using the latest versions of both the Denodo connector and Microsoft Fabric to prevent compatibility issues.
2. Simplify complex queries to reduce execution time and avoid timeouts.
3. Verify that the server name entered matches the expected format required by the Denodo connector.
4. Ensure that the Denodo server is configured to accept the cache_preload and cache_invalidate context parameters.
5. 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.