Q&A

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

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

Is there a way to create the Base Views directly from erwin files or erwin xml files instead of creating the base views individually
answered 04-10-2019 07:40:18 -0400

Is there a way to create the Base Views directly from erwin files or erwin xml files instead of creating the base views individually. We generally create base views connecting to a database where the datamodel of EDW is sitting, but is there a way to c...

Answers: 3

#erwin #datamodel

i18n View Locale
answered 04-10-2019 06:50:07 -0400

Is there something we can run to pull out the base views which have a different map from the default for both the searchmethod and the view, itself?

Answers: 1

query to get i18n type

Denodo alternative for TSQL "STUFF.... FOR XML PATH"
answered 04-10-2019 02:35:33 -0400

Hi, I have a table with multiple rows and a single column called ID - it is aways 5 chars long ID 12345 23456 34567 I want to create a view with a single column output and a single row output that will concatentate all the values inserting a com...

Answers: 2

ARRAY