Q&A

Invalid Views list.
answered 27-01-2023 15:14:22 -0500

Hi team , I am using Denodo 8.0 Verssion. Please let me know how do I bring list of All Invalid Views and associations ( including Base , Integration , Derived , staging , Business views ) in tabular format. I tried to execute desc database <databa...

Answers: 1

Views

python connect to denodo by using PSYCOPG2
asked 27-01-2023 10:11:14 -0500

I am getting below error port 9999 failed: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request.

Answers: 0

Denodo Model Bridge Enterprise Architect (Sparx) support
asked 27-01-2023 02:26:58 -0500

Hello, According to Denodo Model Bridge manual (https://community.denodo.com/docs/html/document/denodoconnects/8.0/en/Denodo%20Model%20Bridge%20-%20User%20Manual), a few data modelling tools such as ER Studio, ERWin files are supported to import data ...

Answers: 0

Denodo Model Bridge SparxSystems DataModel Model Bridge EnterpriseArchitect

time dimension table
answered 26-01-2023 21:10:03 -0500

my fact table contain two field of time one for the creation and the other for the shiping how i can create the time dimension tible in denodo ?

Answers: 1

denodo training

in denodo scheduler the cache jobs are stuck running state
answered 26-01-2023 18:15:06 -0500

in denodo scheduler the cache jobs are stuck running state

Answers: 1

Cache

One of our View is running longer.
answered 26-01-2023 18:05:12 -0500

Hi, One of our query is running longer. Scenario-1: We have created one view to get some columns( using case statements) and used 4 to 5 sub queries and joined them individually with main table. Scenario-2: We have modified the Scenario-1 query like m...

Answers: 1

longrunningquerry Base View configuration

Query a field in a register in denodo
answered 26-01-2023 15:58:03 -0500

Hi, Can we query a subfield from a register in vql shell without knowing the exact path of the subfield. is there a query like : select [subfield name] from xxview. So if the subfield is under register1.register2..registerN, we dont have to specify th...

Answers: 1

vql register

List of All DataSource
answered 26-01-2023 06:50:38 -0500

Hi team, I am using Denodo 8.0 version where I want to see details of all the DataSource created in my server.For which I tried this option 'DESC DATASOURCE <datasource_type> <datasource_name>‘, but in this I have to give one datasource na...

Answers: 2

DataSource

Adding prefix to a register subfields
answered 26-01-2023 05:01:40 -0500

Hello, I want to add a prefix to all register subfields. In my case I have a register of registers. For each subfield of the register i want to add a specific prefix depending on the position of the register in my schema. For example, I have a registe...

Answers: 2

prefix register

Transient "Insufficient privileges" error when connecting through ODBC using an AD user
answered 26-01-2023 02:36:13 -0500

Hi, We have an AD group (imported as Role in Denodo) with Admin privileges over a VDB. When we try to connect to that Denodo VDB through ODBC using an AD account associated to that group, sometimes we get a successful connection and some other times w...

Answers: 1

LDAP Connection with ODBC