Q&A

Preserve View Comments
answered 22-07-2021 12:07:48 -0400

I have noticed when creating a view any comments inserted are stripped out. I can't understand why stripping out comments would be a feature as comments are an extremely important part of development. Is there a way to preserve the comments like there ...

Answers: 1

Connecting from Microsoft PowerBi
answered 22-07-2021 11:53:32 -0400

Hi Team, Quick question, I've just downloaded and installed MS PowerBI on one of my VM's, however, am struggling to figure how can I connect it with Denodo. If I go to PowerBI then > Get Data > Database - in the dropdown list Denodo doesn't sh...

Answers: 2

denodo-v80-update-202107152200.jar fails command line update
answered 22-07-2021 03:07:00 -0400

./jre/bin/java /opt/denodo/updates-for-denodo-20210715/denodo-v80-update-202107152200.jar "/opt/denodo/denodo_platform_8_0" -c Error: Could not find or load main class .opt.denodo.updates-for-denodo-20210715.denodo-v80-update-202107152200.jar Caused b...

Answers: 1

Denodo 8.0 update Error Virtual DataPort

Create base view from sql query - Oracle
answered 21-07-2021 19:34:22 -0400

Hey, I'm trying to create a base view from a sql query where one of the fields in the oracle table has the name SERIAL#. I can import the table if I remove this field, but I need this field! How should i put the field in the select: select sid, SERIAL...

Answers: 1

Special Charter

Web Service Data Source: error building classes
answered 21-07-2021 14:32:25 -0400

I am trying to create a Web Service Data Source from Denodo Design Studio. I have proper WSDL and authentication (they work in Postman and Oracle PL/SQL code). When I try to "Create a Base View" the "Loading" gif spins for 2-3 minutes, then I get an er...

Answers: 1

#WSDL #ErrorBuildingClasses

Convert Text To date
answered 21-07-2021 12:39:00 -0400

Hello, I have a question regarding the conversion of incoming Text format to a Denodo Date format The field name is <fld_name>. And, a sthe incoming date values are: Jun 29, 2005 19:19:41 Using the FORMATDATE function you to have datatype to ...

Answers: 1

API filtering with array of values in POST body
answered 21-07-2021 10:42:35 -0400

Hello team, I am currently having an issue with the following case : I have an endpoint on my Denodo REST API on which I am trying to make a POST query with multiple parameters on the body which can be arrays of values (multi criteria search endpoint)...

Answers: 6

#Rest API Filter

Denodo Training quickstart virtual machine login
answered 21-07-2021 00:19:10 -0400

Hello, When I start Denodo Training quickstart virtual machine from ova file it is asking me data-server login. The user admin with the password admin do not work. Please, can you provide me the credentials.

Answers: 1

DQVM

Mixed Column names for views
answered 20-07-2021 18:44:10 -0400

Hi Team, I am working on Denodo 8.0 and want to see if there is a way to define the column names in InitCap? Example ViewName (instead of viewname) Col1Name1 (instead of col1name1) Col2Name2 (instead of col2name2) If i make the database Unicode then...

Answers: 3

how to filter recent 3 years data in denodo vql
answered 20-07-2021 17:52:50 -0400

How to filter recent 3 years data

Answers: 1