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.

Availability of DENODO on a Google cloud platform
answered 02-12-2019 06:48:30 -0500

Denodo offering as a Service on GCP -- Loki

Answers: 2

ODBC with SAP HANA in Linux
answered 29-11-2019 06:32:19 -0500

Hello, In a linux server I have installed Denodo, and I need to create a ODBC datasource to connect with SAP HANA, and I readed that I need to use SAP HANA 2.0 ODBC driver. How can I configure Denodo and how can I create the datasource?

Answers: 1

ODBC SAP Linux SAP BW/4HANA DataSource

How to use dynamic dates in where clause
answered 27-11-2019 20:11:56 -0500

I am creating a view out of a Teradata database that has the date columns formated as YYYYMM and YYYY-MM-DD. Rather than a date WHERE condition based off of a static date such as '2019-10-31', I want a range based of a dynamics dates such as "ADD_MONTH...

Answers: 1

Dynamic Dates WHERE CONDITIONS

Connection refused to host localhost
answered 27-11-2019 14:34:21 -0500

Had installed Denodo Express and when trying to launch it, I got the nested exception: "java.net.ConnectException: Connection refused:connect". Could you help ?

Answers: 1
Related to: Starting the Denodo Server

java.net.connectException nested exception

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

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

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