Latest Activity

code

I need to force index in a integration view with out edit base view from query

Hi, can us help me with that? i want to know if is possible to "force use index" in a oracle sql db by a integration view. /+ INDEX(bd.table IDX_EXAMPLE) / Thanks,

code

Conversion Error Timestamp -> Text with HIVE

Hi, I want to create a Selection View over a HIVE data source and encountered an error within the WHERE condition that I fail to solve. Users should be able to enter a date range using the fields "from_timestamp" and "to_timestamp" of type "timestamp"...

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.