Q&A

Problem with Denodo - Tableau Connection
answered 31-10-2019 01:39:28 -0400

I have some problems in the connection between Denodo and Tableau. I guess I had correctly succeded in the connection... ..., but Tableau seems that can not see the base view of my Denodo’s DB (Tableau) P.s. When I run the initial sql select * from ...

Answers: 4

ODBC Tableau scai finance

Accessing Denodo Views from external REST service
answered 30-10-2019 23:35:41 -0400

Hi Team, We are working on Denodo VDP 7 platform. In a specific use case, a consuming on prem application is using their custom coded REST service (which was built using .Net) to search data from a backend on-premise SQL server database. So when a fro...

Answers: 1

Third party VDP views

Manage users & roles per environment (via Solution manager)
answered 29-10-2019 08:30:02 -0400

Hello, What is the recommended way to manage users & roles per environment in Denodo 7? We get a lot of manual errors by adding them to separate nodes in a clustered environment. We found that the solution manager is good to move items across en...

Answers: 1

Denodo Data Catalog option to configure internal database missing
answered 29-10-2019 07:15:44 -0400

I have Denodo installed on my local machine and a remote machine, and I am trying to configure the one on the remote machine so that I can hookup my own database to store the metadata. I found the way to do it, but that way is for some reason only avai...

Answers: 1

data catalog

PowerBI online request with the credential of the PowerBI user
answered 28-10-2019 11:22:20 -0400

Hello, I'm trying to setup a PowerBI online (powerbi.com) report that propagate to Denodo the credential (Kerberos) of the user in PowerBI online down to Denodo (in direct query mode of course), and through the PowerBI gateway. I'm currently able to ...

Answers: 2

#powerBI connection #Denodo-PowerBI

Where can I access the Update files for download to Denodo 7.0 Express?
answered 28-10-2019 08:04:56 -0400

I've installed Dendo 7 express but I now need to update to 201903122200.

Answers: 1

patch upgrade Access Denodo Express

Extracting string between two identical charecters
answered 28-10-2019 06:55:37 -0400

Hi Team, I have a field which have sample data like /abc/data/source/AYZ/SrcFile/XYZ_ABC_1023456789^900061767ABC00100002^ABC_2019-10-15_00.00.51.62 I want to extract two id's 1023456789 and 900061767ABC00100002 ( which is between two chars '^' ) fro...

Answers: 1

substring

get USER-ID into Base view query.
answered 28-10-2019 03:17:50 -0400

Hi, I have implemented a function in DB2 which would take Denodo User-ID as one of the parameter. I have created a base view using DB2 function as shown below. CREATE OR REPLACE WRAPPER JDBC bv_consumer FOLDER = '/01 - data sources' DATASOURCENAME=d...

Answers: 4

user

why the SQL's execution time is slower in Denodo than the time in Oracle？
answered 24-10-2019 22:00:37 -0400

Hi support team, We have a VQL which execution time is more than 10 seconds in VQL shell, while it's generated native SQL can be run in Oracle client in only 3 to 4 seconds. In VQL shell, the "Execution Trace" shows "Virtual Plan" takes more than 1...

Answers: 1

Configuring internal database leads to login error
answered 24-10-2019 08:27:17 -0400

When I try to configure the internal database for Denodo in the Data Catalog, every time I restart the Data Catalog there is a login error that comes up saying " unknown column 'search_description' in 'field_list' ". I am using mysql5, have put the jdb...

Answers: 1

Denodo Internal Database Configuration data catalog