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 September 2019.

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.

This driver is not configured for integrated authentication
answered 03-07-2019 08:32:29 -0400

Version Denedo 7. SQL Server Version: SQL Server 2016. Jar File version : mssql-jdbc-6.4.0.jre7.jar File :sqljdbc_auth.dll exists in c:\windows\system32 and exists in <DENODO_HOME>/jre/bin. Connection string is in order. But, Failed to establish...

Answers: 1

This driver is not configured for integrated authentication denodo

How to view the Underlying Table or the CSV file Names using data lineage capability of Denodo Catalog
answered 03-07-2019 05:42:00 -0400

How to view the Underlying Table or the CSV file Names using data lineage capability of Denodo Catalog. While browing we were able to view the underlying views and the data sources but cannot drill down further to know the underlying table or CSV files...

Answers: 1

#Data Lineage

List of Roles and complete hierarchy
answered 02-07-2019 08:24:56 -0400

How do i get the list of roles in Denodo and the complete role hierarchy?

Answers: 3

Role and User Management

How to identify if values in a column is numeric ( Function similar to Isnumeric is SQL)
answered 02-07-2019 07:45:30 -0400

Hi All, I am deriving one column logic where i have to check if the column value is numeric or not, i did not found any fuction like ISNUMERIC() here, can anyone please help how to achieve same in VQL. Thanks in advance.

Answers: 1

isnumeric() number values numeric

HTTP POST in Denodo Testing Tool
answered 02-07-2019 07:21:50 -0400

Is there any working to specify a HTTP POST request (including params + body params) in a QUERY and/or RESULT directive? Is there any plan to include this feature in a further version of the testing tool?

Answers: 2

Denodo Testing Tool

Denodo query simplification taking a long time.
answered 01-07-2019 21:15:17 -0400

We have a complex final view that utilizes many (20+) base views. All of the base views are cached so the query execution plan in very simple. However, in looking at the execution plan we can see that the optimizer is taking 8-9 seconds in query simpli...

Answers: 1

VDP query optimisation

OData2 Wrapper converting DateTime to "Local" DateTime?
answered 01-07-2019 09:00:51 -0400

I have been using a JSON data source and switched to a custom wrapper for Odata3 (using OData2 custom wrapper with headers 'Content-type="application/json";Accept="application/json";DataServiceVersion="2.0";MinDataServiceVersion="2.0";MaxDataServiceVer...

Answers: 1

ODATA OData Date Conversion Timezone conversion json JSON

NEED TO CONNECT IBM TM1 OLAP CUBES
answered 01-07-2019 08:41:59 -0400

Hi Team, I need to connect IBM TM1 OLAP Cubes as Data Source in VDP. I am unable to find the guidelines for the connecting IBM TM1 cubes. Please guide how to use TM1 cubes as data source. Thanks Kumar

Answers: 1

Multidimensional Data Source

User Management Question
answered 01-07-2019 07:40:14 -0400

Hello, Is there a way to export the list of users located under user management? The reason I am looking to export the list of users is because I am putting together a e-mail distribution list containing the emails of all users who use our denodo syste...

Answers: 1

user management export

Denodo on Concurrent Logins by the Same User
answered 01-07-2019 06:06:02 -0400

We have a requirement to disallow concurrent user logins with the same credentials. The requirement also includes prompting the user of concurrent log-in attempts being made with information on the location of the attempt being made. Is this possible ...

Answers: 1

Login Role and User Management