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 create map with query a view? where is my map
answered 24-09-2019 08:27:55 -0400

Hi team, I create a map with below and it can be used. CREATE MAP SIMPLE dates_test ( 20190701 = 2020091 20190702 = 2020092 20190703 = 2020093 ) Question is: I looked for all my database, I cannot found this map? where is located in? Also, since I have...

Answers: 1

map

Top-down update
answered 24-09-2019 08:19:56 -0400

I have understood that the bottom-up update (narrow black arrows in the picture) takes place in real time, but it is not so clear if the top-down update (fat red arrows in the picture) is possible, and, if this is the case, how? i.e. if an external a...

Answers: 1

scai finance

ERROR: Syntax Error: Exception Parsing query near 'show'
answered 24-09-2019 08:13:43 -0400

Hi, I am trying to get my odbc 64 bit connection working on my pc. my 32 bit works fine. For this 64 bit I am using PostgreSQL Unicode(x64). I have the same settings as my odbc32. Except the postgresql versions are different. 32odbc i run ANSI 9.03...

Answers: 1

PostgreSQL

See all columns/fields with a certain datatype in Denodo 7
answered 24-09-2019 05:58:55 -0400

How can I see all fields that are using a certain datatype across all or per virtual database in Denodo 7? In particular we would like to make an inventory of fields that are using deprecated date type.

Answers: 1

Truncating values and creating another record
answered 24-09-2019 02:34:56 -0400

I am having a strange issue with Denodo, while I execute a table directly and fetch a description column which has values of Lenght 450, it fetches and shows the data correctly. When I join this table with another table and fetch the same description ...

Answers: 3

datasource fields text

OneDrive Connetion
answered 24-09-2019 00:08:46 -0400

Hi Team, We i use OneDrive as a source connection ? If yes means , please send me the link or document to build a oneDrive connection. Thank you, Lavanya

Answers: 1

Pass user credential from Tableau to Denodo
answered 23-09-2019 12:38:12 -0400

Hi, We have user based row level security setup in Denodo and hence we need to pass username from Tableau to Denodo. We can setup an odbc connection but then how does one pass username using an odbc connection. Thanks

Answers: 2

com.mysql.jdbc.Driver'. This is deprecated
answered 23-09-2019 08:29:43 -0400

Hi Team, I am getting a warn when connecting the solution manager external database using the mysql aws aurora. Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class iscom.mysql.cj.jdbc.Driver'. The driver is automatically reg...

Answers: 1

com.mysql.jdbc.Driver

Denodo Cached Base View Issue: returns 0 records in left join
answered 23-09-2019 08:11:59 -0400

Nevermind! Figure out the issue.

Answers: 1

Base view Query Cache

Denodo: see users where role is attached to
answered 23-09-2019 06:16:52 -0400

Hello, I can easily see in VDP admin for each user which roles it has attached; but it is not clear how I can show for a certain role the users (or other roles) it is attached to. How can I see it?

Answers: 1