Q&A

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

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in September 2019.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Creating views take a lot of time so is there any ways to automate the task?
answered 09-04-2020 08:25:33 -0400

When there are plenty of tables ...it consumes a lot of time to create views so how do we automate the task

Answers: 1

Write back data from Excel source to Oracle db using Denodo
answered 08-04-2020 07:56:44 -0400

Hi, I have data that gets generated in excel and I would like to insert this data everytime it is generated into a Oracle DB using denodo. Is this possible in denodo?If yes how can it be done. Thanks & Regards, Nisarg Shah

Answers: 5

Cannot Connect to training Oracle database
answered 08-04-2020 05:29:06 -0400

I am following along the developer basic traing. But got stuck while connecting to oracle data-server. The error i'm getting is: Unable to establish connection: IOError: The network adapter could not establish connection. The database URI: ...

Answers: 11

JDBC Data Sources training Oracle 11g

REST web service with JSON representation
answered 08-04-2020 04:13:13 -0400

Hello, I've published a REST web service and have selected JSON as default representation. The problem id that if I access the service from a web browser I get the HTML output instead of the JSON output that is expected. Does anybody know why is this ...

Answers: 3

Assigning Solution Manager Roles
answered 08-04-2020 02:23:08 -0400

Hi, I want to assign following roles for the users created in VDP of Solution Manager (SM) so that they can perform solution manager admin activities as per their access in the SM admin tool. However, when I go SM VDP and select a user to assign a rol...

Answers: 4

Remote table Creation
answered 08-04-2020 02:13:14 -0400

Hi All, I am trying to create remote table in VQL shell and it gives syntax error between Create and remote Please help me to create a remote table in mysql already enabled the bulk data load api and mysql varaible local_infile to on Not able to see th...

Answers: 3

remote table

Get "CSV Exporter Outuput file" from a Job using JAva scheduler API
answered 07-04-2020 21:11:07 -0400

Hi team, I would need to access to the corresponding output file generated by each job on a Denodo Scheduler project. We are using the Java Scheduer API to do that, so can you provide which java class or object contains this info, and how it can be a...

Answers: 2

Oracle partition
answered 07-04-2020 15:46:18 -0400

Hi, Can you please tell me how can i select data from oracle partition, this syntax doesn't work in denodo SELECT * FROM mytable PARTITION (partition_7_24_2016) WHERE customer = 'abcd'; Thanks

Answers: 1

User Access and Privileges
answered 07-04-2020 12:47:01 -0400

Question 1: Is it possible to revoke the 'allusers' role from a user? Question 2: How can we give specific privileges over a user to the Solution Manager. Should the user be created in the SM VDP or where should I be doing it? Thanks in Advance

Answers: 1

Create User Role and User Management Roles Users