Q&A

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

How can we display multi queries/views data in multiple tables using REST in VDP?
answered 20-06-2019 01:27:07 -0400

7.0

Answers: 1

JDBC query Base view VDP

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

Git commit failed with operation cannot include non-modified, non-marked-for-deletion out-of-sync elements
answered 18-06-2019 05:39:52 -0400

Hi, I have a setup like: database1 database2 database3 database1 is the source database where I create all my views and database2 and database3 use the views referenced at database1. Now, I have integretaed all these database with git and when I am ...

Answers: 3

How to connect to other database using Denodo
answered 17-06-2019 06:01:46 -0400

How to connect to other database using Denodo

Answers: 1