Home / Q&A / All Questions

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

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.

Odd Date Conversion
answered 01-08-2018 06:37:04 -0400

Hello, I’m looking to convert some odd date values to the equivalent format of Current_Date(). Like 2018-07-31 00:00:00. The date values I’m looking to convert are like such. 910101 is an example of the date value. This is equivalent to Jan 1, 1991. B...

Answers: 1

Date Conversion Date

How to connect to Azure SQL database for Denodo 7?
answered 01-08-2018 05:33:17 -0400

I'm new with Denodo 7. I'm not sure if I'm using correct driver. 1) I have downloaded http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=11774 I have Unzip the distribution file and copied sqljdbc_xx./enu/auth/x86|x64/sqljd...

Answers: 1

Not able to see Web Service
answered 31-07-2018 11:21:11 -0400

I promote a web service to another server. The users can execute the web service but not able to view it on the Admin Tool. They have read/write access to the database that the web service resides in, so they can see everthing but the web service. How ...

Answers: 1

Unable to view Assign Examples & Review Examples tab in IE
answered 31-07-2018 07:32:21 -0400

Hi Team Am using licensed version of Denodo VDP 6.0. I have issue's while working with ITPilot Wrapper generation tool. If i open the browser(IE) from Wrapper Generation tool am not getting the denodo tool bar options, but if i open the local IE brows...

Answers: 3

Wrapper ITPILOT

Trimming zero's for Number Data Type column
answered 31-07-2018 05:21:34 -0400

Hi Team, Suppose in a DB Table : emp where we have a coulmn with emp_no which is of number data type and have a value as "0123" , so when I import this table to denodo and query in denodo base view where emp_no=123 I am getting output and also output ...

Answers: 1

How to make Express license working? - Data Port Server not available
answered 31-07-2018 04:31:47 -0400

I'm trying to evaluate Denodo with free express license in Windows Server 2016. As I have no license file, Virtual Data Port Server is not available at Denodo Platform Control Center. It also fails to login to Data Port Administration Tools likely beca...

Answers: 1

Nested Array
answered 30-07-2018 12:49:24 -0400

Hi, I was wondering what would be the best way to create ARRAY inside an ARRAY, especially when you have huge data source(8M records)? I achived it using derived views but because of the data, when I create the 2nd ARRAY with ARRAY( from the derived v...

Answers: 1

Nested Array

Denodo 7.0 instillation issue on Linux Server
answered 30-07-2018 09:15:35 -0400

Hi Team , I have installed denodo7.0 Lincece version on Linux by doing following steps : 1. cd denodo-install-7.0/ chmod +x installer_cli.sh ./installer_cli.sh install After that I provided DENODO_HOME Path and Path of Lincence File Here are s...

Answers: 6

Instllation

MS Access Data Source
answered 30-07-2018 08:57:47 -0400

Will Denodo 6.0 support MS Access data source using JRE 1.8? Will Denodo 7.0 support MS Access data source using JRE 1.8?

Answers: 1

MS Access

Denodo webservice XSLT change response body content type
answered 30-07-2018 03:44:49 -0400

When using an XSLT to convert XML to another format e.g. TXT, CSV or HTML, how to set the content type for xml to text/... instead of application/xml?

Answers: 1