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 April 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

FTP File transfer from denodo server to unix server
answered 04-12-2018 04:32:03 -0500

Hi Team, We are using denodo 7.0 version, we are new to the tool. We want to transfer file which is generated by one of denodo already existing job. We need to transfer the file from denodo server to the Unix/linux server path which is used by informa...

Answers: 1

Date Time issue
answered 03-12-2018 18:39:04 -0500

Hi Experts, My date table is in UTC and date column doesnt have any time stamp in source db. in VDB it is defined as Date column. when I query this table from EST it is converting to EST time zone and showing(Example: Date column--> Mon Feb 20 19:0...

Answers: 3

Date Conversion

how to avoid time zone conversion in Denodo ?
answered 03-12-2018 14:17:40 -0500

Hi, Is there a way we can avoid any implicit timezone conversion in Denodo ? We have a column in a table which house datetime from different regions of US along with an additional Flag column which tells us about the time zone of the row. In this scena...

Answers: 2

ping script
answered 03-12-2018 10:47:01 -0500

Hi, Has anyone tried this before Create a lightweight View that checks if Virtual DataPort is alive: CREATE VIEW ping_query_view AS SELECT 1 FROM Dual(); Check that you can execute this view through the RESTful Web Service. Notice that you need ...

Answers: 3

Flatten Parent Child Hierarchy
answered 03-12-2018 10:46:58 -0500

We need to flatten a parent child hierarchy into one row like level 1, level 2, level 3...base level. Level 1 is the top parant and base level is the child (lowest level). Level could be ragged but we can set fixed level. For example, we can set level ...

Answers: 1

Parent Child Hierarchy

Export vs export database
answered 03-12-2018 08:53:23 -0500

What is the difference between export and export database? Thanks, Hamid

Answers: 1

Denodo 6.0

Denodo VQL backjp restoration Errors and vql restoration step by step process
answered 03-12-2018 06:03:26 -0500

I am trying to restore Denodo vql backup from Vdp tool, it was ended with few errors and after restoration I noticed as only databases and folders are there, nothing is there inside the folders.. How can I get complete data One of developer asked ...

Answers: 1

import restore vql restore

searching for null values in formatted date datatype
answered 03-12-2018 04:55:32 -0500

I have a database whose date datatype is "CHAR" So inside denodo i used format date and to date function to convert the date datatype I am able to search the date dynamically with Between operator but I am not able to search for null values or empty va...

Answers: 3

Scheduler Integration
answered 03-12-2018 04:53:01 -0500

Team , We would like to use TIDAL scheduler for Processing data in a .csv file from a view to a different path. We don't want to use "Denodo Scheduler" which does this. We would like to know how we can integrate the 3rd party scheduler. Thanks, Sidd...

Answers: 5

Tidal

Allowing Multiple inputs in SOAP webservice
answered 30-11-2018 08:35:13 -0500

Hi, I have created a SOAP webservice with fields field1,field2,field3 in input and multiple outputs (field4,field5)(field4,field5) BUt the requirement is I need to send multiple inputs in the request example {(field1,field2,field3)(field1,field2,field3...

Answers: 1