Latest Activity

code

Check API data availaibility

Hi Team, Is there a way to check if the connection to the API is working or not? So that in case the API is not accessible we can set up alerts upfront and inform the users that data is not available because the API is down or with the detailed error ...

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