Q&A

You must sign in to ask a question. If you do not have an account, you can register here

Can we query Denodo Base view and create csv data extract for the query by using unix script?
answered 29-07-2021 16:59:20 -0400

Can we query/trigger Denodo Base view and create csv data extract for the query output by using unix script?

Answers: 1

Query baseview from script

Is it possible to see the deleted items?
answered 29-07-2021 14:52:41 -0400

Hi Team, There is one adverse thing happened to my denodo Setup that most of the items in development environment have been deleted. I want to know that is there any method to get the details of the deleted items? Using dev as standlone server and the...

Answers: 1

Admin tool DENODO LOGS

hide folders in design studio
answered 29-07-2021 14:47:37 -0400

Hi, I would like to check is it possible to hide folders like baseview and data sources in the design studio to a certain privilages users? Thanks!

Answers: 1

Connecting to PGAdmin
answered 28-07-2021 19:06:38 -0400

Will be able to connecct denodo with pgadmin as like connecting denodo with DB visualizer? if yes how can I do that?

Answers: 1

Rename columns of derived and interface views
answered 28-07-2021 17:33:56 -0400

Hi, Please advise on using alter statement to rename columns of derived views and interface views. We are using this command, alter view dv_view ( alter column old_coiumn rename new_column ) Error - Syntax error: Exception parsing query near 'rename'...

Answers: 1

derived view column rename

Denodo test case
answered 28-07-2021 15:13:20 -0400

Hi, where can you write queries to test data in denodo? Thanks!

Answers: 2

Adding or Editing Items in a Sharepoint list via a Denodo view/query
answered 28-07-2021 11:58:57 -0400

Please advise if there is anyway to Edit or Add Items on a Sharepoint List via an existing OData connection view. is this possible or are you only able to "read" a SharePoint list via Denodo?

Answers: 3

update List SharePoint

Exporting multiple CSV files through single VDP job
answered 28-07-2021 11:58:30 -0400

Hi , I have one vdp job, through which im reading CSv file which contains list of view names and im loding cache of those views. Now I want to export the cache contents of those views in CSv format but in different CSV files ( as per view names)whe...

Answers: 1

Condition based Base view call
answered 28-07-2021 11:10:18 -0400

I am having 3 base views : A, B, C. I need to create a single business view (D) based on the below condition. Please let me know how to achieve this use case : If (Condition 1 satisifed) Then Base view A's should be displayed as D's output Else Base v...

Answers: 1

CASE

Credential setup for "Distributed file system data source -- (H)DFS parquet file wrapper
answered 28-07-2021 07:26:27 -0400

Hi team, I am reading document "https://community.denodo.com/docs/html/document/denodoconnects/6.0/Denodo%20Distributed%20File%20System%20Custom%20Wrapper%20-%20User%20Manual" to setup data source and wrapper for hfds parquet file, I understand we need...

Answers: 3

dfs security credential connection was forcibly closed hdfs wrapper parquet