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

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

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

Dockerized deployment?
answered 13-03-2018 13:06:39 -0400

It seems that there is no Denodo support for dockerized deployment, no mention of it in the documentation... is that the case?

Answers: 3

Docker

Docker deployment licensing
answered 13-03-2018 12:51:01 -0400

Hello Denodo Team! What is your licensing model for deployment in Docker container? Can a dockerized instance be spun of the existing enterprise license, or would it need its own license?

Answers: 1

Docker