Q&A

Is it possible to create a view from a dual table.
answered 14-12-2020 06:37:26 -0500

Is it possible to create a view from a dual table.

Answers: 1

DVCSPUSH only can be executed against the connected database
answered 14-12-2020 05:06:11 -0500

Hello. When automating database creation we seem to run into a syntax error or getting the above error 'DVCSPUSH only can be executed against the connected database' Running below script in VQL shell: ENTER SINGLE USER MODE; # +++++++++++++++++++++...

Answers: 3

dvcspush git vcs statements

Export denodo views to ADLS (AZURE DATA LAKE)
answered 14-12-2020 04:58:21 -0500

I am using denodo 7.0 in on-prem, i want to export a denodo views such as base view, derived view,etc as xlsx file, parquet, avro to azure blob storage in ADLS. Pls advice. thanks!

Answers: 3

Denodo on Azure BLOB azure blobl storage DENODO Export Azure Data Lake Storage Gen2

How to secure Denodo exposed REST API using the Http DIGEST method ?
answered 14-12-2020 04:18:15 -0500

how can i set Http DIGEST authentication scheme over a REST API ? i am using Denodo 7 and I see all other authentication options in the dropdown available in the EDIT tab of my web service. i am able to use http basic, basic with vdp, oauth, saml but n...

Answers: 1

Http digest

How Cognos report filters work
answered 13-12-2020 23:32:42 -0500

How does report filters work in Cognos reports that is connected to TerdaData thru Denodo. (Cognos<=>Denodo<=>TeraData) Can we pass the report selections from Cognos to Denodo and ultimately to TeraData so that the filters are applied at DB level? th...

Answers: 4
Related to: Connecting to VDP from Cognos

Cognos

store a value in stage variable
answered 11-12-2020 11:50:47 -0500

how to store a value in stage variable (at run time)?

Answers: 1

While loop in denodo
answered 11-12-2020 11:16:12 -0500

How to apply While loop in denodo?

Answers: 1

IGC API CALL
answered 11-12-2020 06:25:50 -0500

Hello, I want to retrieve a data from IBM IGC Api, I established a connection successfully but when I try to create a base view it gives me an error like "Unable to obtain the data structrure: com.denodo.util.exceptjection.InternalerrorException: Une...

Answers: 1

IGC

Solution Manager- Need binaries on trail
answered 10-12-2020 08:39:35 -0500

Hi I am interested to do POC how denodo works using solution manager,Is there any way I can install solution manager for trail purpose or can I get it from cloud marketplace for trail. Regards Gaurav

Answers: 1

Solution Manager License

Date format and Text to Date
answered 10-12-2020 07:57:00 -0500

Hi, I'm having one column named - EffectiveDate , which has field type as localdate. As denodo, by default shows date format in 'yyyymmdd', i'm using FORMATDATE('MM-dd-yyyy',EffectiveDate) command to change its format. Now, the field got changed into t...

Answers: 1

Date Conversion