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.

Join view OR Operator
answered 04-03-2019 05:53:50 -0500

Hi How to use OR operator in join condition my query looks like this bv_1.id = bv_order.id AND (UPPER(bv_code.CODETYPE) = 'ADMINISTRATIVEGENDER' **OR** bv_ce.C_CODE IN('4','5')) ERROR what i am getting currently The join condition is not vali...

Answers: 3

can this be used for solution manager
answered 04-03-2019 04:44:40 -0500

can above funtion also be used for solution manager?

Answers: 1
Related to: Automating status check of Denodo services

Can Denodo integrate with SSIS packages?
answered 04-03-2019 04:42:01 -0500

We're a software company that is hosting a secure set of data for client in a private security group under RDS SQL instances. Many of our clients use MS SSIS to perform common queries. Is there a way to import SSIS packages to have Denodo supply the sa...

Answers: 1
Related to: How to access Denodo Virtual DataPort from Microsoft SQL Server Reporting Services

DENODO SSIS

Importing Users from a CSV.
answered 01-03-2019 08:35:13 -0500

Hi We have over 5000 users that access a Oracle Data warehouse directly. We can extract all these users into a csv file. Is it possible to import all these users into Denodo?

Answers: 1

How to pass multiple DB's to Procedure : CLEAN_CACHE_DATABASE
answered 01-03-2019 08:03:50 -0500

Hi Team, Currently I am passing a single database to the procedure : CLEAN_CACHE_DATABASE, to truncate the invalidated records within a Single DB. So there might be cases where few Project DB's/Application teams might don't know this. so as part of A...

Answers: 1

CLEAN_CACHE_DATABASE
answered 01-03-2019 07:58:35 -0500

Hi Team, I have a Full Cache Job in Denodo which invalidates existing records and loads the new data. But in this process am still having a invalid records present in the cache view table. My question here, is there a way in the same Job I can trunca...

Answers: 1

Connect to SAP HANA 2
answered 01-03-2019 03:37:33 -0500

How can I connect denodo to a SAP HANA 2 datasource?

Answers: 3

SAP HANA 2

View migration from Development to Testing environment
answered 01-03-2019 03:35:49 -0500

Hi Team, We have installed Denodo Platform 7 version, while migrating view from Development to Testing environment, i have generated .vql file and .properties files corresponding to that view in development environment. And while editing .properties ...

Answers: 1

VDP 7.0 Update issue
answered 28-02-2019 07:28:13 -0500

I'm trying to silently install Denodo VDP 7.0 update 201810112100 and am receiving errors or being prompted to continue the install. My goal is to get this to run silently through SCCM for distribution to our users. I was able to successfully package t...

Answers: 2

Is there a query to see role-to-role assignments?
answered 28-02-2019 06:34:23 -0500

Using Denodo 6.0, is there a query or service which can provide a list of roles and any roles granted to them? Obviously, the "Role Management" window has what I want ... and I want it in a way that external audit automation can pick it up. I have rev...

Answers: 2

roles Role and User Management