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

Custom Stored Procedure with default parameter
answered 01-08-2018 15:49:02 -0400

Hi, in java we created a custom stored procedure having a few input parameters. new StoredProcedureParameter("input_database_name", Types.VARCHAR, StoredProcedureParameter.DIRECTION_IN), new StoredProcedureParameter("input_view_name", Types.V...

Answers: 1

Denodo stored procedure custom Parameter

Using Denodo Views in SAS Enterprise Guide
answered 01-08-2018 12:44:54 -0400

Denodo platform 6.0 Good morning, I'm wondering if there's any documentation around best practices when querying Denodo views from a BI tool, specificallySAS Enterprise Guide. The main use case we're wondering about is joining a SAS data set to a Den...

Answers: 4

SAS QueryOptimization

Consuming a rest service hosted on Apigee
answered 01-08-2018 12:08:48 -0400

Hello, I have a rest service secured by oauth2 on Apigee. I want to use this rest service as a JSON datasource. The request for an access token requires a post body. The OAuth wizard provides no option to add a post body. Is there any way I can achieve...

Answers: 1

REST API oauth

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