Q&A

JSON headers
answered 08-04-2022 05:57:58 -0400

Dynamic updates to HTTP header and body on the REST DataSource 1- We need to pass user details in request body in order to query the OpenStack through REST. This will return a token (that will be valid for short period only) that we have to use for fu...

Answers: 3

JSON headers

Unable to connect to Postgres server
answered 08-04-2022 05:26:34 -0400

Hi, Our team has been attempting to connect to our Postgres server on Denodo for awhile now, but it's still not budging at the moment. Our databases might be a bit more complicated in the sense that it needs to be accessed via a SSH tunnel. We've adju...

Answers: 1

PostgreSQL

How to do error handling on accessing data sources that we do not control + Different REST Web Service formats don't seem to return the same information?
answered 07-04-2022 08:37:10 -0400

Hello! There are two problems, that my team was wondering if there were answers to. The first problem: There are several data sources that we have no control over, and therefore can't tell if those services are live or not. My team was wondering how w...

Answers: 4

denodo platform XML Denodo Testing Tool REST Webservice json HTML Error Handling

Request all the content of an external application
answered 07-04-2022 08:32:17 -0400

Bonjour, Pour une application qui a besoin une fois par mois de l'ensemble des données d'un système source, et puis une fois par jour du detail des mises à jour comment faire ? Merci de votre retour

Answers: 3

How to create base view using Design Studio
answered 07-04-2022 07:56:11 -0400

Hi there, I have been taken over PIC of denodo but the predecessor left without doing anything. Currently, I need to add a base view to existing base views in Denodo in development environment. I can use Denodo Design Studio and I searched the way in...

Answers: 3

Constraints are not working with materialized table
answered 07-04-2022 07:32:13 -0400

I found something when I tried executing the materialized table. After I create a table with primary key constraint, If I insert a repeated value the server is accepting and inserting two rows with same value even if primary key is specified? Can anyon...

Answers: 1

#Denodo

Denodo text to date issues
answered 07-04-2022 07:19:55 -0400

I currently have a data set which has poor data quality where all dates are text fields. I have created an integration view which casts text to integers and uses tolocaldate funtion to convert text to local date format. The issue is that in the base ...

Answers: 1

Interpolation Variable using a formula - Julian calendar date
answered 06-04-2022 09:07:18 -0400

I have a data source which requres a dynanmic file name to be reference using a Julian date - last two digits of the year and the current day number. So 2022-04-04 would be 22094. Is there an easy way to include this value as part of the interpolatio...

Answers: 1

Formula Interpolation Variables Date time function

QUERY [JDBC WRAPPER] [ERROR] Received exception with message 'Error obtaining some values for column(s): 'full_path''
answered 06-04-2022 08:58:44 -0400

Hi, I have this script below but I received this error Seems to be an issue with group by because other scripts without the group by and same filters do work. (please also note this is sourced from db2 resevoir) Not sure because the consultants ensure...

Answers: 5

Error

Why does this solution work?
answered 06-04-2022 08:39:36 -0400

It would be good to know why this solution works and what does the command do. Also, could it have some unintended consequences?

Answers: 1
Related to: Error obtaining some values for column(s)