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 updated version of the Denodo Express 6.0 with new features and issues fixed starting in September 2016.

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

Use Denodo to write back to tables of the data source (i.e a RDBMS database like Oracle, SQL Server)
asked 26-05-2017 14:53:24 -0400

How do I use Denodo to write back to tables of the data source (i.e a RDBMS database like Oracle, SQL Server). Is the option set on the data source or the base view of the data source? And how is it done?

Answers: 0

update JDBC Data-Source

Issue adding JMX connection in VisualVM
answered 26-05-2017 05:29:27 -0400

I am trying to add a JMX connection with hostname as localhost and port number as 9999, I am receiving an error cannot connect to localhost:9999 using service:jmx:rmi:///jndi/rmi://localhost:9999/jmxrmi Can someone help me Please let me know if extra i...

Answers: 1

jmx DENODO

How to specify json structure when we publish a flat view as rest web service
answered 25-05-2017 15:06:02 -0400

I have flattern structure like below in one of the views: Person Table ID| Name We want to publish this as a restbased webservice with json output and out put should be like below: {"Persons":[{" ID":"1","name&...

Answers: 6

Connectivity to S3 with data in parquet format
answered 25-05-2017 13:21:37 -0400

Hi, Would like to know if Denodo can connect to the S3 object store and retrieve content stored in the parquet format via a regular SQL query. Thanks. John

Answers: 1

S3

Express password help or reset
asked 25-05-2017 11:45:58 -0400

Just intalled and trying to use Express, but it doesn't like my portal login. And there isn't a "forgot password" link. Any ideas on how to get it reset? Thanks, Bob

Answers: 0

Denodo Java 8 JDBC-ODBC bridge road map
answered 25-05-2017 09:16:24 -0400

We are attempting to upgrade our Denodo to the latest version (v60 update 20170515). This version supports Java 8 which helps us with some new data source connectors, however due to the jdbc-odbc bridge not supported in Java 8, we will be unable to use...

Answers: 2

ODBC JDBC jdbc java8 DataSource

"Some views not found in selected data source" when trying to create a VDPCache job
answered 25-05-2017 07:50:44 -0400

In Denodo 6.0, I'm trying to create a VDPCache job. The virtual dataport source is correctly configured as I can see its different views in the list when selecting a view (in the 'extraction section'). The cache db is also correctly configured because ...

Answers: 1

Calling a Stored Procedure within another Stored Procedure
answered 25-05-2017 04:43:19 -0400

I want to know if I can call a Stored Procedure from another Stored Procedure. For example I want to Generate the Statistics for all Derived Views in a particular VDP database. The "GENERATE_STATS" stored procedure uses the View name as a parameter Th...

Answers: 1

VQL Stored Procedures

Creating a field in derived view using something like partition by.
answered 25-05-2017 00:21:36 -0400

I was wondering if I could get some help in terms of calculating a difference between the date of various statuses. I have a view with column named "id", "create_dt" and "status". I would have various statuses like submit, approve, deliver etc. Now, I...

Answers: 1

DENODO

AWS Athena connection from denodo
answered 24-05-2017 21:08:48 -0400

Hi, I am trying to connect to AWS Athena from Denodo. Has anyone here done this? If yes, please advise. Thanks.

Answers: 3