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.

Delegate operation minus to the source
answered 13-07-2018 09:59:35 -0400

Hello I have two views derived from the same source, I do a minus operation between them and the operation is not delegated to the source. Can this operation be delegated to the source? I'm using denode 7.0

Answers: 1

Truncate and Drop Data Movement tables from Cache database
answered 13-07-2018 04:37:13 -0400

Hello, How do I remove (Truncate then Drop) the Data Movement tables that have been created in the Cache database? These tables were created - in my example, MySQL - when I had clicked on the Data Movenment option in the Derived View Execution Plan. I...

Answers: 1

data movement tables Cache

Connecting to Twitter
answered 13-07-2018 04:17:04 -0400

Hi Team, Am wondering can we connect/get twitter data using denodo platform. Is there any reference document? Am working on some usecases to connect to any social media website using denodo. FYI,am using a licensed version of denodo. Thanks in advan...

Answers: 1

#HTTP #Post #Rest_API #webservice

RMI HOST setting error
answered 13-07-2018 03:24:22 -0400

HI Team While peroforming RMI Setting on LInux server I did below stpes . Intsalled Denodo 7.0 using below commands cd denodo-install-7.0/ chmod +x installer_cli.sh ./installer_cli.sh install Then I have Edited the file <DENODO_HOME>/...

Answers: 1

installation

Unable to establish connection: CLIENT_PLUGIN_AUTH is required
answered 12-07-2018 17:39:35 -0400

while connecting to MYSQL,when we test the connection it is givving following error- 'Unable to establish connection: CLIENT_PLUGIN_AUTH is required' What needs to be done to resolve thos issue.

Answers: 1

How to convert Julian date YYYYJJJ into YYYYMMDD
answered 12-07-2018 13:01:54 -0400

Hi I'm looking for a way to convert Julian date to yyyyMMdd format in Denodo. I couldn't find any reference to Julian date in Help. Appreciate your fast response. Thanks, Sathish Manthani

Answers: 2

#date #conversion #formatdate

Getting error Finished with error: Error deleting content for database <db_name> :Unknown column 'rowStatus' in 'where clause'
answered 12-07-2018 08:44:12 -0400

Hi, When I call the CALL CLEAN_CACHE_DATABASE stored procedure for a partiular database, I am getting the following error: Finished with error: Error deleting content for database &lt;db_name&gt; :Unknown column 'rowStatus' in 'where clause' I had Ca...

Answers: 1

CALL CLEAN_CACHE_DATABASE

data fabric
answered 12-07-2018 08:34:39 -0400

I want to explore and want to know how data fabric available in Denodo 7 is going to help users. We are relying mostly on snowflake as data source to fetch large amount of data, and hundreds of views are created on top of this source and other source s...

Answers: 1

data fabric

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