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

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

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

Denodo cache Refresh using Tidal Scheduler
answered 05-02-2018 07:23:42 -0500

Hi, Version - Denodo 6.0 We have applied FULL Cache on most of our views and we need to refresh cache on a daily basis but, we dont want to use Cache Scheduler. We plan to use Tidal scheduler which is the enterprise scheduler at our client site for al...

Answers: 1

Denodo Tidal Scheduling

UID AND PWD
answered 05-02-2018 03:21:20 -0500

what is the username and password for logic to Denodo after installation with licence.

Answers: 1

SENT1

How can I import the SAS7BDAT file into Denodo with Metadata?
answered 02-02-2018 19:23:08 -0500

I would like to import the SAS7BDAT file to Denodo with Metadata. How can I do that? The metadata will go in the "Column Description".

Answers: 1

import SAS Metadata