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 April 2018.

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

Cannot remove filed in Final View
answered 18-09-2017 09:29:54 -0400

Background: Many columns have already been dropped from the base view. When we try to drop these columns from a view built off this base view, I can drop some but not others through Edit, Output. We get an error message "The selected fields cannot be r...

Answers: 1

Adding Logic to Join View
answered 18-09-2017 08:47:01 -0400

Hello, I am having some issues designing a solution to a feature that I need to create. Scenario: I have a data set with a specific field that needs to be modified when a condition true is passed in from the web service and not modified when a condi...

Answers: 1

VQL REST join Logic Web Service

Varbinary data type not exists in Denodo
answered 18-09-2017 07:58:32 -0400

HI All, We are trying to convert the unique identifier to Varbinary data type. it is not supporting by denodo which can be done in sql.

Answers: 1

Data Lineage Report in Excel
answered 15-09-2017 08:25:38 -0400

I have created and SOAP Service using through multi step approch creating multiple derived views from Database base views. However, I would like to capture all the linege(all intermediate steps) and Base View to Service View mappings in a spreadsheet. ...

Answers: 1

Excel Lineage

Denodo 6.0 scheduler server configuration
answered 15-09-2017 04:29:25 -0400

Hi Guru's In Denodo 6.0, scheduler server configuration to enable cluster settings what are the settings to be enabled if servers are load balanced and Db is Derby.

Answers: 1

Denodo 5.5 and 6.0

create a datasource in denodo
answered 13-09-2017 08:09:57 -0400

Hi, How to create a datasource in denodo connecting to denodo database.? Regards Karthi

Answers: 1

DataSource

how to change from localhost to the host name in ISS
answered 13-09-2017 08:02:35 -0400

Hi , I would like to know how do i change the "Login from VDP" option from localhost to specific host name. Thanks in Advance

Answers: 1

Problem creating base view from SQL Server stored procedure in Denodo 6
answered 13-09-2017 07:06:02 -0400

I am trying to migrate from Denodo 5.5 to Denodo 6. I had a base view named JMPSTART_BV_GETSAMPLE that was created from a query against a MS SQL Server 2014 database. The query is the following call to a stored procedure that returns a resultset: EXE...

Answers: 1

connect to IBM DB2 for i / version 7.1
answered 12-09-2017 09:46:42 -0400

Hi, i am new to denodo and am trying to connect to 'IBM DB2 for i / version 7.1'. I can create a connection using DSN but can't save it as it gives the error '...adaptor is not allowed by the license' When i am trying to use JDBC, then i can't see any...

Answers: 7

Error when Connecting to Denodo using ODBC Driver
answered 12-09-2017 09:44:50 -0400

Hello, I am working through the Denodo tutorials and am at the 'Connecting from your application' stage, working on ODBC clients. When trying to connect to the Denodo database using Excel (32-bit), I get this error: DataSource.Error:ODBC:ERROR[HY000]...

Answers: 1