Q&A

same DV query, but different runtime from VDP and Excel, VDP query add "trace" in the end of query, but excel dose not have "trace" adding to the end of the query
answered 19-03-2021 07:57:42 -0400

we have query something like below: select column_a, column_b, column_c, column_d, column_e, column_f from denodo_view_a where filter_a = 'aaaaa' and filter_b in ('bbbbb', 'ccc', 'ddd') and (filter_c like '4%' or filter_c = '323456789') and (column_a -...

Answers: 1

trace

Oracle Hint in Denodo
answered 18-03-2021 08:34:03 -0400

Hi, Based on this thread: https://community.denodo.com/answers/question/details?questionId=9060g000000L6u8AAC&title=Oracle+hint#:~:text=To%20take%20advantage%20of%20an,the%20context%20of%20your%20environment., in order to leverage on Oracle Hint o...

Answers: 1

Hint oracle hint comment vs hint

Webpage that Automates Oracle SQL to VQL Converter
answered 18-03-2021 08:33:01 -0400

Hi, I have very quick question -- is there an existing page somwhere that helps convert Oracle SQL queries to VQL? The intent is, through that helpful page (if it exists), we could quickly and easily convince our non-IT users to use Denodo derived view...

Answers: 1

Oracle to Denodo Oracle SQL to VQL Converter SQL to VQL

Cannot create oracle as a data source
answered 18-03-2021 07:52:34 -0400

We have managed to setup the Denodo solution manager and we are in the midst of configuring the oracle data source. The connectivity testing is successful but up on saving we are getting an error stating “Error saving datasource: SourceType (…) are l...

Answers: 1

Data Source Setup

Denodo Platform Control Center
answered 18-03-2021 07:49:44 -0400

Under the Virtual Data Port, the Data Catalog section states: "Not available due to license restrictions" It was available before. Under the scheduler section: Scheduler Server - same message - "Not available due to license restriction". Again, it w...

Answers: 3

Vitrual dataport administrator tool platform cannot be logged in
answered 18-03-2021 07:08:59 -0400

The management platform cannot be logged in, and the login prompts an error message. The logs show the following “Caused by: com.denodo.vdb.vdbinterface.common.connection.VDBConnectionException: authentication error: The username or password is incorre...

Answers: 1

administrator tool

Denodo Throwing error from the source
answered 18-03-2021 03:25:22 -0400

Hello, I have connected JDBC connection in denodo. When i load the data and create the view automatically using lamda function in AWS. When i run the view throwing below error: BC_YZ_RATAM_SELFSERVICE_EMEA_DE [BASE] [ERROR] ABC_YZ_RATAM_SELFSERVICE_E...

Answers: 2

#Denodo #denodotestingtool #testingtool #denodo Self-Service Base View descrptions Source refresh AWS S3 Athena #Athena #Baseview #Table_not_found #DataSource

I have created connection with azure databricks to be used as cache, and able to test bulk load. How this will work in real scenario?
answered 17-03-2021 09:22:28 -0400

I have created connection with azure databricks to be used as cache, and able to test bulk load. How this will work in real scenario? I have the mount on dbfs:/mnt/ folder. Created a base view on top of the datasource. But I need to understand how in r...

Answers: 1

databricks

Oauth Authentication in Denodo 7.0
answered 17-03-2021 08:34:46 -0400

Hi Team, What is the downstream application impact if we enable Oauth 2.0 in Denodo server level? Can JDBC/ODBC application can still connect to denodo using other authentication framework enabled? How to test the connection after Oauth 2.0 is enabled...

Answers: 1

#Oauth

Hyper-V DQVM not showing ip address
answered 17-03-2021 06:41:43 -0400

Hello, I'm new to Denodo and as part of my Denodo training i'm doing some on demand courses. Part of that is setting up a virtual machine on my laptop. I'm using Microsoft Hyper-V to launch the Denodo Training Quickstart Virtual Machine (DQVM). I (thi...

Answers: 1

Hyper-V DQVM