Home / Q&A / All Questions

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.

How Homeland Security and Defense department is utilizing the Denodo?
answered 20-04-2018 07:00:32 -0400

I would like to know how Homeland Security and Defense department is utilizing Denodo? Please provide a white paper if you have. Thanks

Answers: 1

DENODO

Primary Key Must?
answered 20-04-2018 03:34:45 -0400

Hello, Does Denodo require primary key on all views even if it is not defined on source system? If yes, Why? What benefits it offer. Thanks, Adinath

Answers: 1
Related to: Denodo Query Optimizations for the Logical Data Warehouse

primary keys

Giving read Grants
answered 19-04-2018 11:40:09 -0400

Hi team, If some one asks for read access for the particular view in VDP instance, how can we give the access to that specific user ? Is there any process?

Answers: 1

Exporters column mapping
answered 19-04-2018 11:40:07 -0400

Our source, a base view with the following SQL: SELECT ID*10+2 AS EDIT_ID, ID, Attr1, Attr3 ... Attr130 FROM TABLE_A We want to write some of its columns to two tables, and use the mapping to link certain columns The first exporter is to a table wit...

Answers: 1

Scheduler Denodo Scheduler 6.0 parameter mapping

connect to mysql using JDBC Driver in RedHat Linux
answered 19-04-2018 08:36:29 -0400

Dear Sir, I have MYSQL in Linux Enviroment and Denodo installed in the Linux Environment. What is the JDBC driver class for connect to MySql database via Denodo tool. Regards, Senthil

Answers: 1

JDBC

unable to establish connection: com.mysql.jdbc.driver
answered 19-04-2018 07:29:02 -0400

Folks, I would appreciate some help with connecting to the data sources for the tutorial. I get the error "unable to establish connection: com.mysql.jdbc.driver" So far, I downloaded the the jconnector MSI in the Denodo bin folder and ran it. The drive...

Answers: 2

connection

Send Derived View output to SFTP/FTP Server
answered 19-04-2018 02:00:01 -0400

Hi Team, If I want to transfer a derived View outout I was told to create a “Custom Handler” to open an FTP connection and transfer the file to the corresponding location. So below are the steps, •Create a job of type ‘VDP’ in Scheduler Administration ...

Answers: 1

PostgreSQL Data Movement Error
answered 19-04-2018 01:44:24 -0400

At present, I’m consuming data from a PostgresDB and looking to write to another PostgresDB using the below statement, however it returns an error stating the ‘Virtual Data Port does not support data movements to data source’ and lists a number of supp...

Answers: 2

Data Destination Data Source PostgreSQL Data Movement

Reading from Kafka
answered 19-04-2018 00:13:44 -0400

We are valuing tools to catalogue assets from streaming data sets as Kafka. Could be a solution this architecture?: Kafka - PrestoDB - Denodo catalogue I have seen in the whitepaper that Denodo 7.0 can read effectively Kafka messages. Could you kind...

Answers: 1

denodo vsql
answered 18-04-2018 11:46:34 -0400

How Can i query the real datatype of derived view ? as querying catalog it shows timestamp and varchar2 but in real those are date and text.

Answers: 1