Q&A

DenodoODBC_x86.msi is blocked by Microsoft Defender (due to Unknown publisher)
answered 24-01-2021 00:24:56 -0500

The error message is Windows protected your PC Microsoft Defender SmartScreen prevented an unrecognized app from starting. Running this app might put your PC at risk. App: DenodoODBC_x86.msi Publisher: Unknown publisher

Answers: 1

ODBC Driver

Commands/VQL Statement to manage Scheduler Jobs
answered 22-01-2021 06:18:47 -0500

Hi, Does scheduler support management of jobs through a command line interface or VQL interface? We are ware that Scheduler Client API allows jobs, filter sequences and data sources to be programmatically configured and managed. But its to feasible ...

Answers: 1

Scheduler Jobs

How can we check a specific user/account is created by which account?
answered 22-01-2021 05:12:08 -0500

Hi team, if I have Denodo account in DV, and I want to check who and when created that account, how can we do that? We down the vdp.log but cannot get this kind of information. How can get this information? thanks.

Answers: 1

user account check who create

Flat file data source compressed zip file
answered 21-01-2021 03:24:03 -0500

I am using Dendo 8 platform. I have a zip file containing multiple delimited csv files. I create a delimited file datasource and during source configuration I select "Decompress (zip format)" option. Test connection is successful. However after I save ...

Answers: 1

About the access of rules in Resource Manager
answered 20-01-2021 08:29:40 -0500

Hi team, We have requirment: we have a denodo role group (such as the same is role_aaa), we want to define a rule that only want to apply to this role_aaa, which let the query sent from this role group, its runtime cannot exceeds 5 minutes. what I set ...

Answers: 3

condition， resource Manager rules

Error using multiple inner joins
answered 19-01-2021 04:53:30 -0500

Hi Community I'm facing an error with vdp, when using joins. I'm working on a view using 28 inner joins, at 25th join everything works fine, but when i add the 26th table to join with i have the following error : Finished with error: Error executing...

Answers: 1

joins

How to find Invalid views using VQL or Query
answered 19-01-2021 02:23:36 -0500

I want to find the invalid views using vql or query . This is really important as when import happens to higher environement using solution manager it really doesnt show the errored view and need to manually check all the views which is very tedious. ...

Answers: 6

Connectivity between DataRobot & Denodo
answered 18-01-2021 23:09:31 -0500

Hi, I would like to know if there is connectivity between Denodo & DataRobot i.e. can DataRobot tool connect to Denodo & vice versa? Thanks & Regards, Nisarg Shah

Answers: 2

Query optimization for fixed length file sources
answered 18-01-2021 10:18:33 -0500

Hi, We have fixed lenth data source and it is mutli record type file for example the starting of the row will what type record it is like if start with 's' it is a student record it is start with 'm' it is marks record like that there will be mutiple ...

Answers: 1

Query Optimization in denodo 7

Summary rewriting does not work when querying through an interface view
answered 18-01-2021 09:30:10 -0500

Hi, I'm making tests on Summary Rewrite Optimization using Denodo Express 8.0 for Windows 64 bits. I have a base view on an Oracle table (bv_dwhxn_facd). I have an interface view on this base view (iv_bv_dwhxn_facd). To keep it simple the interface ...

Answers: 1

summary query re-write