Q&A

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

Flatten Operation
answered 15-03-2021 07:55:55 -0400

I am trying Flatten tutorial mentioned below link. https://community.denodo.com/tutorials/browse/basics/3adv2flatten Step 3 isn't working for me "Go to the Output tab, rename the view to billing_information and also rename the field customer_id to ret...

Answers: 1

SOAP

Right permission for developer role in higher environment to read the VQL without WRITE permission
answered 15-03-2021 06:53:15 -0400

Hi Team, Can you say which privilege would be right for developers to have in test/Prod enviornment. For eg we have to assign execute but not write. When we provide execute rights, developers are not able to view the vql of the object created and gath...

Answers: 1

Bulk Data Load - Denodo8.0 DBFS
answered 15-03-2021 04:47:49 -0400

I am configured bulk data load API with databricks as cache and configured databricks cli (dbfs) in our denodo linux server..it successful when testing Listing HDFS URI contents ... OK Creating HDFS URI temporary directory ... OK Creating table ... OK...

Answers: 1

Bulk Data Load Denodo8 databricks API

parameterized REST API End Point
answered 14-03-2021 11:11:39 -0400

I have REST API end point shown below http://api.mydata.com/mydataAPI/api/InventoryTrading/w?flag=&quotetype=AA&productcode=101 I will get only one row with above URI which is for product=101 I want to parameterized last part ( productcode=1...

Answers: 1

REST API

Unable to do LAB DEN80EDU12D05LAB01
answered 12-03-2021 08:17:21 -0500

When trying to create de base views of the database Call Center (DEN80EDU12D_cc.db), the VDP trhows an error that it Not recognize the type of the table. I canĀ“t use the virtual machines because is not allowed on mi works machine.

Answers: 1

SQLiite

Can we create a column in Denodo which will be passed as an input to the service and the same input is used as records as default value in the API ?
answered 12-03-2021 07:41:12 -0500

Can we create a column in Denodo which will be passed as an input to the service and the same input is used as records as default value in the API ? For example I have created an API with 4 column A B C D column A, B, C have data which is coming from a...

Answers: 1
Related to: Creating a field with null value

How can I export the data of executed query in a file in Design Studio Web UI
answered 12-03-2021 06:38:00 -0500

We are trying to export using Save option on Design Studio. But the trace folder doesn't have the data of executed query. I am able to save the same on Tool.

Answers: 1

design studio

Solution Manager for each environment
answered 12-03-2021 06:23:35 -0500

This is regarding Solution Manager of Denodo 8.0. Could you please clarify us if Solution Manger can be seperate for each environment? We are planning to have Solution Manager to be installed in each server where Denodo platoform is installed?

Answers: 1

Solution Manager

Converting Oracle Functions to Denodo
answered 12-03-2021 05:37:37 -0500

Hello, I have an Oracle function that takes a few parameters and spits back out an output based on the logic inside the function. From what I can tell about Denodo, in order to be able to use this function, we would have to convert it to Java and then ...

Answers: 1

custom policy oracle java

GetSession not working outside of the VDP
answered 11-03-2021 07:55:36 -0500

I had the following script and then various views based off this script working in the VDP but then when I tried to run a dervied view from a tool like DBeaver everything is coming up blank because the GETSESSION function is not returning a value. Is...

Answers: 1

select query vdp getsession dbeaver