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.

Can I use Denodo to paginate through a REST API where the link to the next page is returned in the header?
answered 10-10-2019 08:27:43 -0400

I'm trying to use Denodo to pull data from the OKTA API. The data is coming back paginated. OKTA puts a link to the next page in the response headers: https://developer.okta.com/docs/reference/api-overview/#link-header Link header RFC: https://tools....

Answers: 1

rest api okta

incremental cache stored procedure finishing with error
answered 10-10-2019 08:21:35 -0400

incremental cache stored procedure finishing with "error getting rows to update in cache" . i followed the installation manual, where could i have gone wrong?

Answers: 1

Cache error

Datetime issue
answered 10-10-2019 07:43:52 -0400

Denodo custom Wrapper I am using below code, In the timestamp_field, timestamptz_field column is coming blank. @Override public CustomWrapperSchemaParameter[] getSchemaParameters( Map<String, String> inputValues) { return new CustomWrapperS...

Answers: 1

Denodo customWrapper Datetime field is not working in environment

LDAP authentication Error
answered 10-10-2019 07:14:19 -0400

Hi Team, I am trying connect the LDAP Microsoft ACtive Directory services to set up Single sign on. I am able to connect LDAP server by creating data source. I am created a base view with Objectclass->User->userprincipalname Got a error java.secu...

Answers: 1

LDAP

Denodo - Data Processing/Preparation, Python use cases
answered 09-10-2019 11:08:53 -0400

Hi, We are currently using Denodo mainly for reporting stuffs and predictive analytics. What we are curious about is related to how we should see the Denodo and when it's best case to use and i have few topics related to this: For example if i ha...

Answers: 1

denodo data processing preparation python use cases

Base view on a DB2 LUW Global Temp Table
answered 09-10-2019 08:42:52 -0400

I am trying to grab Denodo logged in user name and then inserting it into DB2 LUW "Declared Global Temp Table" for one of the application running on DB2 LUW. It seems it is only possible if the base view is created as regular view (Not created by query...

Answers: 5

DB2 LUW Global Temp Table

NULL values in query results
answered 09-10-2019 07:00:28 -0400

Hi support Team, what could be the reason that most values in the query results of my base view appers NULL ?? The base view is successfully created from a SQL SERVER but Iwhen executing I am getting NULL values (for different datatypes : text, int … ...

Answers: 6

Unable to access Docker Image for Denodo Express 7 latest
answered 09-10-2019 06:39:35 -0400

Hi, can you point to how we can pull docker image for denodo express or download it ? Though I am logged in, the portal says unauthorized https://support.denodo.com/resources/installer/list/Denodo%207.0

Answers: 1

How to Convert datatype from Text to Date?
answered 08-10-2019 21:18:06 -0400

HI Team, My base view has a date field which is in datatype text ( Varchar-50) and giving value '20190910172316' . I tried to convert the same to date by using " to_date('yyyyMMddhhmmss' , base_view.eff_dt ) as eff_dt " in derived view layer. it worke...

Answers: 1

Date Conversion

No array data from tutorial web service
answered 08-10-2019 10:34:57 -0400

Hi I am following the online tutorial and when executing a query on the web service on 'C003' I get an array come back however there is no data in the array. According to the online tutorial I should be seeing 2 records in the array. Any tips on how I...

Answers: 3