Latest Activity

code

How to find Invalid views using VQL or Query

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. ...

code

odata 2 Custom datasource error

Team, I am trying to create a datasource to connect to dataverse api using odata2-wrapper and create a base view following below document. https://community.denodo.com/kb/en/view/document/How%20to%20connect%20to%20Microsoft%20Dynamics%20365%20from%20D...

code

Connection to EcoSys

Hello. Does Denodo's datasource connectivity include EcoSys (https://www.ecosys.net/) ? If so, what type of data source does one need to create in Denodo to connect to EcoSys, please? Thank you.

code

Denodo express: 'Invalid username or password' when trying to connect to Virtual Dataport Administration Tool

Hello, I started the Virtual data port server, as explained in https://community.denodo.com/docs/html/document/8.0/en/Denodo%20Express%208.0%20Quick%20Start%20Guide, and then launched Virtual DataPort Administration Tool. I enter the credentials admin...

code

Denodo function equivalent to Table.AddIndexColumn Power BI function

Does Denodo have a function that is equivalent to the Table.AddIndexColumn Power Query function that one can use in Power BI? See: https://learn.microsoft.com/en-us/powerquery-m/table-addindexcolumn

code

Delimited DS base view row count limitation

Hi Team, We are using csv file as delimited Data source in denodo which is having 3 lakh + rows but in denodo BV, it only shows "999999" row's only, is ther any limitation ? how can we get all rows ? Platform version 8.0 Thanks & Regards, Raju

code

Denodo to OCI via ODS, Actve Data Guard

Can Denodo create base views on top of the synonyms (+ tables) created in ODS pointing in real time via Active Data Guard to the tables designed in OCI ? Also, how about the delegation of query back to OCI with ODS, Active data guard in picture like wi...

code

First of previous month

how do i get first of previous month? addmonth(current_date(),-1) provides exactly one month ago , but how do i set to always get 1st. for example, from 4/1-4/30, want to pull from 3/1.

code

How to remove a new line character in a field?

I want to remove new line characters and replace it with a dot in every record from a field. Giving an example below: Abcd Efgh 1234 ijkl The above mentioned example is a value in a single record. I want the final output as: Abcd Efgh. 1234. ijkl ...

code

Developing VQL Procedures

I'm trying to develop some VQL procedures and need help to figure out how to configure the input-parameters optional and/or nullable. Can't find any good descriptions on how to do this. Please assist to resolve this issue. Thanks