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.

Caching
answered 02-06-2020 08:20:28 -0400

Hi, I have partial caching enabled, and configuration is set on external database and allowed writing on the database. Also I exposed the view as a REST service. When I access the RET service it creates the table in the cache database but does not cach...

Answers: 1

Partial Caching

Query to AWS Athena
answered 02-06-2020 08:04:38 -0400

Do the Denodo query optimizations (aggregation pushdown etc) works with AWS Athena?

Answers: 1

AWS S3 Athena

Errors with ODBC client connection from SQL Server Polybase
answered 02-06-2020 03:49:04 -0400

Hi-- My use-case requires me to establish a Polybase connection from SQL Server using ODBC driver. I have successfuly followed instructions on: https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-configure-odbc-generic?view=sq...

Answers: 4

ODBC

Error removing JAR: Error loading User(XXXXXX)
answered 01-06-2020 09:41:49 -0400

Hi, I used the custom policy code provided in samples and added a user check and query contains check. Now i cannot delete the jar from jar management and get errors. Error removing JAR: Error loading User(XXXXXX) What is the solution for this? Than...

Answers: 4

custom policy Denodo 6.0

Incremental cache implementation in denodo
answered 01-06-2020 04:23:27 -0400

Hi Team, Our source is a custom java API using custom java wrapper, we have made couple of views in denodo. These views are cache'd everyday using scheduler jobs. After vdb cache job ran, we have set of vdb scheduler jobs which will export the cached d...

Answers: 1

Incremental Cache

Implementation process
answered 01-06-2020 03:58:14 -0400

All, Could someone please help me get an idea of what the implementation process is like when buying Denodo? Are there a lot of professional services fees required? Thanks.

Answers: 1

implementation onboarding professional services

Text (timestamp) to date
answered 01-06-2020 03:55:21 -0400

Hi. My view has a field with timestamp. Although, the field type is "text". I really only want to get a date from the field, but I don't know how. Here is an example of the text field: 2019-12-21T13:15:49.000-0600 2019-10-02T15:01:43.000-0500 I need ...

Answers: 2

Date Conversion Timezone conversion Dates Date

Create new date field from a timestamp
answered 01-06-2020 03:45:27 -0400

Hi. I have two views in Denodo (in different datebases). I want to join the two on date (and another ID). However, the views do not have date, they only store timestamp. I want to get just the date from the timestamp in both views and join them. Here ...

Answers: 2

Date timestamp

Mircrosoft Ajax Date Format
answered 29-05-2020 05:38:18 -0400

Hello, I have a Json Data source configured to get data from external application. I am seeing the data . But there are 2 cols, Updated At and Created At. values in those columns are coming in the format /Date(1589932800000)/ I tried creating a new f...

Answers: 3

JSON Data Source

Metadata from source system
answered 27-05-2020 14:34:47 -0400

How will be the metadata be brought in to the Denodo from source system? Esp the semantic information.

Answers: 1