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.

Can I use Denodo Express 7.0 open source in production?
answered 21-06-2019 04:32:38 -0400

Hello, Can I use Denodo Express 7.0 (free version) in production environment, with large amount of data (millions of records)? The features provided by Denodo Express 7.0 is precisely what I want and I cannot go for a licensed software. We are intend...

Answers: 1

Using the APIs
answered 20-06-2019 18:14:58 -0400

Hi, I wanted to use the API "Edamam Recipe Search API". How do I find the 3scale application ID and 3scale application Key for my application to provide to this API?

Answers: 1

Support for KDB database
answered 20-06-2019 12:17:35 -0400

Does Denodo product suppport integration with KDB database? We have some data residing in KDB database and we will like to host Denodo in front of it to intergrate with other data sources.

Answers: 1

Floating points not recognized correctly
answered 20-06-2019 08:47:15 -0400

Hi guys, I'm working with VDP 7.0 and I have this CSV file that amongst other airport-related data contains latitude and longitude information. Here's a sample row of the dataset so you don't have to download the whole file: 34,"Castlegar/West Koote...

Answers: 3

CSV data types Data Type Conversion locale

Npgsql using EF Core
answered 20-06-2019 08:29:32 -0400

While trying to connect to the Denodo VDP using the sample set provided I am getting the NpgsqlException: Unknown message code 43. Looking at the VDP error log on the server it shows that there is some error with the Kerberos authentication: Error: au...

Answers: 1

C# Entityframework Npgsql

Phrase "Maximum size in memory" is unclear in the following topic: configuring the memory usage and swapping policy
answered 19-06-2019 05:41:20 -0400

Review this topic: https://community.denodo.com/docs/html/browse/7.0/vdp/administration/server_administration_-_configuring_the_server/configuring_the_memory_usage_and_swapping_policy/configuring_the_memory_usage_and_swapping_policy#configuring-the-mem...

Answers: 1

#swapping #memoryusage

How to run statistics using Denodo Scheduler
answered 18-06-2019 20:37:32 -0400

I tried to use Denodo Scheduler to update the stats on a base view following the instructions here: https://community.denodo.com/kb/view/document/How%20to%20update%20the%20statistics%20of%20a%20view%20automatically?category=Scheduler However, I always...

Answers: 1

scheduler generate_stats run statistics connect database

Converting time zones in Denodo?
answered 18-06-2019 08:55:19 -0400

Hi, What is the equivalent for the "AT TIME ZONE" (https://docs.microsoft.com/en-us/sql/t-sql/queries/at-time-zone-transact-sql?view=sql-server-2017) function in SQL Server in Denodo? How can we convert the (default) displayed time zone of timestamps...

Answers: 1

Delimited File sources with DateRange
answered 18-06-2019 07:58:32 -0400

Could someone provide an example which works for using Delimited Files with a date range in the file name (or path)? I have given up our own design for now, and I am currently trying to recreate the example from "Virtual DataPort Administration Guide"...

Answers: 4

Interpolation Variables Delimited Files