Q&A

Use of setDelegateProjections in CustomWrapperConfiguration
answered 17-05-2021 21:23:22 -0400

Using setDelegateProjections(true), the instruction said "Custom Wrapper can deal with projected fields." What does it mean? Projected fields (which columns should be displayed in a SQL SELECT statement) can only be specified in a derived view, not in...

Answers: 1

Custom Connector custom wrapper

Denodo vs Informatica
answered 17-05-2021 08:43:05 -0400

Hi Experts, My manager asks what is unique in denodo that informatica or BODS cannot do? Denodo vs Informatica - bullet points needed. Pls share

Answers: 1

Handling of Array by Spark Simba driver
answered 14-05-2021 17:12:12 -0400

Hi Team, I am using spark driver in denodo to query the data. While i directly query objects in S3, the column datatype is shown as an array, but when we onboard it to denodo it is onboarded as "text" and I don't see a dataype as an array in denodo. D...

Answers: 1

#array #customfunction

non-JRMP server at remote endpoint - Can't connect jconsole
answered 14-05-2021 16:58:03 -0400

Hello, When I try to connect to localhost:9997 using the jconsole I get an error: Connection failed: non-JRMP server at remote endpoint. I have TLS enabled. What might be wrong? Thank you

Answers: 1

jconsole

GQL service
answered 13-05-2021 18:38:33 -0400

How did you configure denodo GQL service with apollo playground here?

Answers: 1
Related to: GraphQL in Action - Execution and Navigation

LEFT JOIN losing rows
asked 13-05-2021 12:01:52 -0400

Hello, I am trying to join some tables, all with LEFT JOIN, but when I try, the numbers of rows in the results is less than the table in FROM statament. The strange thing is that if I change the order of the joins the number of the results rows change....

Answers: 0

How to add a trailing 0 to number
answered 13-05-2021 11:23:44 -0400

Hello, I have month and day in this format 1,2,3... how can I convert it to 01,02,03, ... Thank you

Answers: 2

concatenate

Convert text to Timestamp
answered 13-05-2021 11:23:10 -0400

Hello. I am trying to convert a text to timestamp: My text has this format dd-MMM-yyyy HH:mm:ss I am using this function to_timestamp('dd-MMM-yyyy HH:mm:ss', bv_ho_orders.date_placed) When I convert to timestamp some of the dates are null. ...

Answers: 2

Date Conversion timestamp

Configuring an environment with localhost
answered 13-05-2021 11:21:54 -0400

Hello, I am trying to follow the demo in DEN80EDU18S01, but when I use localhost as a host it does not let me. Is there any way of doing this demo in the same server? Thank you

Answers: 2

Environments Solution Manager

How to assign specific admin role that prevent modification on databases created by others ?
answered 13-05-2021 06:24:11 -0400

Hello, I'm wondering how to assign a specif ADMIN role to users that : allow granted users to create/modify their own databases and related objects does not allow these users to modify existing databases created by others Currently, I'm only ...

Answers: 3

Roles Users