Home / Q&A / All Questions

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.

Problem with download zip file training on demand: DEN70EDUD01 Data Virtualization Developer (Introduction) - On-demand
answered 19-08-2019 04:16:05 -0400

Good morning, we are doing online training for developers 'DEN70EDUD01 Data Virtualization Developer (Introduction) - On-demand'. In particular the step 'DEN70EDUD1004LAB01 - Calculate the seniority of each employee using functions'. We can not downloa...

Answers: 6

Creating a view from a Denodo Stored Procedure
answered 19-08-2019 03:04:04 -0400

Hello, Is it possible to create a view using a Denodo Stored Procedure or incorporate a Denodo Stored Procedure in an existing view. I need to count the total number of rows in the output of a view and then take that total count and include it in that ...

Answers: 4

Stored Procedure

My base views are not appearing when I am searching my data catalog
answered 19-08-2019 01:32:29 -0400

Once I have syncronized my data with the Data Catalog from the VDP server, how to I get it to appear in search results? I have synched my data from the VDP and it is appearing in the Element Management page. When I search for the views in the catalogue...

Answers: 1

Base view synchonization

Denodo data catalog: query across mutliple views
answered 16-08-2019 08:43:00 -0400

How can I define in the Denodo Data catalog a VQL query (join) across multiple views?

Answers: 3

Incremental Full Cache of Large Dataset
answered 16-08-2019 08:40:20 -0400

I have a use case to implement solution for one of my end user team to query large volume of transactional data on daily basis from production Data Ware House ( SQL Server 12 RDS). The end user wants to run their queries, but due to the complexity and ...

Answers: 3

Full Cache Incremental Cache Large Dataset

While opening a denodo view, it says 'View not editable'
answered 16-08-2019 08:21:14 -0400

Hi Team, I have created a data model in denodo, by replacing the SQL table names with the corresponding Denodo base view names and executing the SQL in VQL shell. This SQL contains few set of joins, aggregations and group by clause. Execution went well...

Answers: 1

Edit View

Database specific Roles
answered 16-08-2019 06:07:20 -0400

Hi, We have created a new Database = "ABC" similar to Admin and itpilot databses. Now I have created a new user and role , granted privilages to only the new database created - "ABC". But still the new user which is created is able to access abd view ...

Answers: 1

#RoleMaintenance #Roles

Power BI Report Server
answered 16-08-2019 06:00:27 -0400

Hi, after publishing the report using (May 2019 PBI RS) from report server ( May 2019) this error is what i got. An unexpected error occurred An unexpected error occurred. Please try again later. Please try again later or contact support. If you cont...

Answers: 1

#powerBI connection #Denodo-PowerBI #reportserver

Content search radio button is not enabled
answered 16-08-2019 05:03:44 -0400

We have created indexes , configured them in Scheduler and executed the jobs for these Indexes. Further added "Content Search" configurations of data catalog, still the content search radio buttons are not yet enabled in Data Catalog UI. Is there a...

Answers: 2

#contentsearch

SAP Idocs with Denodo
answered 14-08-2019 08:24:51 -0400

hi all, we are connecting Denodo with several SAP systems, receiving master data and transactional data. most of the connections use SAP IDOCs, and as Denodo does not handle IDOCs we have Tibco in the middle as passthrought, converting IDOCs into XML t...

Answers: 1

SAP XML Idocs