Q&A

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

Timeout while waiting for an object
answered 04-02-2020 02:21:32 -0500

Hi, What is the reason for this error? It is checking for a flat file (and the file was available). The file is not huge at all. Thanks. Error executing query. Total time 74.772 seconds. Incomplete results Incomplete results Incomplete results I...

Answers: 1

timeout

is it required to apply latest patch on denodo monitor server
answered 03-02-2020 07:28:28 -0500

Hi Team, We have apllied latest denodo server patch update with 20190903,we need to apply same patch on denodo monitor?,If yes can you please provide the steps to update our denodo server running on linux system

Answers: 1

Essbase single sign on
answered 03-02-2020 07:24:27 -0500

Is it possible to establish a singe sign on connection to essbase from denodo? If yes, do we have the documentation for it?

Answers: 1

hyperion essbase Single sign on