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.

Can I store Denodo Metadata information in my own SQL Server database ?
answered 24-01-2020 19:38:30 -0500

Team, Can I store Denodo Metadata information in my own SQL Server database rather than default Apache Derby database ? If Yes, what is the process to do the same. We use Denodo Version 7. Thank you, Dilip

Answers: 1

Metadata

Can I store Denodo Metadata information in my own SQL Server ?
answered 24-01-2020 17:52:33 -0500

Team, Can I store Denodo Metadata information in my own SQL Server database rather than default Apache Derby database ? If Yes, what is the process to do the same. We use Denodo Version 7. Thank you, Dilip

Answers: 1

Metadata

DATE fields being converted to TIMESTAMP in Denodo.
answered 24-01-2020 15:28:35 -0500

While creating base views from data source (oracle), denodo converts all DATE fields to TIMESTAMP. When we try to access these date fields from any JDBC client in our case 'DBeaver' we get these fields as TIMESTAMP and not 'DATE' fields. Is there a way...

Answers: 2

Date Conversion Denodo 7.0 Data Type Conversion

Tableau Server Version: 2019.2.2 can't connect to Denodo V7 using SSL
answered 24-01-2020 13:18:35 -0500

Hi, We can't seem to figure out what is causing Tableau Server to be unable to connect to Denodo V7 when the latter is in SSL. Anybody got a similar issue?

Answers: 1
Related to: How to connect to Denodo from Tableau Desktop

ODBC Tableau DENODO Tableau SSL pass-through

DATE / TIMESTAMP fields are not reflecting the i18n mapping change.
asked 24-01-2020 10:39:39 -0500

When applying custom i18n mapping to existing views and setting the custom i18n mapping as default we made these changes: To create custom I18N mapping CREATE MAP I18N i18n_us_est_custom ( 'country' = 'US' 'datepattern' = 'MM/dd/yyyy' 'datesubtypepa...

Answers: 0

Date Conversion Denodo 7.0 i18n

How to install Denodo Express on Mac with Catalina
asked 24-01-2020 07:50:40 -0500

Hello I am trying to install Denodo Express on my Mac with OS Catalina. I downloaded the generic package, set my JAVAHOME variable and try to run the install.sh script. This always returns the error readlink: illegal option -- f usage: readlink [-n...

Answers: 0

Return Data for the past 6 months
answered 24-01-2020 07:32:35 -0500

Hi. I'd like to query the Denodo view via a querying tool (i.e. WinQSL) for the data from the last 6 months. I have tried the following, but I can't seem to get the Denodo syntax correct. select * from denodo_view where transaction_date >= getdate...

Answers: 1

Date Conversion Dynamic Dates Dates Date

How to ignore view from VCS synchronization (git)
asked 24-01-2020 05:20:12 -0500

Hello team, I managed to implement dynamic base view in Denodo: In a Denodo custom stored procedure I call an Oracle Stored procedure which create a dynamic Oracle view (view definition is unknown upfront). Then I create the base view (from my Denodo ...

Answers: 0

GIT VCS

Error accessing the metadata while loading/storing objects
answered 24-01-2020 04:22:34 -0500

I have created a job in the scheduler for loading the oracle transcodification tables and while executing I am getting error as "Error accessing the metadata while loading/storing objects". Please help on this.

Answers: 2

Appending Views
asked 24-01-2020 04:08:17 -0500

Hi I need to append views on my VDP, can we do that? Also, I have already created format views so I need to update the datasource first and then base view and then format view

Answers: 0

DataSource