Q&A

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

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in September 2019.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

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

LDAP CONNECTIVITY
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

LDAP

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

subquery

Migrate only users and roles.
answered 11-10-2019 03:30:07 -0400

I want to create a script which have only create commands for all the users and roles for that database or server.So that same users and roles can be created in different server using those commands .Please let me now if any one have other solution to ...

Answers: 3

How does the license work?
answered 10-10-2019 09:09:54 -0400

The documentation says that the use of a license can end if "The maximum number of cores / processors / servers defined by the license was exceeded", does the license manager have the ability to review that? In case the client already has a server (for...

Answers: 1

License