Latest Activity

code

Connection error: Error getting the data to initialize the client

HI Team, I am getting below error while connecting to denodo which is in the local environment. Connection error: Error getting the data to initialize the client Please help me on this issue.

code

JSON headers

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

code

Unable to connect to Postgres server

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

code

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?

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

code

Request all the content of an external application

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

code

How to create base view using Design Studio

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

code

Constraints are not working with materialized table

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

code

Denodo text to date issues

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

code

Interpolation Variable using a formula - Julian calendar date

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

code

QUERY [JDBC WRAPPER] [ERROR] Received exception with message 'Error obtaining some values for column(s): 'full_path''

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