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

PowerBI Direct Query
answered 12-07-2018 08:26:20 -0400

Currently Denodo can be queried from Power BI over ODBC. Does Denodo have a Power BI connector to support Direct query. Direct Query is useful when working on large datasets and it does not make sense to import data in Power BI (ODBC).

Answers: 3

How to deploy entire Denodo DB (with BV, DV and REST APIs) into Staging from Development environment?
answered 12-07-2018 08:05:08 -0400

There are 3 environments Development, Staging and Prodicution. I have created a database with multlple base, dervied views and REST APIs. These views are created out of MS SQL Server database. I would like to deploy entire Denodo DB into Staging envior...

Answers: 1

deployment deploy

Kerberos in Denodo Express
answered 12-07-2018 07:55:05 -0400

I am creating a lab with virtualbox and a domain server. I'd like to know if I can configure Denodo Express to work with Kerberos. Would it work with just one "admin" account? Thanks!

Answers: 1

Kerberos Denodo Express

Running COMPACT_METADATA_TABLES(compaction_type: 0) fails with "Syntax error: Exception parsing query near 'COMPACT_METADATA_TABLES'"
answered 11-07-2018 11:38:06 -0400

I am trying to run COMPACTMETADATATABLES after following https://community.denodo.com/docs/html/browse/6.0/vdp/vql/storedprocedures/predefinedstoredprocedures/compactmetadatatables using the below command but it fails, please help in givivng the correc...

Answers: 1

COMPACT_METADATA_TABLES

Why not no sql as well?
answered 10-07-2018 08:17:05 -0400

Neo4j has deprecated their rest api and has a jdbc driver that denodo can connect to. Why not let us create views from cypher queries? I'd rather have no validation than no functionality.

Answers: 4
Related to: Using the Create Base View From Query Option

NEO4J / JDBC / Connection JDBC Data Sources nosql

Denodo ODBC driver is causing ODBC msc to crash suddenly
answered 09-07-2018 07:19:06 -0400

Out of the blue, Denodo ODBC driver is causing the ODBC msc to crash when I attempt to open a previously created or to add a new Denodo ODBC System DSN. Have other's experienced this as well?

Answers: 1

ODBC

Connect Essbase to denodo connection
answered 09-07-2018 07:13:37 -0400

how to connect from Essbase to denodo connection. Will it be similar like connectiong to databade? and what will be the connection string

Answers: 5

How to use an attribute in the restful xml service?
answered 09-07-2018 05:24:35 -0400

Hello I know how to publish a xml service but not how to move a xml element to attribution, May I know how to do in Denodo? For example, From: <v_product> <product_id >1</product_id> <name>football></name> <month_...

Answers: 1

How to add an attribute in the restful xml service?
answered 06-07-2018 18:32:43 -0400

Hi, I would like to explose below xml , how to do in Denodo? <v_product> <product_id name="football">1</product_id> <month_id>201806</month_id> </v_product>

Answers: 3

REST API

Is it a Denodo bug when publish a parent-child view to a xml restful service
answered 06-07-2018 17:11:27 -0400

Hello I combine two views into a parent-child view and publish it to a xml service, like fund_code_list ->fund_price_items. However, I do not find the fund_code_list element in the xml result. Could you please help on it?

Answers: 1

REST API