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.

Cloudera quickstart-vm-5.13.0-0-virtualbox with Denodo
answered 21-03-2018 08:45:14 -0400

Hi, I have Cloudera Quickstart-vm-5.13.0-0-virtualbox on Oracle Virtual Box in Windows 10 OS. I also have Denodo Express 6 installed. How do I connect the Hive database residing in the Virtual Box from Denodo?

Answers: 1

LDAP problem!
answered 20-03-2018 15:40:15 -0400

I have a LDAP data source. Connection is good and I see all object. If I make a base view I get the next error by execute. Error executing query. Total time 0.016 seconds. IAUSER [BASE] [ERROR] IAUSER [LDAP WRAPPER] [ERROR] IAUSER#0 [LDAP ROUTE] [E...

Answers: 2

wdsl data source
answered 20-03-2018 05:40:04 -0400

Error executing query. Total time 0.011 seconds. QUERY [PROJECTION] [ERROR] DV_WGS_SP_5YP_ADJUST [PROJECTION] [ERROR] DV_WGS_SP_5YP_ADJUST [SELECTION] [ERROR] BV_WGS_SP_5YP_ADJUST [BASE] [ERROR] BV_WGS_SP_5YP_ADJUST [WS WRAPPER] [ERROR] Received except...

Answers: 1

WSDL

Denodo available functionality or Capabilities
answered 19-03-2018 08:31:37 -0400

Hi Team, I am not sure how to do the below senario in Denodo, could you please help me out here, there is any functionality to impliment below requirement. expample: I have a table\view in DB as 'emp' data would be as below empid empname 100 A 200 B 30...

Answers: 1

Connecting Denodo to AWS Athena or AWS DynamoDB
answered 19-03-2018 08:10:25 -0400

Hi, Has anyone be able to connect to AWS Athena or AWS DynamoDB? There is already a question about connecting to Athena, but it is from May 2017. I am open to using third party drivers (CData, Simba etc.) if generic drivers will not work. Thanks!

Answers: 1

DynamoDB Athena

UNPIVOT et PIVOT
answered 19-03-2018 08:08:01 -0400

Bonjour, c'est vraiment dommage que Denodo ne prennent pas en charge les fonctions pivot et unpivot car ces fonctions sont pr├ęsentes dans plusieurs type de BDD sources: Oracle, SQL server, .... en effet, les m├ęthodes de contournement sont fastidieuse...

Answers: 1
Related to: How to Pivot and Unpivot views

unpivot Pivot

Trouble connecting to Webservice "http://localhost:8080/services/products-ws?wsdl".
answered 16-03-2018 09:06:55 -0400

Hi, I have recently started my training on Denodo 6.0 through video tutorials provided by Denodo. Currently doing the "Data Virtualiztion Developer Introduction - On demand" module. In the "DEN60EDU0108 - Data Sources. Web Services" chapter, Iam havi...

Answers: 1

Denodo , Stored Procedures, & Insert Updates
answered 15-03-2018 09:15:24 -0400

Have a questions, Why we need store procedures and insert update operations in Data Virtualization tool.

Answers: 1

Stored Procedures DENODO Insert Operation

Standardizing column names of several CSV files + converting date (text type to date type) and standardizing dates from several CSV files
answered 15-03-2018 08:34:01 -0400

Hello, here the situation: I have 2 CSV files with the following columns and 1 example row, Date,MachineNr,Situation,currTemperature,Responsible for parts 11-03-2018 10:00,1,Okay,100,dQ-5p-hd ... and Dat,MA,Status,currentTemperature,Makes 2018/03/1...

Answers: 1

Standardize column date

VDP Admin connection error
answered 14-03-2018 08:34:41 -0400

We are receiving an error when we try to logon using the client VDP Administration Tool. 5608 [AWT-EventQueue-0] ERROR 2018-03-13T15:57:03.754 com.denodo.vdb.admin.gui.components.connection.ConnectionPanel - Connection error:java.lang.NullPointerExcep...

Answers: 1