Q&A

You must sign in to ask a question. If you do not have an account, you can register here

Specifying a timezone on a 'timestamp without timezone' value
answered 24-07-2020 17:15:07 -0400

I'm curious of the best way to convert a 'timestamp' (without timezone) to a timestamptz (with timezone) value in Denodo when your original timestamp value is in a timezone other than UTC? I am currently using 'CAST([TimestampColumnHere] AS TIMESTAMPTZ...

Answers: 2

After installing Solution Manager, how I can find again my database ?
answered 24-07-2020 17:13:20 -0400

​ We have a DENODO 7.0 installation, with some connectors and SQL requests, following a POC project. ​ After I have installed Solution Manager, in VDP, we have only ADMIN database. This database is empty, and we have lose an another database, named POC...

Answers: 2

SolutionManager solution manager

Solution Manager REST API port
answered 23-07-2020 17:49:29 -0400

Hi Team - what port number should i use while invoking Solution Manager REST APIs ? should it be 19090 (web container port) or 10090 or some other port ? http://<hostname>:<port>/environments - is this the correct URI to call REST API (jus...

Answers: 1

Solution Manager API

Getting Connection Timed out
answered 23-07-2020 16:10:04 -0400

Hi Iam not able to connect to denodo. I used login and password as : admin But Iam getting : Connection Error:Connection timed out

Answers: 1

Connection issue to VDP

Is it possible to build a API Graph on Denodo?
answered 23-07-2020 08:28:46 -0400

In technical terms, we need to build an API Graph application with 2 actions: Get token via user/password Once we have token, consume API. Do you know how to develop this requirement?

Answers: 1

#API #Rest_API

Denovo VM on CentOS - How to Call Application?
answered 23-07-2020 08:07:02 -0400

Just installed last Denovo (22/07/2020) virtual box package and did all the configuration specs even the "hosts" configuration on Windows system32 folder. Don't know how to launch denodo application within centOS black page.

Answers: 1

vm

CREATE BASE VIEW USING IINTERPOLATION VALUE
answered 23-07-2020 06:51:38 -0400

I am trying to create base view using 'create from query', select * from table1 where id=@id1 @id1 = 34This works super it creates base view and also BV executes... select from table1 where name=@name1 @name1='veeresh' This creates base view. But whe...

Answers: 3

Specifying a timezone on a 'timestamp without timezone' value
answered 23-07-2020 05:55:32 -0400

I'm curious of the best way to convert a 'timestamp' (without timezone) to a timestamptz (with timezone) value in Denodo when your original timestamp value is in a timezone other than UTC? I am currently using 'CAST([TimestampColumnHere] AS TIMESTAMPTZ...

Answers: 1

Virtualization of my data warehouse snowflake
answered 23-07-2020 05:35:17 -0400

Hi, I created a unified view of my datasource of snowflake. When i make an update in my table on snowflake, i saw that the change is made also on my view on denodo. And i don't want the update appear in the view on denodo. Is it possible ? Thank you

Answers: 3

snowflake DENODO

access column values in register
answered 23-07-2020 00:25:01 -0400

How to access register nested columns(eg. id) through vql eg. view openstacktoken column:- token : register { id: string, name : string } I want to do Select id from openstacktoken. Presently, when I am querying openstacktoken, I am getting token as ...

Answers: 4