Q&A

Error while testing the SSL connection using Keystore
answered 28-02-2020 07:56:46 -0500

Hi, I am trying to test and HTTPS request throught SSL certificate. I tried generating a certificate following below link https://community.denodo.com/docs/html/browse/6.0/platform/installation/postinstallation_tasks/enable_ssl_connections_in_the_deno...

Answers: 1

Text to Date field conversion
answered 27-02-2020 21:31:33 -0500

Hi Team, Using Denodo 7.0 version. I have date field in format 'MM/dd/yyyy' in my source which is in text datatype. I need to project the same in same format('MM/dd/yyyy') but in date datatype. When i use CAST, to_date ,to_localdate ....., format is ...

Answers: 1

Date Conversion Date

Unable to create TFS environment
answered 27-02-2020 13:55:51 -0500

I'm trying to integrate denodo with TFS in version 6.0. Whenever i try to create environment I'm getting this error: Error creating environment: error creating environment: Unexpected URL format: 'http://team/tfs/****/folder/environments/development.p...

Answers: 1

TFS

Context clause wiped out by VDP....
answered 27-02-2020 07:29:05 -0500

I created a new derived view from a base view and provided the context for 'queryTimeout' setting e.g. SELECT ... FROM ... CONTEXT ('queryTimeout' = '9000000') However, VDP keeps replacing it with SELECT ... FROM ... CONTEXT ('formatted' = 'yes') ...

Answers: 1

Denodo7 hibernate jar not found
answered 27-02-2020 07:25:11 -0500

As per Denodo documentation Hibernate jar is available under /dist folder in the installation directory. But we couldn't found the folder /dist in our Denodo7 installation directory. Requesting your support on this issue

Answers: 1

Hibernate Denodo Jar

LISTAGG QUERY SAMPLE
answered 27-02-2020 07:23:54 -0500

Hi, please provide a query sample example to show the function listagg. Currently i am not able to produce syntactically correct query even though i follow the syntax. Also please do not provide the listagg function link in ur community as i already...

Answers: 1

listagg

Scheduling job to load data for all the month-end dates in the caching database.
answered 26-02-2020 07:47:06 -0500

Hi, We have created multiple final views with mandatory parameter 'as_of_dt' for each view. Now, we want to schedule job to load all month end data in cache.( all month end dates for future and past- not any single month end date ) I was planning to ...

Answers: 1

Denodo 7.0 Denodo Scheduler 7.0

VDP SSL connection with Talend
answered 26-02-2020 07:39:43 -0500

Hi Team, We are trying to extract the data from denodo views using Talend. While we are creating the a connection in Talend , we are getting the below error. Our VDP server is SSL enabled. We are able to connect from my machine and machine is enable wi...

Answers: 1

Talend

MongoDB vs JSON
answered 26-02-2020 07:37:35 -0500

Hello, Here is the context for my question. It is an architecture question. We have centralized our data sources in Denodo. Now, this data must be consumed by a system that has a back-end on MongoDB. I would like a billateral communication. The linea...

Answers: 1

Connector JSON API mongodb

Parameterised Query
answered 26-02-2020 03:40:42 -0500

Hello, I came across one issue. Actually, i am creating view through SQL query. In my SQL query there is IN condition in where clause and the array of string values are used in IN condition. The values i am passing through GET request when i am callin...

Answers: 3

Paramaterised Query In Clause