Q&A

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

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