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.

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

To add a parameter to a derived view
answered 14-01-2020 02:37:03 -0500

I have Denodo Express v7 and I'm trying to generate a view which handle view parameters, but the button to handle it in the Model Tab is always disabled, is it because I am using Denodo Express or it might be something else? (like some configuration is...

Answers: 3

Parameter View Parameter entry derived view

Audit List of query execution time is more than 800Sec
answered 13-01-2020 21:19:38 -0500

Hi Team, Could you please share the query or steps to take Audit list of query execution time is more than 800Sec

Answers: 1

Denodo version
answered 13-01-2020 12:55:43 -0500

Hi, How to get Denodo version using VQL script?

Answers: 1

Error connecting to SQL Server
answered 13-01-2020 09:40:32 -0500

I cannot connect Denodo with an SQL Server data source. I have used ODBC and JDBC, if someone can send me the step by step I would appreciate it. Greetings from Ecuador.

Answers: 2