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.

Unable to access Docker Image for Denodo Express 7 latest
answered 09-10-2019 06:39:35 -0400

Hi, can you point to how we can pull docker image for denodo express or download it ? Though I am logged in, the portal says unauthorized https://support.denodo.com/resources/installer/list/Denodo%207.0

Answers: 1

How to Convert datatype from Text to Date?
answered 08-10-2019 21:18:06 -0400

HI Team, My base view has a date field which is in datatype text ( Varchar-50) and giving value '20190910172316' . I tried to convert the same to date by using " to_date('yyyyMMddhhmmss' , base_view.eff_dt ) as eff_dt " in derived view layer. it worke...

Answers: 1

Date Conversion

No array data from tutorial web service
answered 08-10-2019 10:34:57 -0400

Hi I am following the online tutorial and when executing a query on the web service on 'C003' I get an array come back however there is no data in the array. According to the online tutorial I should be seeing 2 records in the array. Any tips on how I...

Answers: 3

Is there a way to create the Base Views directly from erwin files or erwin xml files instead of creating the base views individually
answered 04-10-2019 07:40:18 -0400

Is there a way to create the Base Views directly from erwin files or erwin xml files instead of creating the base views individually. We generally create base views connecting to a database where the datamodel of EDW is sitting, but is there a way to c...

Answers: 3

#erwin #datamodel

i18n View Locale
answered 04-10-2019 06:50:07 -0400

Is there something we can run to pull out the base views which have a different map from the default for both the searchmethod and the view, itself?

Answers: 1

query to get i18n type

Denodo alternative for TSQL "STUFF.... FOR XML PATH"
answered 04-10-2019 02:35:33 -0400

Hi, I have a table with multiple rows and a single column called ID - it is aways 5 chars long ID 12345 23456 34567 I want to create a view with a single column output and a single row output that will concatentate all the values inserting a com...

Answers: 2

ARRAY

Denodo Architecture for Developer and Administrato
answered 03-10-2019 07:24:19 -0400

Hi, I just downloaded Denodo Express and started importing some sources. I was wondering how I shoould be using Denodo in my Company, for example, is it right to install denodo in a server and then let the developer connect to this server using their...

Answers: 1

Access Denodo Express Administration Tool

Denodo Data Catalog tutorials
answered 03-10-2019 07:01:09 -0400

Hi Team, Can anyone suggest me some links to understand denodo data catalog better? I had a good read about it few weeks before, but am not able to find the content now, when I searched Thanks for your help, Manju

Answers: 1

#data catalog

Denodo 7 data catalog: share (explore) queries
answered 02-10-2019 14:06:24 -0400

Hello, For the Denodo catalog, what is the recommended way for a user to share a query, is it possible via the web interface? to other data catalog users? can it be shared so that other catalog users can see updates after obtaining access to the s...

Answers: 1

Delimited file sources- rows to columns
answered 02-10-2019 09:51:06 -0400

Hi, I'm having an issue with a delimited file source. The file is actually a column from a big query wich contains a CLOB, that clob has the next format : parameter1:value1;parameter2:value2;parameter[n]:value[n]; ........ What i want is to convert ...

Answers: 2

delimited file sources rows columns pattern tupple