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 updated version of the Denodo Express 6.0 with new features and fixed issues starting in June 2017.

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 6.0 at the Express home page in the Denodo Community

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

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

REST API

Protocol to connect Denodo Scheduler from a third party
answered 21-09-2017 01:01:38 -0400

Hi Support, We are planning to centralize all the jobs i.e. Windows Task schduler , SQL and Denodo into one. We have planned to use VisualCron for this. Can you help us with the protocol(FTP/SCP/SMTP/POP3/IMAP/SSH/WebDav) to select to connect Denodo Sc...

Answers: 3

DENODO Denodo Scheduler 6.0

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, the...

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

Analytical functions not delegated to the cache database
answered 19-09-2017 04:21:50 -0400

Why are the analytical functions not delegated to the cache database? The cache database is Oracle. This query on a cached table: SELECT code, omschr, vervallen, lag(code) over (partition by vervallen order by code) FROM peter_test_cache_cszislib_arts...

Answers: 3