Latest Activity

code

Data movement for same source

Need to re-factor complex SQL code in Denodo layer. Query is not getting executed in the source(Snowflake) layer after re-factoring it. It is failing with compilation error due to memory/warehouse limitation set at source layer. Can I temporarily stor...

code

Problem with types in denodo

Hi, I imported a collection from mongodb. The collection is a json with different subfileds of type object and array. In denodo, some subfileds of type array are correctly identified as "array" and other subfileds are identified as "text" instead of "a...

code

Denodo Model Bridge Enterprise Architect (Sparx) support

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 ...

code

Adding prefix to a register subfields

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...

code

List of Datasource

Hi team, I have to list out all the Data Sources which are present in my Design Studio. Along with name , I need other detzails as well like connection string username etc. Can you please tell me how to get this list. Is there any table or procedure ...

code

Timezone in solution manager

Hello All , Please i want to know how can change Timezone in solution manager ? Thanks for your time

code

denodo training

in my training section under the courses there is " access expires in 8 days " does that mean i cant watch the videos of the course after 8 days ?

code

python connect to denodo by using PSYCOPG2

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.

code

Invalid Views list.

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...

code

time dimension table

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 ?