Q&A

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

How to connect oracle database from denodo vdp
answered 23-09-2019 04:29:33 -0400

How to connect oracle database from denodo vdp, i am using oracle 12c, while connection i am getting unknown sid error.

Answers: 3

oracle database connection

Scheduler: export
answered 23-09-2019 04:16:42 -0400

Hi, What is the pourpose of exporting the results of Scheduler's extraction acitvity in VDP? I guess that external applications could recive these results automatically, no? Thank you in advance

Answers: 2

scheduler Denodo Scheduler 7.0 scai finance