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.

Detailed test results with Denodo testing tool
answered 03-12-2019 19:07:25 -0500

How can we get a detailed test result with rows from both "Execution" and "Result" for rows which failed the test case. Right now we only get the number of row and the mismatch value, this result is difficult to decipher in cases where execution and R...

Answers: 1

Denodo TEsting Tool

avinash
answered 03-12-2019 10:54:48 -0500

ARS :: Same/Diff Sav Roles:: Same config for Parent & Delegate :: Request History ::Delegate not able to see Parents request , Also his own records are not appearing as per the Advanced Query

Answers: 1

Need 3 digits after decimal
answered 02-12-2019 21:19:11 -0500

Hi Team, I want to know is there any function in denodo just like to_number in oracle ,which can give me 3 digits after decimal. For example :Suppose in a column(let suppose amount) there are values like. 1.01 1.256 .355 1.1 Expected output 1.010 1....

Answers: 1

Same query run in different servers, one is fine and another has errors
answered 02-12-2019 16:29:31 -0500

When run a query, got below error: QUERY [VIRTUAL] [ERROR] QUERY [JDBC WRAPPER] [ERROR] QUERY [JDBC ROUTE] [ERROR] Received exception with message 'ORA-20000: Error in pkg_get_read_data.fn_pl_get_entity_detail ORA-01792: maximum number of columns in a...

Answers: 1

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

JDBC Denodo 7.0 non-JRMP server at remote endpoint 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