You can translate the question and the replies:

Querying a Denodo objects with mandatory search parameters via Oracle dB link

i can successfully query a denodo object from Oracle over database link via Oracle Database Gateway for ODBC only when the denodo object does not contain mandatory search parameters. For objects having mandatory search parameters, the query erorrs out indicating the mandatory search parametes must be provided, even though they were already specified in the WHERE clause. How is this performed?
User
23-09-2022 19:38:24 -0400

1 Answer

Hi, If I face such an error, I would verify whether the **ODBC** configuration to connect to the Virtual DataPort server is valid. Additionally, I would check if the actual query which is being executed from Oracle DB links can be executed successfully from Virtual DataPort Administration Tool. You could refer to [**Connecting to VDP using Oracle DB links**](https://community.denodo.com/kb/view/document/Connecting%20to%20VDP%20using%20Oracle%20DB%20links?category=Northbound+Connections) Knowledge Base Article for more information. If the issue still persists and you have a valid Support account, then please raise a Support case at the [**Denodo Support Site**](https://support.denodo.com/) so that our Denodo Support Team will help you further. Hope this helps!
Denodo Team
26-09-2022 07:31:28 -0400
You must sign in to add an answer. If you do not have an account, you can register here