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.

Correct way to setup a DB-link from an Oracle database on linux to a denodo progress database?
answered 25-09-2018 16:22:45 -0400

What is de best/correct way to get a DB-link from an Oracle database on linux server ( not on an client ) to a denodo progress database? Do we use JDBC of ODBC? Can this be done with only a driver or is an install of a gateway required? Kind regards ...

Answers: 3

Installed Denodo Express 7.0 but unable to launch platform control center using denodo_platform.sh it returns null and stays that way
answered 25-09-2018 03:15:46 -0400

[sandadmin@aws1sandl057 bin]$ pwd /home/sandadmin/Denodo/Denodo_Platform/bin [sandadmin@aws1sandl057 bin]$ ./denodo_platform.sh [sandadmin@aws1sandl057 bin]$ null

Answers: 1

platform control center

Denodo connect to DSN
answered 24-09-2018 21:55:53 -0400

Hi Team, Please support on linux (ubuntu 16.04) server error when connecting via dsn (MySQL driver) This is exception {code} Caused by: java.net.ConnectException: Connection refused (Connection refused) at java.net.PlainSocketImpl.socketConnect(Native ...

Answers: 1

DSN

Connection error, Denodo Platform 7.0 on Windows 8.1 Enterprise
answered 24-09-2018 12:42:15 -0400

connection error: unrecognized method hash: method not supported by remote object Denodo Platform 7.0 on Windows 8.1 Enterprise java version "1.8.0_181" Java(TM) SE Runtime Environment (build 1.8.0_181-b13) Java HotSpot(TM) 64-Bit Server VM (build 25...

Answers: 3

Job scheduler

denodo installation folder location
answered 24-09-2018 10:18:34 -0400

we try to create a datasource to open denodo logfiles as a source within denodo, but not all denodo installations are in the same folders. Does denodo have any variable we can use in the configuration of this datasource to have the location of the inst...

Answers: 1

Delimited file data source variable

Sychronize error
answered 24-09-2018 04:48:55 -0400

A users on our team is trying to create a derived view in a database in Denodo is getting a 'A synchronize error has been found'. We found another post on this community and it says that we could get this message because two users are trying to create ...

Answers: 2

Denodo support for something like SQL EXECUTE AS function?
answered 24-09-2018 03:02:37 -0400

Hello, Does Denodo support some kind of impersonation feature like EXECUTE AS in SQL Server? This would allow a functional user to execute a query on behalf of another user. If Denodo doesn't support it through this kind of statement, does Denodo su...

Answers: 5

List all Derived views using a specific Base view
answered 20-09-2018 19:46:31 -0400

Hi, In Denodo , how can we list out all Derived views which are using a specific Base view ? In Denodo VDP admin tool, it is easy to find using option "Used by" .We are looking for the same option using some Denodo stored proc/command.

Answers: 1

base view

Denodo Cache Issue
answered 20-09-2018 04:40:51 -0400

Hi Team, Need your help to understand the below, how denodo 5.0 work for below senario. I have only one node for denodo development, we did our code development and I have full cache for tables "Employee" as C_Employee1234" in cache DB. I exported Dev...

Answers: 1

Two schemas to cache in one db
answered 19-09-2018 10:50:39 -0400

Can we configure two schemas in one database for caching data from two environments for example m trying to cache data from Dev n qa in one database using two different schemas ??

Answers: 1