You must sign in to ask a question. If you do not have an account, you can register here

Character MisMatch Error while using Coalesce function in Denodo
answered 17-10-2019 05:46:17 -0400

Team , We are using Coalesce function in Denodo which is equivalent of NVL in Oracle. Source Datatype for that particular column is NVARCHAR.We are able to see the data in Base views for these columns. However , While using Coaleasce function in deriv...

Answers: 1

executeVqlCommand(String databaseName, String command) doesn't take account of the databaseName.
answered 16-10-2019 13:48:51 -0400

I'm building a StoredProcedure to change the schemaName of all (Jdbc) baseView of a specified DataSource. I'm using the Denodo java extention. The StoreProcedure is in admin denodo database and i would be able to change the schema name of a baseview ...

Answers: 2

Denodo driver does not support datasource pooling
answered 16-10-2019 08:24:44 -0400

I am trying to connect to Denodo server using VDB JDBC driver. I want to access it through a WebSphere Application Server Application where I am trying to set a Pooled data source with following config: Implementation class: com.denodo.vdb.jdbcdriver....

Answers: 3

Driver JDBC

Denono automatic names for fields when importing base views
answered 16-10-2019 06:15:31 -0400

It seems like Denodo is changing the names when it creates a base-view, from the data source names. I just do not know where to read the rules from. Is there a way to make sure that field names will not be changed (exposed the way they are exposed byt...

Answers: 3

names baseview

Denodo 7.0 training is inaccessible ,getting Authorization error.
answered 15-10-2019 07:47:03 -0400

Hello Team, While doing training for Denodo 7.0 Interediate developer, Getting Auth Error in the Middle of training. Training Module: https://denodolearning.litmos.com/home/LearningPath/73474 Error Details: Application Not Authorized to Use CAS Th...

Answers: 1

How to use a base view as a data source ?
answered 15-10-2019 07:19:13 -0400

Hi, I'm currently having 3 views in oracle and i have created a base view in denodo for each of these Oracle views. On Oracle views are running different reports and i have to run these queries on the base views. Now the question is, how i can use t...

Answers: 3

data source base view integration view oracle

Odata v4 to Denodo Connection Error
answered 15-10-2019 06:32:58 -0400

Hi, I am trying to get data from odata v4 api calls using denodo. i have added odata v4 custom wrapper jar file and created connection between odata v4 and denodo . When i hitting query select from view it gives error like http:400 bad request but wh...

Answers: 1

answered 14-10-2019 09:11:53 -0400

Hi Team, I am bale to connect the ldap server. Now I am trying access the objectclass=person using the base view and am getting the error and log shows at com.denodo.vdb.engine.thread.ReusableThread.b3(Unknown Source) [denodo-vdp-server.jar:7.0.4] at...

Answers: 1


Daily Data refresh for Remote tables
answered 14-10-2019 08:20:48 -0400

Hello, I'm using remote table to create a table and load the data in an oracle database. will the load refresh automatically if there is any new data in the base view. or do we have to exceute the base view again to perform the data refresh. Can it ...

Answers: 1

Subquery giving an error
answered 14-10-2019 07:13:30 -0400

Hi I have a VQL query as follows: SELECT * FROM bv_getlistdata WHERE sessionhandle = '123456' and token = (SELECT requesttoken FROM bv_request) The view bv_getlistdata has 2 parameters sessionhandle and token and the bv_request view has a single ou...

Answers: 3