Home / Q&A / All Questions

Q&A

You must sign in to ask a question. If you do not have an account, you can register here

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

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