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.

Connecting Denodo to Microsoft SQL Server
answered 27-11-2019 12:41:40 -0500

I tried to connect Denodo to Microsoft SQL Server but failed (issue with Host name and Port number). Find the error that I have received below. "Unable to establish connection: The TCP/IP connection to the host loaclhost, port 1433 has failed. Error:...

Answers: 1

Denodo_MSSQL

DEN70EDUD02 MySQL server connection issues for DEN70EDUD2002LAB04
answered 27-11-2019 10:39:50 -0500

I am trying to go through DEN70EDUD2002LAB04 and noticed there are issues with connection to a MYSQL server. I followed the steps of adding the jar file from the MYSQL website (adding both the 5.x and 8.x jar files in the lib-external/jdbc-drivers/mysq...

Answers: 2

Denodo_MySQL MYSQL vm

Api Post with session user
answered 26-11-2019 18:19:45 -0500

I would like to find out if we have Api to post and put , do you know a way how we can pass the session user and time to the table to capture who created and when For example if we have table Id Name Updatedby UpdatedDate If I post a record with the...

Answers: 1

#Post #webservice #Json #API #Insert API users

Pass Through kerberos Authentication - Hive
answered 26-11-2019 18:04:23 -0500

I am looking for information on setting up a new data source using JDBC with a pass through credentials to a Hive metastore that uses Kerberos authentication. Please share details to on setup and configuration info.

Answers: 4

kerberos authentication debug

Connecting to Microsoft SQL Server
answered 26-11-2019 15:59:07 -0500

Can you guys show the steps on how to connect to Microsoft SQL Server to import data and to virtualize it in Denodo? Like how you guys did in the link attached below for MySQL. And currently I am using Denodo 7.0 (which is the latest version), but the ...

Answers: 1

Denodo_MySQL Denodo_SQL_Server

Column precision error for decimals
answered 26-11-2019 14:15:53 -0500

I'm getting below error when I execute my final view. This view contain more then 130 columns which I've made change for 'Decimals' Is there a way I can find that specific column because of which I'm getting this error. Finished with error: Error exec...

Answers: 1

Error Data Type Conversion

Exception parsing query near 'SCANNER'
answered 26-11-2019 07:15:26 -0500

I tried to deploy the wrapper from ITPilot to VDP. But it failed saying that 'An error was found while performing the operation: Syntax error: Exception parsing query near 'SCANNER''. Can you guys resolve this issue?

Answers: 3

SCANNER

User Access History
answered 25-11-2019 21:00:51 -0500

Hi Team, Denodo 6.0 Does Denodo stores user privilege and role assigning history and which user assigned access ? Through catalog permissions() we can view the recent permissions. But how to find : which user assigned the permission/role to ano...

Answers: 1

Role and User Management

how to use excel microsoft query to do some aggregation function on one denodo views?
answered 25-11-2019 13:10:19 -0500

I have configured 32-bit ODBC, and let my excel connect denodo views. I can pull the data from denodo to excel in detail level, how do I use microsoft query to do some aggregation caculation on some view. For example, denodo view_a (contain column mont...

Answers: 3

excel

Access interface in vdp connections file.
answered 25-11-2019 13:10:10 -0500

Hi Team, In "vdp-connections.log" file from Denodo Monitor. What could be the possible values for "AccessInterface: Type of access interface of the connection". ? I am intersted to know if "VDP" here would mean "Scheduler" Job. ? Please tell. Thanks.

Answers: 5

vdp connections file