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.

Scheduler Admin Extraction Section and Exporter Section
answered 16-06-2020 01:23:12 -0400

hello, I created a scheduler job. below is the query I have in "Extraction Section"(using Parameterized query option) and I am dynamically getting the gtin value from "list" source. select from ent.dv_extractaxwaysns where dv_extractaxwaysns.gtin='@gt...

Answers: 2

Job scheduler Denodo Scheduler 7.0 Scheduler Admin Extraction

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

Denodo 7.0 custom policy

WebService Dependencies
answered 15-06-2020 13:59:37 -0400

Is there are way I can get DEPENDENCIES (VIEW_DEPENDENCIES) similar way that we can get for base, integrated and business views?. Looking for a way to get Lineage from "Web service-Business-integrated-Base-Datasource" via command (VQL). Also, any way ...

Answers: 1

WebService view_type

SQL Server date datatypes error in conversion for base views
answered 15-06-2020 04:04:07 -0400

¬°Hello dear Gurus! I'm facing an odd issue for which I found no way to solve it. Source Server DataBase is SQLServer 2016. SQL Server has Collation SQL_Latin1_General_CP1_CI_AS Conflicting datatypes: datetime2, smalldatetyme Here's dataty...

Answers: 1

Date Conversion Base view datetime Error SQL Server

SQL Server date conversion error in BaseView
answered 15-06-2020 04:02:11 -0400

Hello Support Team We are having a big stopper in a project with an odd issue for which we can't find a way to solve it. Technical data is and Consultant has already raised the same question: Source Server DataBase is SQLServer 2016. SQL Server...

Answers: 1

Date Conversion Base view VDP 7.0 SQL Server

Data Catalog - Synchronize comments
answered 12-06-2020 13:01:30 -0400

When I change the description of a database in the data catalog, I cannot see this change in the VDP. Also, when I change the description from the original value in the VDP, this value is never refreshed in the catalog. Do they maintain a different m...

Answers: 1

Data Catalog

How to add ' ' in the string
answered 11-06-2020 08:41:14 -0400

Hello Colleagues, I have data coming from source as BE01, DE01 etc. for company code field. I want to create a new column in Deonodo based on this and data for new column should be like 'BE01', 'DE01' etc. How to achieve this? Regards, Vijay

Answers: 1

How to use Tidal scheduler
answered 11-06-2020 06:47:05 -0400

Hello Team, We have an enterprise scheduler tool as Tidal. Can you help us step by step how to schedule a denodo cache refresh via tidal scheduler . We got some article online , but it doesn't give any step by step methods to create the job starting ...

Answers: 3

CSV Filename Column
answered 11-06-2020 06:44:58 -0400

I am curious if there is any way to include the filename or part of a filename for CSV files in the base view; something simlar to how the Excel wrapper can provide the sheetname as a column in the base view for an Excel data source. My use case scen...

Answers: 4

CSV

Json data source using Outh2 Authentication
answered 11-06-2020 06:09:12 -0400

Is there a documentation where it helps us to connect to json data source using oauth2 authentication?

Answers: 1

JSON Data Source oauth2 oauth