Q&A

Parameter push-down issue
answered 05-02-2020 06:35:16 -0500

I am facing an issue when using the parameter in where condition of the top-level views. The query is hierarchical and has five levels. I created a parameter for the top-level view for a key element "key_id" that is used to join several tables. Then...

Answers: 2

View Parameter entry parameter views branches

Granting access to virtual database without access to VDP
answered 05-02-2020 05:52:27 -0500

Hi, I would like to know if it is possible to grant read access to a virtual database to an user without granting him access to the Virtual Dataport administration tool? i.e. the user can execute view from a client tool as Excel, but cannot directly ...

Answers: 1

privileges Access and Role

GraphQL with Denodo
answered 05-02-2020 01:38:05 -0500

From where can i get this jar excutable file:- denodo-graphql-service-<version>-jar

Answers: 2

Denodo;GraphQL

TIMESTAMPDIFF
answered 05-02-2020 00:33:32 -0500

Team, How can we convert TIMESTAMPDIFF function. Eg:- TIMESTAMPDIFF(SQL_TSI_DAY, Date1,Date2) Can you please let me know in case of any idea on this ?

Answers: 3

LIST_JDBC_DATASOURCE_TABLES - 'Error getting tables and views.'
answered 04-02-2020 20:18:53 -0500

Hello, I am attempting to perform some management/automation on Denodo and calling LIST_JDBC_DATASOURCE_TABLES on an mssql datasource and it is failing with 'Error getting tables and views' after getting through 971 rows of tempdb, and no other databas...

Answers: 4

List Procedure Jar Dependencies
answered 04-02-2020 09:08:35 -0500

Hi I am looking for denodo metadata views which can give relationship of user defiened stored procedures and Jars with version. I have used the "LIST JARS" catalog function. This function returns the JAR name and stored procedure or functions of that ...

Answers: 1

metadata store Denodo stored procedure Stored Procedures

Which authentication method is recommended for authenticating against Active Directory? LDAP or Kerberos?
answered 04-02-2020 07:39:42 -0500

What is the intended use of kerberos authentication? Can / should it be used in place of LDAP authentication for user access? Thanks.

Answers: 1
Related to: Kerberos Authentication with the Active Directory

Denodo interpolation/parameter issue while using IN clause
answered 04-02-2020 07:07:55 -0500

Hi, I am facing an issue where using an interpolation variable in where condition of a dervied view. The views is something like this: CREATE OR REPLACE VIEW V1 AS SELECT Col1, Param1 FROM T1 WHERE Col2 = Param1 USING PARAMETERS (Param1 : text '12...

Answers: 1

Interpolation Variables param default value IN cl

No Download Tab on Support site
answered 04-02-2020 05:57:20 -0500

I do not see Download tab when I login with my id into Support. What are the steps to request full access ?

Answers: 1

download

Replicate data automatically
answered 04-02-2020 04:09:14 -0500

Good evening, once I have virtualized a database how can I do to export the data from the tables again. In other words, if I have loaded some tables in the Denodo, the transactional systems continue to fill my database (tables), as Denodo can be conf...

Answers: 3