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.

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

ServiceAccount as a Data Base Login account ?
answered 24-01-2020 03:18:45 -0500

Can I use the same ServiceAccount which has used to install as a Data Base Login ? In that case, what kind of access Service Account needed to connect to Data Base ?

Answers: 1

#LDAP-ServiceAccounts

unavailability of shared cache during deployments in mult-node architecture
asked 24-01-2020 01:13:58 -0500

we have a single cache DB ( shared cache) for multiple Prodution denodo nodes. but problem with this architecture is when we do deployment of views having cache associated with it on any of nodes . this makes the cache unavailable/invalid for other nod...

Answers: 0

shared cache Zero downtime deployment Cache

Error while creating Base View with Delimited Files
answered 23-01-2020 19:44:41 -0500

I'm trying to create a Base View with the information detailed in DEN60EDU0112LAB01 and everything works fine until I select the Create Base View, it gives me an error: "There was an error while creating this base view: Column names could not be genera...

Answers: 10

Delimited Files

Type of model in the join
answered 23-01-2020 17:01:27 -0500

The Denodo tool has the join function that allows you to join or integrate data from different sources, however, this works by means of PK (primary key) or FK (foreign keys), I would like to know what models are formed. In other words, it is a star mo...

Answers: 2

DATE fields being converted to TIMESTAMP in Denodo.
asked 23-01-2020 13:50:00 -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: 0

Date Conversion Denodo 7.0 Data Type Conversion

Why do JDBC escape sequences give an error with the Denodo JDBC driver?
answered 23-01-2020 13:07:55 -0500

We are using SAP Business Objects Xi 4.2 to consume data from Denodo 7.0 using the Denodo JDBC driver. However queries generated by Business Objects that use a filter on a date object return an error. The SQL is generated with the following syntax in ...

Answers: 1

Return Data for the past 6 months
asked 23-01-2020 11:12:17 -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: 0

Date Conversion Dynamic Dates Dates Date