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.

2 solution managers 1 for production and1 for others
answered 20-01-2020 10:37:41 -0500

Hi, Can we have 2 solution managers installed. One for production and 2nd for other dev/test/QA etc. The reason is production team will not take any responsibility of any enviornment other than production. What's the best practice to deploy scripts to ...

Answers: 1

Unable to start webcontainer
answered 20-01-2020 05:54:39 -0500

I am not able to deploy any web service. When I check the status of Webcontainer, it says OFF. WEBCONATINER START in VQL shell is unable to start. It says started but even after 30 minutes the status is still OFF. When I check the status: webcontainer...

Answers: 1

Manage outlier with Denodo
answered 17-01-2020 23:47:36 -0500

Good afternoon, how can I manage the outlier in Denodo. Verify that they exist and then be able to eliminate them. It is to say from a list of quantities I have values that are exaggeratedly high or exaggeratedly low that will interfere with my data....

Answers: 2

Configure fields to ungroup or group dates
answered 15-01-2020 13:57:06 -0500

I want to make an integration of data where I can manage the date, that is to say a type of query for a period of time. Weekly sales, monthly sales, among others. Greetings from Ecuador.

Answers: 2

Using Denodo VDP admin database as source from Talend
answered 15-01-2020 13:33:47 -0500

I got Denodo AWS trial environment and trying to use Denodo as the source from Talend Data Catalog tool to test the metadata harvesting. I tried to use 'jdbc:vdb://ec2-54-175-90-97.compute-1.amazonaws.com:9999/admin' with 'admin/admin' as username/pwd ...

Answers: 1

aws free-trial

Load data from Google Sheets
answered 15-01-2020 10:24:47 -0500

Hello, I'm trying to load data using the Google Drive API from Google Sheets with Denodo. I followed the steps described here: https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Google%20Sheets%20Tool%20-%20User%20Manual an...

Answers: 1

Google Drive API

Fail query if filenames do not exist in path
answered 14-01-2020 12:03:16 -0500

Hi is it possible to fail the query if the required files are not in the path? I tried this, but in the path it is nos possible to set regular expressions (anychar). PATH /path/PATTERNAME_^DateRange("yyyyMMdd",@startdate,@enddate,"yyyyMMdd")(.*) <...

Answers: 1

Collecting Field wise stats without using CSV
answered 14-01-2020 08:45:13 -0500

How can I generate statistics at a field level using the scheduler without creating the csv or the base view to pass the viewname and fieldname values ?

Answers: 3
Related to: How to update the statistics of a view automatically

Automic scheduler Gather Statistics Generate stats

Populate Denodo view parameters from another table / sub query
answered 14-01-2020 07:30:27 -0500

Hi, I have a view with two data parameters as below SELECT * FROM people_data WHERE effective_date >= in_from_effective_date AND effective_date <= in_to_effective_date USING PARAMETERS ( in_from_effective_date : DATE CURRENT_DATE(), in_to_effec...

Answers: 4

Delimited File Error
answered 14-01-2020 07:10:08 -0500

Hi all, During the Denodo 7.0 lab DEN70EDUD1102LAB01 I have created the log data source successfully, however cannot perform the creation of a base view; every attempt results in the folloing error: “There was an error while creating this base vi...

Answers: 1

Base view Delimited Files