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 November 2018.

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.

Denodo connectivity to COSMOD DB
answered 03-04-2018 08:43:21 -0400

Can Denodo VDP(6.0/7.0) connect to COSMOS DB in Azure? Appreciate if somebody can share any implementation details or alternative, if that is not possible out of the box

Answers: 1

Connectivity

Create all schedule job at one go
answered 02-04-2018 11:19:54 -0400

Hi Team, My requirement is to daily cache 200 views with daily data. For this I will be creating 200 jobs in scheduler and I will be scheduling this using Denodo schduler. Is there a way or utility to create all these 200 schedule jobs in one go or d...

Answers: 3

Tuple pattern for delimited file multiline
answered 30-03-2018 19:58:15 -0400

Hi Denodo Team, I have a delimited file with the below data format. In DVP, i would like to create a delimited file data source in tabular format. I have looked at the example given in the thread "Extract from Delimited File" from 2015 but could not g...

Answers: 1

Delimited file data source delimited_files tuple

can not login with admin
answered 30-03-2018 09:14:24 -0400

i intsalled denodo in c /programe\denedo folder but not able to login. connection error: connection refused: admin when i tried to install it in other folder it is shouwing acess denied ..even after i am trying to run with administrator.. Please help

Answers: 3

While login below logs are there,cant login please help
answered 30-03-2018 09:07:29 -0400

0 [SwingWorker-pool-1-thread-2] ERROR 2018-03-22T15:32:14.919 com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxy - connection error: Connection refused: connectcom.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: connection error: C...

Answers: 3

JOIN views: adding a suffix/prefix with the source view name to the field names?
answered 30-03-2018 08:25:58 -0400

Is there a way to include a prefix or suffix in the field name when joining views (e.g. the source view name)? (except of course adding them manually for each field, which could be prone to mistakes especially over time) This adds some traceability an...

Answers: 1

to_date() function not working with Denodo express?
answered 30-03-2018 03:30:10 -0400

I have a flat file that looks like this: 2018-03-27T12:12:00|0|Idle|0 2018-03-27T12:12:00|652|GoogleCrashHandler64|0 2018-03-27T12:12:00|5888|GoogleCrashHandler|0 2018-03-27T12:12:00|484|smss|0 No headers, 4 columns: Column 1: date/time in yyyy-MM-d...

Answers: 3

ADABAS Experience
answered 30-03-2018 02:04:50 -0400

We have a customer who has ADABAS on the mainframe and I was wndering if anyone had some experince with this? I heat there is a JDBC interface. I also heard ADABAS is not entirely relational. So, JDBC may not cover all that is necessary. Thanks!

Answers: 1

JDBC

Connection to oracle fails when denodo jdbc jar is used in a java project
answered 29-03-2018 09:02:33 -0400

Whenever the denodo jdbc driver is added to the maven project and a connection to denodo is established, connections to other oracle databases fail. When the denodo driver is removed from the project, oracle connections are successful. I need to use ...

Answers: 1

get_source_table
answered 29-03-2018 08:15:13 -0400

how to repliacte functionality of get_source_table stored procedure in VDP 5.5 in VDP 5.5 :: select * from get_source_table() Error executing sentence: Stored procedure 'get_source_table' not found

Answers: 3

Stored Procedure