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.

Encryption & Decryption of the Cached data
answered 21-09-2017 09:55:17 -0400

In denodo, we have ln-built functions to encrypt/decrypt data for each column but we need it as all data together send it to caching should be encrypted and when we retrieve all together from cache should be decrypted. Any suggestions should be appre...

Answers: 1

REST API Data Source- "Error Content is not allowed in prolog."
answered 21-09-2017 09:14:58 -0400

Hi Team, I am trying to create XML datasource using HTTP Client as Data Route. API needed basic authentication, header and body in JSON. Conect type is application/json. It does not support XML. I was able to create connection sucessfully, at least ...

Answers: 1
Related to: Error creating JSON data source with "Post Body" parameters

REST API

Unable to Start to VDP server. Service is getting stopped. Tried through Denodo Platform Control Centre and also through Windows Services tab. Please advise
answered 20-09-2017 08:44:36 -0400

Unable to Start to VDP server. Service is getting stopped. Tried through Denodo Platform Control Centre and also through Windows Services tab. Please advise

Answers: 1

VDP server

Scheduler Output to Fixed Width Text File
answered 20-09-2017 07:28:27 -0400

Can denodo scheduler output to fixed width text file? If no what's the workaround?

Answers: 1

fixed width

Cache bulk load onto sql server using bcp is failing with bcp error
answered 20-09-2017 03:42:45 -0400

I'm trying to do a bulkload cache, and facing the below error. If run manually the bcp command we can put a file to write the errors during execution. But since this is triggered by Denodo how do catch the errors during bcp execution. Below is the erro...

Answers: 4

bulkload error bcp Cache

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