Q&A

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

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