Q&A

Is it possible to write back to a delimited file?
answered 05-12-2019 23:59:12 -0500

Working on denodo 7.0. Is there anyway where a base view created on delimited file (like csv file) can be used to insert data back into file?? Regards, Gopal Krishan

Answers: 1

Copy of the Database / Folder
answered 05-12-2019 23:56:46 -0500

Can we make the copy of the folder or database in the same environment in Denodo 6. The clients doesn't maintain the repository - to handle any changes - planning to make the copy of the existing views and make the changes in one copy which may help t...

Answers: 1

Duplicates

How to get "Result" values from jobs in Scheduler
answered 04-12-2019 12:20:49 -0500

We are trying to get the history detail for each job using the scheduler API. We are able to get the start time using the JobReport.getStartTime p.e. However, we are not able to get the "Result" values (COMPLETE, ERROR etc) for each execution in the ...

Answers: 6

#Scheduler #SchedulerAPI

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