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

Mismatch between source table count and cache table count
answered 12-09-2017 09:22:39 -0400

My source table has 6239797 rows and when applied full cache and did a pre cache load I could see row count as 6239794, 3 records are missing. There were no search conditions used. What could be the possibility of count mismatch ? I have ran the denodo...

Answers: 1

Cache

Denodo Monitor - load connections log file data to table
answered 12-09-2017 08:15:48 -0400

Hi Team, As we can direct the data of query log files to table in database. Can we direct the data of connections log files to table in database ? Please suggest. I am using sql server, and successfully loading query log files data to request notific...

Answers: 3

Denodo Monitor

Error: circular view definition found
answered 12-09-2017 08:08:28 -0400

Hallo, I installed Denedo 6.0 Plattform Expess. I have configured me a test environment with MySQL. I can read the sample MySQL DB Sakila. I have created the base views. I want create a join view. The Join view Works fine, but when I want save the view...

Answers: 2

date formate
answered 12-09-2017 07:30:13 -0400

i want to use date like 31-01-2013 in my conditional parameter. or date>='31-01-2013' how can we do it in denodo.

Answers: 1

JSON data source for POST operation
answered 12-09-2017 06:29:52 -0400

Hi, My Intention : To create an Denodo REST service with POST method for inserting data to Oracle through denodo service. I've already created Denodo derived view (Updateable) and exposed REST API which has only 3 attributes INSRD_NM, INSR_NM_MOD, S...

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

#Post #webservice #Json #API #Insert

How to connect to SQLServer localdb
answered 12-09-2017 04:21:38 -0400

Hello, How do I conect to the SQLServer localdb? These parameters do not work: 'D:\Denodo\extensions\thirdparty\lib\sqljdbc41.jar' jdbc:sqlserver://(LocalDb)\MSSQLLocalDB:1433;databaseName=denodoCache Error message is rather standard: Unable to ...

Answers: 3

localdb SQLServer

Error deleting database.
answered 11-09-2017 08:39:37 -0400

Hello, I faced with issue when tried to delete a database: Internal error: null Tried to delete using drop command and through VDP interfaca "Database administration" as well. I assume the reason is in a view in the database which also can not be de...

Answers: 1

Denodo on Cloud
answered 08-09-2017 10:47:40 -0400

Hi Team, We would like to know denodo configuration when it is on Cloud . Our Data soure would be relational MPP and Big Data ( Hadoop ) and downstream reporting tool will be Tableau/Google Studio 360/Cloud Data labs. In this case what would be the co...

Answers: 1

onpremise and AWS cloud

CSV Filename Column
answered 08-09-2017 10:12:02 -0400

I am curious if there is any way to include the filename or part of a filename for CSV files in the base view; something simlar to how the Excel wrapper can provide the sheetname as a column in the base view for an Excel data source. My use case scen...

Answers: 2

CSV

List All database
answered 08-09-2017 06:23:21 -0400

Hi, How to list all database using VQL script?

Answers: 1