Q&A

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

[JDBC ROUTE] [ERROR] Received exception with message 'ERROR: Grouped aggregate function calls may not be nested' i am getting this issue after adding group by clause .Note the one source is snowflake and other is netezza
answered 08-04-2020 07:21:50 -0400

on denodo 7

Answers: 3

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

Where are the PDFs?
answered 07-04-2020 10:22:55 -0400

Just downloaded Express. Where are the PDF versions of the manuals? HTML/tree paths to who knows where are useless.

Answers: 3

Denodo Express