Q&A

Interpolation of function and variable.
answered 26-09-2018 08:27:23 -0400

I have a connection to an Oracle database. In the connection we set up several Driver Properties including the user name which the database uses to pull only the rows the user executing the query has access to (row security). That property is set up l...

Answers: 1

Function Interpolation Variables oracle

Denodo Cache issue in Denodo 5.0 vs 6.0
answered 26-09-2018 05:07:42 -0400

Hi Team, We need your clarification here, how Denodo create Cache Table in Cache DB, below is the my question: we are using Denodo 5.0 now and migrating code into 6.0. here, we have a view in Denodo 5.0 it is full cached (oracle is Cache DB). just exam...

Answers: 1

When trying to use the concat function, I get an error saying that it is not a recognized built-in function name.
answered 26-09-2018 00:16:31 -0400

When trying to use the concat function, I get an error saying that it is not a recognized built-in function name. Below is a sample script that gives the same error. SELECT t1.api_no14 PID, t1.automation_name WELL_NAME, t2.CREATE_DATE COMMENT_DATE, t2...

Answers: 1

Hive connection issue with Denodo VDP
answered 25-09-2018 23:15:12 -0400

Hi Team, Product Name: Virtual DataPort 7.0 (Express) Hive Version: Hive v1.1.0 CDH (Cloudera Distribution Hadoop): v 5.13.0 Database Adapter : Hive 2.0.0 (HiveServer2) Driver Class path : 'hive-2.0.0' Driver Class : org.apache.hive.jdbc.HiveDriver D...

Answers: 1

Denodo and Hive

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