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 November 2018.

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.

Use Denodo to write back to tables of the data source (i.e a RDBMS database like Oracle, SQL Server)
answered 29-05-2017 08:27: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: 1

update JDBC Data-Source

Express password help or reset
answered 29-05-2017 07:37:46 -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: 1

Denodo Java 8 JDBC-ODBC bridge road map
answered 29-05-2017 03:48:20 -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: 3

ODBC JDBC DataSource jdbc java8

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":"abc1"},{"ID":"2","name":"abc2"}]} Note:...

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

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 The...

Answers: 1

VQL Stored Procedures

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

Error updating data from SAS via ODBC
answered 24-05-2017 11:51:11 -0400

We have connected a SAS Server to Denodo via the postgresql ODBC connection. We can access the views created in Denodo as a SAS library and read data. The views appear in SAS as SAS datasets. However, when attempting to update or insert data, the foll...

Answers: 4

ODBC

Denodo DVP 6.0 and SQL Server Performance
answered 24-05-2017 09:07:43 -0400

Community, I'm fairly new to the forumsd, so please be patient with me. I configured a SQL Server 2014 data source using the SQL Server 2014 JDBC driver and noticed poor performance characteristics when issuing a query using a varchar field as the se...

Answers: 3

Slow Query Response SQL Server Table scans of Text fields Ignores Server Indexes

Issue checking out using VDP from TFS
answered 24-05-2017 06:02:55 -0400

Version: 6.0 Latest Update: denodo-v60-update-20161219 Error Message: "An error was found: error checking /databases/myDatabase out: Error: includeCreateDatabase option was selected but the repository does not contain the file '--path to local reposit...

Answers: 1

TFS VDP Source Control VCS