Q&A

Issue with partially working denodo driver 7.0, pass-through SQL works fine, but accessing meta-data doesn't work
answered 02-12-2019 06:58:40 -0500

We are using the denodo-vdp-jdbcdriver.jar to establish a connection between our BI-tool (Cognos) and DB2/Denodo With Cognos, we are on 11.0.13.1 (LTS Fix Pack 1) We did one earlier install of the JDBC Denodo driver, and this runs fine on one Cognos ...

Answers: 3

non-JRMP server at remote endpoint JDBC Denodo 7.0 Java 1.8 jdbcSQLException

access denodo base view in DB2 database.
answered 02-12-2019 06:52:34 -0500

1) suppose i have created denodo base view say "View1" that fetch data from webservice. 2) Now i connected to DB2 database. how i can access "View1" from DB2 database ?

Answers: 3

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