Q&A

Filtering by max date
answered 25-07-2019 06:20:21 -0400

I am trying to filter a transformation by only pulling in the rows that have the latest effective date. I've tried using the max function, but have been unable to get the results I'm looking for. Running on version 6.0.

Answers: 1

Function

Query on joining and updating.
answered 25-07-2019 05:24:23 -0400

I have a view, I need to update columnA with Column B if that columnA as null value , do we have denodo query for it.?

Answers: 1

Query

Dependencies tree not auto populating in the "Revision Elements"
answered 25-07-2019 04:39:04 -0400

Hello, I am creating a revision using the view which has dependencies in different databases. Basically the view which I am trying to promote or Deploy from one enviromnent to another is derieved from a view in different database in denodo. While I se...

Answers: 3

solution manager Dependencies Tree revisions Promotion Deployment using Solution Manager Best Practice deployment

Download Denodo Training 7.0 QuickStart Virtual Machine fails
answered 24-07-2019 08:30:55 -0400

Hello, I tried downloading Download Denodo Training 7.0 QuickStart Virtual Machine several times but without success. The zip file is 1.5 GB in size but can not completely finish the download of Denodo Training 7.0 QuickStart Virtual Machine.zip file....

Answers: 2

Denodo Training 7.0 QuickStart Virtual Machine

Missing VQL properties while validating revision
answered 24-07-2019 00:58:31 -0400

I am getting the below error while validating the revision in Denodo 7 Missing Vql properties: 'config.PROPERTY.com.denodo.security.file.privilege.generalaccess', 'config.PROPERTY.com.denodo.vdb.cache.cacheMaintainerPeriodInSecs', 'config.PROPERTY.com...

Answers: 1

DENODO revisions deployment

removing scheduler data sources outside of GUI
answered 23-07-2019 08:32:17 -0400

Is there a way to remove data source from the scheduler web page from the back end? We are getting an error in our dev environment trying to access data sources and we see a Datasource type not supported message in the logs. I was hoping to clear out a...

Answers: 3

New Webpage with excel as source
answered 23-07-2019 08:10:35 -0400

Hello, I have a very simple requirement to create a webpage with just fields "Employee ID", "From Date" and "To Date" and a search button. The return result on the webpage would have 3 fields..Employee ID, Dates, Present (Y/N). This is to let an emplo...

Answers: 4

Is there a way to Localize/Customize the Denodo Catalog Screen.
answered 23-07-2019 08:02:45 -0400

Say we want to implement the denodo to a bank or telecomm industry and we would want to localize the data catalog screen like having their logos or showing the logos of the client in the catalog screen , is it possible to do ?

Answers: 1

#Catalog #Customsearch

Conneting to AZure SQL
answered 23-07-2019 07:58:08 -0400

How can we connect to Azure SQL DB? what type of connection it would be? MS SQL Server? I dont see Azure specifically.

Answers: 1

Connecting Denodo views with parameters to Power BI.
answered 23-07-2019 06:58:01 -0400

I've been working with a few Denodo views and am looking to bring the final view into Power BI. However, I need to somehow define the required parameters as I'm connecting the view or else Power BI will return an error. I would like to connect these de...

Answers: 1

Power BI Parameter Power Query