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 September 2019.

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.

order of fields in Information self service tool
answered 24-10-2019 08:01:54 -0400

Hi Team, I'm facing issue with Information self service tool. When i query a view in isst, it displays the fields in alphabetical order and not as order in view. for example, i have a derived view dvtest which has fields a, d, c, b in same order. when...

Answers: 3

Information self service tool ISST

Error: Received exception with message 'Incorrect syntax near the keyword 'into'
answered 24-10-2019 07:34:00 -0400

Select * into #Temp from xyz Select * from #Temp When I run this Script using Create Base view from Query, I am getting the below error message. Error: Received exception with message 'Incorrect syntax near the keyword 'into' MS SQL Server 2014 JDBC...

Answers: 1
Related to: Best Practices for Migrating SQL queries to Denodo VQL

into clause MSSQL

Restricting / slice of data to be accessed from denodo views
answered 24-10-2019 07:10:02 -0400

we would like to ensure that only a specified time interval data ( say 10 days of data) can be retrieved from denodo views. assuming that table has time series data l. we would like to accept only those queries which are selecting data within specified...

Answers: 1

custom policy data security data restriction

Denodo Data catalog issue
answered 23-10-2019 08:37:52 -0400

hi Team, I am getting below after installation Denodo.Updated only VDBconfiguration.properties . Please help me the data catalog is not getting up 22-Oct-2019 18:29:07.819 WARNING [main] org.apache.catalina.startup.SetAllPropertiesRule.begin [SetAllPr...

Answers: 1

data catalog

[Teradata Database] [TeraJDBC] [Error 3706] [SQLState 42000]
answered 23-10-2019 08:36:26 -0400

I am trying to create a Denodo base view from an already developed Teradata view used in Tableau TDE. THe same query executed fine in Teradata, but give the below error while I try to create a base view from query n Denodo. com.denodo.util.exceptions....

Answers: 1

Denodo Teradata

Data Catalog tomcat issue
answered 23-10-2019 08:32:46 -0400

Hi Team, Our embedded tomcat has some issues. Could you please help us 22-Oct-2019 13:52:26.278 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=/opt/denodo/resources/apache-tomcat 22-Oct-2019 ...

Answers: 1

data catalog

Unable to connect to the database: Access denied for user 'acme_user'@'localhost' (using password: YES)
answered 23-10-2019 08:24:22 -0400

I am trying to import a database by following the steps in the tutorial. I am getting the following error while adding a new data source. Can someone help with this? Thanking in anticipation.

Answers: 1

best way to create a scheduler job to throw exception if a table has records in it
answered 23-10-2019 08:07:25 -0400

Hi Sorry if this is covered in some example docs but i've not found anything that really helps with what i'm looking for. Can you provide an example of how to create a scheduled job that will throw an error if the extraction sql query returns record...

Answers: 3

Job scheduler

Denodo data catalog Internal Database Configuration Missing
answered 23-10-2019 05:54:09 -0400

Hi Team, I am not able to find the internal database configuration option denodo after login as admin. I have full privliagesto setup one.I want to configure mysql Please help me

Answers: 1

Denodo Internal Database Configuration

Query Simplification
answered 22-10-2019 09:05:11 -0400

Hello, I have a scenario where I need to "Simply a Query" based on selection. For example I have two base views, first one named "bv_first_view" (with field names - id, name, age, address) , second base view named "bv_second_view" (with field names - ...

Answers: 4

DB2 Query Simplification