Home / Q&A / All Questions

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.

Denodo restful ws 404 error
answered 06-12-2018 07:40:19 -0500

Hi Team, Denodo Express 7 Windows 10 DB : admin Base View : client Web container : ON http://localhost:9090/denodo-restfulws/admin/views/client I get 404 page not found error. What I am doing wrong. What do i check to fix this issue. Thanks.

Answers: 1

REST

Passing Parameter to a MicroService dynamically
answered 06-12-2018 06:55:20 -0500

Hi I have a microservice running in python. I have created a http client data source in denodo for the micro service. the URL is like below request : http://localhost:5000/product/productno the last part of the URL is the parameter /productno I hav...

Answers: 2

Microservice

Query Timeout in denodo
answered 05-12-2018 09:02:35 -0500

Hi I want to increase only one object query time , i don't want to increase entire DB , is their any way we can increase sepecific object query time ?

Answers: 3

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

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