Q&A

You must sign in to ask a question. If you do not have an account, you can register here

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in April 2018.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community

Issue with LANG_CD='EN' condition
answered 06-02-2018 07:42:21 -0500

We have some oracle tables with column named ‘LANG_CD’.If we apply where clause “LANG_CD= EN”, on any of these tables, our results are weird. For example, T1 has LANG_CD column. It has 5 records with lang_cd as ‘EN” and 10 records with lang_cd as ‘SP’...

Answers: 1

LANG_CD

Installation on Centos
answered 06-02-2018 07:17:12 -0500

Hi, I have installed Denodo on Centos and kept url on web ( xx.xx.xx.xx:9090), not able to get Denodo platform. Firewall is disabled. selinux is disabled. What would be the problem?. Regards, Munichandra.

Answers: 1

Denodo as a source for DOMO BI
answered 06-02-2018 07:16:38 -0500

We are planning to use denodo server as a datasource for DOMO BI tool. Thank you

Answers: 1

scheduling a job for Caching the data base
answered 06-02-2018 07:05:56 -0500

Hi Team, I have created a data source for cache and i would like to create job for caching it. Can you please hellp in how does this job work if i schedule it and how to create a job for refreshing the cache data source. Thanks, Sagar.

Answers: 1

Unstructured Text File
answered 05-02-2018 12:51:22 -0500

I have a unstructured text file like below. Any suggest to map to denodo as data source and display as table format with AcctNum, Data TransAmt, TransDesc Acct Date Trans Trans Num Amt Desc A001 4/1/17 23.23 Decs 1 4/2/17 34.34 Desc 1 4/3/17 34.45 Desc...

Answers: 1

Unstructure Data Source

Having an issue with the MIN function for Date data types
answered 05-02-2018 12:43:07 -0500

I am getting the wrong value in the result-set when when querying a Date value. The incoming data type listed in the Base View is "date" (the Base view matches the data source tables exactly). I use the MIN function in a grop-by query: select MIN(<...

Answers: 1

MIN function Date

connection error.cannot trust in the server to establish a ssl connection
answered 05-02-2018 07:59:33 -0500

Hi Team, Iam facing this issue when trying to log in to VDP admin tool after installing self signed certs . can you please hellp in solving this issue and guide me do i n eed to do any chnages other then what i have done. changes made Changes Made: ...

Answers: 1

connection error.cannot trust in the server to establish a ssl connection when connecting to VDP admin tool after installing certs
answered 05-02-2018 07:56:40 -0500

Hi Team, Iam facing this issue when trying to log in to VDP admin tool after installing self signed certs . can you please hellp in solving this issue and guide me do i n eed to do any chnages other then what i have done. changes made Changes Made: ...

Answers: 1

Use denodo to update the source data?
answered 05-02-2018 07:50:49 -0500

Just out of curiosity I wanted to know whether denodo has any option to update the source table data using the data in derived views?

Answers: 1

Data Source

Denodo connect to SQL server -- cannot log in
answered 05-02-2018 07:28:25 -0500

I am using JTDS SQL server 2012 driver, jdbc:jtds:sqlserver://server:port/database; useNTLMv2=true; domain=domainname after I input login and password, I got error message " Unable to estable connection: Login Failed for user xxxx". then I went to VP...

Answers: 1

SQL Server