Latest Activity
Hello - we are new to Denodo. I'm looking for documentation or direction on permissions and privileges needed at the source database level when connecting. We will have both source Oracle and SQLServer. Other than read only? Create temp table? Reading ...
Hi I wanted to know How i can Create data source connections for Oracle Fusion (Cloud) instance
Hi We have JSON files stored in an Oracle DB as BLOBs. We would like to convert the JSON files into a column of type 'Register'. We have ingested the BLOBS into Denodo and converted them into 'text' type columns. We now want to convert the text into a ...
Hi There, Can denodo send WIth Clause Query as it is to Oracle Data source? Why denodo try to optimize With Clause into SubSQL Query? Can we pass direct With Clause to any data source via denodo ? thanks,
Hi, can us help me with that? i want to know if is possible to "force use index" in a oracle sql db by a integration view. /+ INDEX(bd.table IDX_EXAMPLE) / Thanks,
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...
Related to: Connecting to VDP using Oracle DB links
Hi All I need to export a file from Oracle SQL Developer Data Modeler and import on Denodo VDP. Is this possible? And if it is possible how can i do it? It would be great help if some one could help us on this. Thanks
Hello, I tried to follow guide lines in this article to make a connection to an Oracle Database with wallet https://community.denodo.com/kb/en/view/document/Accessing%20Oracle%20Autonomous%20Database%20from%20Denodo Test connection receives this error...
Hi support team, I'm having trouble putting this query into my view WHERE CONDITIONS, there is an AND Operators in front of the line This is my original query from oracle ... AND datedata+(8/24)>=todate(tochar((sysdate+16/24)-1,'YYYY-MM-DD')|| '00...
Hi Support, I have noticed that, whenever I have any of the column/data type changes at source level of any of my developed(cached) views, My cached views got automatically invalidated? so the Question is, Is there any way to keep the cache db as it ...