Q&A

LDAP Authentication through multiple domains
answered 14-06-2019 12:38:03 -0400

We have a requirement where multiple LDAP data source need to be accessed. currently it is based on one data source.

Answers: 1

#LDAP

Date Temporary Table
answered 14-06-2019 12:16:20 -0400

Hello All, I am trying to create a temporary table with two years worth of dates. Is this possible in VQL? I looked through the documentation and it doesn't look like we can call any looping functions. Similar procedure in MS SQL: https://stackoverf...

Answers: 1

Function Temp Tables

Start with denodo express
answered 14-06-2019 11:01:12 -0400

I can access to the administration tool i try to access with my email and password but i can't Please help me to strat working with this tool

Answers: 1

Denodo Express

Download and Install Denodo Platform 7.0 in Max
answered 14-06-2019 08:53:11 -0400

I need assistance in finding a right driver t install in my mac

Answers: 1

Download and Install Denodo Platform 7.0
answered 14-06-2019 08:31:47 -0400

I need assiastance in finding a right denodo jar or tool, to install in my mac

Answers: 1

Metadata proc - datasource for a base view
answered 14-06-2019 04:07:08 -0400

Is there a predefined stored proc where I can see the details of the datasource for a base view? I've been looking through https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_stored_proce...

Answers: 3

Metadata

Getting SSL I/O errors while loading data from Denodo views using Informatica sessions
answered 14-06-2019 02:16:17 -0400

I am getting few SSL I/O errors in the Informatica session when I try to load data from Denodo view. The issue seems to go away when I try restart the failed session, but seeing this issue quite often. Do I need to make any configuration changes on De...

Answers: 3

SSL I/O error PostgreSQL Informatica

VQL equivalent for T-SQL "WITH (NOLOCK)"
answered 13-06-2019 21:26:31 -0400

Our DBA claims that the Denodo view is causing DEADLOCKs on the SQL Server. They recommended us to pass the query to SQL Server with the "WITH (NOLOCK)" option. Is this possible with Denodo views? If yes, please provide specific example. Btw, the SQL...

Answers: 1

sql server deadlock nolock deadlock read uncommitted sql server

My Vdp cache Job which runs for every one hour is entering in to long running state some time and stopping with error ,when i restart it is running fine ?
answered 13-06-2019 21:26:04 -0400

My Vdp cache Job which runs for every one hour is entering in to long running state some time and stopping with error ,when i restart the job it is running fine,i am getting the below error Error executing query. Total time 62058.195 seconds. Incompl...

Answers: 1

How to get list of views with statistics enabled
answered 13-06-2019 20:19:58 -0400

How can I get a list of views where statistics has been enabled for a given database?

Answers: 1

views with statistics view properties properties statistics