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 April 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

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

Cannot Connect to training Oracle database
answered 20-03-2018 06:48:37 -0400

I am following along the developer basic traing. But got stuck while connecting to oracle data-server. The error i'm getting is: Unable to establish connection: IOError: The network adapter could not establish connection. The database URI: ...

Answers: 6

JDBC Data Sources training Oracle 11g

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

Python SQLAlchemy and connecting to Denodo
answered 19-03-2018 00:39:33 -0400

Has anyone had any luck in connecting to Denodo via SQLAlchemy (ORM for Python)? Are there any python drivers that with both SQLAlchemy and Denodo? For example, I am able to run queries against Dendo using Python's Psycopg2 driver. However when I try...

Answers: 1

SQLAlchemy Python

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