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.

License model for on premise installation
answered 10-05-2018 05:46:02 -0400

Hi , Please share the denodo license model for on premise installation.

Answers: 1

Lice

Datatype Issue while creating a base view from SQL Server
answered 10-05-2018 03:00:38 -0400

I have a table in Sql server with a column of date datatype. For this instance : Create table table_name ( dob date ) ; I have created base view on top of this table. But in base view, datatype of dob as text datatype in denodo which is not expected...

Answers: 1

DENODO MSSQL SQLServer sql server datatypes Date

Ms-Access database connection
answered 10-05-2018 01:34:49 -0400

Dear Sir, I have data in the MS-Access database and please let me know the procedure for connecting these database from the Denodo Tool. Give with example of connectivity. Regards, Senthil

Answers: 1

MS-Access-db-connection

SSO from Tableau Server to Denodo
answered 09-05-2018 07:37:17 -0400

It has been stated before and known that Tableau to Denodo SSO works with Tableau Desktop, via Kerberos, but not with Tableau Server. Unfortunately many of our users access Denodo through tableau server (url) and have to sign in a second time to get to...

Answers: 1

Tableau SSO

How can we calculate DAYLIGHT SAVING TIME using Denodo functions dynamically?
answered 09-05-2018 06:36:53 -0400

Hi All, I want to calculate dynamically day light savings time using denodo functions. I see lots of in-built functions are available. Can someone please help calculating it? Thanks,

Answers: 1

Denodo 6.0

A synchronize error has been found
answered 09-05-2018 06:34:16 -0400

While creating a base view from database I'm getting this error "A synchronize error has been found"

Answers: 1

database Denodo 6.0 Error synchonization

Type conversion for Decimal point
answered 09-05-2018 05:00:45 -0400

HI, I am using the following formula, (qccount/transvalue) The value for qccount = 1 transvalue=47 so output is 1/47 = 0.021276596 but i am getting the 0 only. I tried to use cast('double',(qccount/transvalue)) but the output is 0.0 only and another...

Answers: 1

Decimal Type

Impala with Denodo
answered 09-05-2018 00:39:28 -0400

Hi, We have Impala 2.11.0+cdh5.14.0+0 and Denodo 6. Could you provide steps in connecting these two components? Thanks, Krish

Answers: 2

While executing a base view pointed to Postgre SQL from denodo, transaction is opened in Postgre SQL even we use Source configuration as SUPPORTEDDISTRIBUTEDTRANSACTIONS as false in the view defination
answered 08-05-2018 08:09:10 -0400

We have created a base view pointing to Greenplum and when we try to execute and verify query in Greenplum, we are seeing begin & commit transactions even for reading the data. We modified the view to use SUPPORTEDDISTRIBUTEDTRANSACTIONS property a...

Answers: 2

greenplum JDBC

Slow response from Denodo
answered 08-05-2018 07:56:13 -0400

Hi, Environment: Database Oracle 12c Denodo : 6.0 We have a table (sa_suppliers) with about 162,000 rows, 110 columns and occupying about 118 MB When we query this table (no join with anything else), the response is very slow. Typically, if we select ...

Answers: 1

Oracle 12c