Q&A BY TAG 'Denodo 7.0'
Expression written on a column of a flatten view
answered
16-07-2020 10:57:46 -0400
Unable to get the expreession written on column of a flatten view from element_metadata table. I get the output for the column - "expression" as --> Flattened Field: "EX_LIST_array" Note: Base view has an array data set. We flatten the base view i...
Answers:
1
Custom Policy - Access to view parameters & Masking reason
answered
17-06-2020 01:59:37 -0400
The need is to accept a view parameter which will contain some security related information/token from another internal system. Based on that info, the view columns needs to be masked or/and filter rows and return to the consuming application. The addi...
Answers:
6
Access to view data in CustomPolicy class
answered
16-06-2020 00:02:45 -0400
We have a need where we will receive user roles as a view parameter value, then that parameter will be parsed within a custom policy to make sure the role exist, then that role needs to be translated to actual values (which exists in a view within a co...
Answers:
3
How can we deploy scheduler - scheduling jobs from one environment to another without using the solution manager?
answered
05-06-2020 08:01:48 -0400
We have independent environments having one solution manager for each environment - We don't use scheduler manager for our deployments. Is there a way I and deploy one specific job from one environment to another - without creating individually? Appre...
Answers:
3
Jar could not be deleted: error removing JAR: Error loading user
answered
05-06-2020 01:51:57 -0400
Version: Denodo 7.0 I am getting same error as explained in the QA at https://community.denodo.com/answers/question/details?questionId=9060g00000009rlAAA&title=Error+removing+JAR%3A+Error+loading+User%28XXXXXX%29 Jar could not be deleted: error r...
Answers:
4
Scheduling job to load data for all the month-end dates in the caching database.
answered
26-02-2020 07:47:06 -0500
Hi, We have created multiple final views with mandatory parameter 'as_of_dt' for each view. Now, we want to schedule job to load all month end data in cache.( all month end dates for future and past- not any single month end date ) I was planning to ...
Answers:
1
DATE / TIMESTAMP fields are not reflecting the i18n mapping change. Let us know if you need more info.
answered
29-01-2020 18:44:19 -0500
When applying custom i18n mapping to existing views and setting the custom i18n mapping as default we made these changes: To create custom I18N mapping CREATE MAP I18N i18n_us_est_custom ( ‘country’ = ‘US’ ‘datepattern’ = ‘MM/dd/yyyy’ ‘datesubtypepat...
Answers:
1
DATE / TIMESTAMP fields are not reflecting the i18n mapping change.
answered
28-01-2020 13:26:05 -0500
When applying custom i18n mapping to existing views and setting the custom i18n mapping as default we made these changes: To create custom I18N mapping CREATE MAP I18N i18n_us_est_custom ( 'country' = 'US' 'datepattern' = 'MM/dd/yyyy' 'datesubtypepa...
Answers:
1
DATE fields being converted to TIMESTAMP in Denodo.
answered
24-01-2020 15:28:35 -0500
While creating base views from data source (oracle), denodo converts all DATE fields to TIMESTAMP. When we try to access these date fields from any JDBC client in our case 'DBeaver' we get these fields as TIMESTAMP and not 'DATE' fields. Is there a way...
Answers:
2
Is this still required in Denodo 7.0?
answered
03-09-2019 06:36:10 -0400
The knoweldge base article says this is applicable to Denodo versions 5 through 6 but I'm seeing this error on denodo 7.0 when querying a base view on oracle 12c using the authentication option "Use pass-through session credentials". When I chose to us...
Answers:
1
Related to:
Connection to Oracle using Enterprise User Security (EUS)