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 November 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.

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

Hiding views used in the scheduler.
answered 19-09-2017 09:13:30 -0400

Denodo 6.0 I created a few derived views that I use as a base in the scheduler to pupulate tables in a separate database. I dont want this views to be seen when users connect via ODBC with a BI tool(Tableau). Is there a way to hide them?

Answers: 1

Create associations from foreign keys
answered 19-09-2017 07:04:15 -0400

Hi, I have a problem on creating associations from foreign keys when creating base views from a JDBC data source (MS SQL Server 2014(MS Driver)). When I click the “Create associations from foreign keys” button in the dialog with the created views, th...

Answers: 1

List role by assignment
answered 19-09-2017 05:37:57 -0400

Hi, I have Role A and assgin to Role 1, 2, 4, 5. Right now I have to open Role 5 to check if Role A from role management. Is there a vql to list Role 1,2,4,5 by Role A? thanks

Answers: 1

VQL Role

SSRS Multi Value Parameter
answered 19-09-2017 01:58:08 -0400

Hi, How to create a multi-value parameter in SSRS? In MSsql I do this sql Select * from table1 where column1 in (@values) But when I do the script below on Denodo Select * from table1 where column1 in (?) it returns error. Any Idea on how to pas...

Answers: 1

SSRS

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