Q&A

Column based security in Custom Policy?
answered 15-04-2021 23:55:15 -0400

We've built a Java custom policy that returns certain rows of data based on the user's security in a config table, but can Custom Policies give us column-level security? As in, can Denodo return only a certain amount of columns of a table based on the ...

Answers: 1

Denodo 8.0 custom policy data security

Does Denodo supports Data presentation through charts and reports
answered 15-04-2021 18:18:14 -0400

Hi, Am doing POC on Denodo express. Just worried if Denodo supports a graphical presentation though graphs or charts, filtering etc on Data Catalogs? I am comparing the features with Kibana (from ELK stack) where it does virtualization as well as prese...

Answers: 2

presentation VDPs' Reports chart

Can't Create job - Error saving job: Internal error
answered 15-04-2021 09:08:44 -0400

Hello I am trying to complete the DEN80EDU15DS03, but when I try to create a new scheduler job I keep getting this error: Error saving job: Internal error Can anyone help? Thanks

Answers: 1

Job scheduler

Denodo storing the data in external database.
answered 15-04-2021 08:41:35 -0400

Hi Team, If connection breaks from Denodo to exteranl database dues to some network issue or if external database instance goes down then what is retry startergy? How often Denodo tries to reconnect? what is max retry count?

Answers: 1

external database denodo retry

I'm not able to retrive attribute from xml using xpath
answered 15-04-2021 08:33:52 -0400

I want to retrieve an attribute from xml value using xpath but I cannot retrieve it. If I execute statemet: SELECT cast('text', XPATH ( CAST ('xml' , '<Root attr="1111"> test </Root>' ) , '/Root/text()', true)) as xpath_results FROM Dual();...

Answers: 3

XPATH

VDP v7 Not able to pull from Gitlab
answered 15-04-2021 08:27:33 -0400

Hi - when pulling the latest code from remote, it succedes. We can see the correct files on the Denodo server. But when pulling inside the VDP client, not all changes appear, but no error is reported. We are running version v7.0.2x We can also push...

Answers: 1

VDP GIT

current_timestamp(0) function issue
answered 15-04-2021 08:24:59 -0400

Hi Team, Query 1: I followed the solution you provided in previous article: https://community.denodo.com/answers/question/details?questionId=9064u000000L849AAC&title=insert+operation+through+postman+for+multiple+unique+primary+keys datasource:terad...

Answers: 3

Denodo Hot backup
answered 15-04-2021 07:48:22 -0400

We wanted to setup a Denodo hot backup. I understand that this will be a separate always running server where metadata will be backed up/synchronized by the Solution manager and which will come up once main server goes down. However, I didn't find an...

Answers: 1

Denodo active-passive

SAP HANA VIEW
answered 15-04-2021 07:41:59 -0400

Hello Team, what is the best approach to get data from sap hana view generated on top of the composite provider in BW4HANA to Denodo for reporting. Any help will be much appreciated. If you have step by step documentation please provide. Thank you. Patric

Answers: 1

Sap hana

INSERT Operation fails with multiple records and the now() function
answered 15-04-2021 07:26:17 -0400

I'm performing a simple Insert Operation with multiple records using the now() function. insert into "ViewName" ("Id", "Name", "EmailAddress", "EmailDtm") values ('1', 'joe', 'joe@denodo.com', now()), ('2', 'joe', 'joe@denodo.com', now()) It throws a...

Answers: 1

datetime Insert Operation