Q&A

Denodo Testing tool-1
answered 09-11-2020 07:25:05 -0500

Hello, I have one API which has authentication of OAuth. How can I test A API with authentication?

Answers: 1

Denodo Testing Tool

Unable to connect Excel 2016 to Denodo environments
answered 09-11-2020 05:52:43 -0500

Hi. I am unable to connect an Excel workbook to our Denodo environments via a ODBC connection. It's odd because this worked perfectly earlier this year (spring/summer). I don't know what changed. We did apply a patch and upgrade in late August. This is...

Answers: 1

Creating base view for REST API whose access token changes frequently
answered 09-11-2020 05:40:28 -0500

I have a REST API created whose access token changes every 2 hours. How do i create a base view on top of that. I want the access token to be automatically passed at the run time, whenever denodo queries the data source through base view. I followed ...

Answers: 1

Denodo Increamental Cache Load
answered 06-11-2020 09:07:54 -0500

I am using Denodo V7 and I have enabled full Cache on a view in Denodo. Now I am trying to set up an incremental Cache load for this view through the Denodo Scheduler. But I keep getting an error which goes like this 'Error executing query. Total tim...

Answers: 3

Denodo Incremental Cache

Post operation
answered 06-11-2020 07:33:16 -0500

Is it possible to push the derived view data into target systems using API post operation in denodo?

Answers: 1

post Json #API #Rest_API

How to convert rows to columns using SPLIT function/any generic function in Denodo
answered 06-11-2020 04:45:33 -0500

Hi Team, I need to know is there any generic function available in DENODO for SPLIT function which can be used for any of the views without depending on one single view/function. Example: In Oracle we do have below function which can be used in any o...

Answers: 1

#Denodo #Split #SQL #rowsToColumns

Unable to establish connection to local host
answered 05-11-2020 08:05:59 -0500

Name:jdbc_sql Database adapter: Microsoft SQL Server 2017 (MS Driver) I am using SQL Server 2019 Express Database url: jdbc:sqlserver://localhost;IntegratedSecurity=true;DatabaseName=incident Left all the others blank I get an error: Unable to establ...

Answers: 2
Related to: Accessing MS SQL Server using Windows Authentication

For base view vql, what does "ESCAPE" mean?
answered 05-11-2020 04:35:49 -0500

I just observer the vql of the base view (data source is Hadoop Dremio), for the columns whose sourcetypename='CHARACTER VARYING', some has the attribute "ESCAPE NOT SORTABLE" , some has the attribute "NOT SORTABLE", why for the same data type, they ha...

Answers: 4

base view vql ESCAPE

Denodo4E used for Denodo in AWS cloud
answered 04-11-2020 07:18:12 -0500

When using Denodo4E for custom wrapper development, it is required to specify Denodo Platform Home Directory. When the Denodo server instance is in AWS cloud not on a local machine, can I still use Denodo4E? If yes, how do I specify the Denodo Platform...

Answers: 1

Denodo4E

Pega connection
answered 03-11-2020 11:02:34 -0500

I'm using denodo 7 How Denodo can connect Pega as a datasource. If i need to consume Extracts from Pega, how denodo can handle it. Please help.

Answers: 1