Home / Q&A / All Questions

Q&A

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

COLUMN_DEPENDENCIES ()
answered 11-11-2021 07:38:38 -0500

Hi, I'm working on the output from COLUMN_DEPENDENCIES () for a given report view but Im having trouble following the lineage for a given column as we have used column aliases to make the column label more useful to an end user. So for example: column...

Answers: 1

Getting "com.denodo.vdb.engine.customwrapper.CustomWrapperException" error while executing select query on view created from sharepoint
answered 11-11-2021 07:36:15 -0500

Hi, We have created a sharepoint connection in design studio. we are able to create view from that connection but when we execute the select query we get "com.denodo.vdb.engine.customwrapper.CustomWrapperException" exception. when we looked at the log...

Answers: 1
Related to: How to connect Denodo to Sharepoint Online using OData with OAuth authentication

Custom Data Sources SharePoint

Migrate from Denodo 7.0 to Denodo 8.0 - Servers
answered 11-11-2021 05:02:24 -0500

Hi community,For an installation of DENODO 7.0 with 1 server for PreProduction and 2 Production servers (all with different IPs, non localhost), in terms of migration to Denodo 8.0, would it be necessary to have different machines to install the new se...

Answers: 1

#Denodo_Migration

Getting the stats in a VDP Server
answered 10-11-2021 17:31:48 -0500

is there a VQL which i can use to get how many number of databases,folders,views or other like how many Cpu's are there in vdp server?

Answers: 1

#VDPserver

COLUMN_DEPENDENCIES procedure
answered 10-11-2021 16:26:55 -0500

Hi, I would like to run the COLUMN_DEPENDENCIES procedure across all views in a given database to identify columns that have an expression associated to the column. In pseudo code this would look like: select view_name, column_name, expression from C...

Answers: 1

JSON Datasource Tuple Root Rows
answered 10-11-2021 15:14:19 -0500

Hello, I'm trying to create a JSONDatasource from this sample: [ { "Header": { "publishedDateTime": "20211110150141", "messageId": null, "messageType": null, }, "Investment": { ...

Answers: 1

JSON Data Source

how to integrate JMX exporter
answered 10-11-2021 07:24:54 -0500

We now uniformly use Prometheus as a monitoring tool. How can denodo’s information be connected to Prometheus? How to configure? The key points that need to be paid attention to? can you help arrange meeting to discuss about this? 4.Please prov...

Answers: 1

StoredProcedureException
answered 10-11-2021 07:19:04 -0500

Hi, I create a stored procedure for create drive_views, i would like validate if drive view exist before create. I try this: this.environment.executeVqlCommand(select 1 from drive_view) but if it not exist i receive the error by StoredProcedureExcept...

Answers: 3

Denodo Dashboard tool
answered 10-11-2021 02:44:45 -0500

In Denodo8, is Denodo dashboard tool depreciated in denodo 8? is there any similar tool to replicate derby metadata to ther nodes in cluster? OR what do you recommend since we are using derby.

Answers: 1

#metadata

Base Views source Refresh automation
answered 09-11-2021 05:51:52 -0500

Hi, my question is about how to automate the update of the base views in Denodo 8.0. When adding fields to tables in AWS connecting with a jdbc source to Athena. Still has to be done manually, or is there any procedure for it to be automated? Thankyou.

Answers: 1