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.

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

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