Q&A

Base View date field is populating incorrect format
answered 23-10-2019 19:12:57 -0400

Hello, We have a base view that is populating a date field incorrectly. The date field should be populated under the format of date time with the time being zeros (example Tue Jul 29 00:00:00 EDT 1947) , however for a number of recrods we are seeing Tu...

Answers: 1

datetime locale date field

Where can I access the Update files for download to Denodo 7.0 Express?
asked 23-10-2019 16:48:13 -0400

I've installed Dendo 7 express but I now need to update to 201903122200.

Answers: 0

patch upgrade Access Denodo Express

Configuring internal database leads to login error
asked 23-10-2019 15:44:02 -0400

When I try to configure the internal database for Denodo in the Data Catalog, every time I restart the Data Catalog there is a login error that comes up saying " unknown column 'search_description' in 'field_list' ". I am using mysql5, have put the jdb...

Answers: 0

Denodo Internal Database Configuration data catalog

Error: Received exception with message 'Incorrect syntax near the keyword 'into'
asked 23-10-2019 15:11:24 -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: 0
Related to: Best Practices for Migrating SQL queries to Denodo VQL

into clause MSSQL

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 16.20.00.12] [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

Provide access to SINGLE view to MULTIPLE roles
answered 23-10-2019 08:31:09 -0400

Hello team, As we know, in Denodo we can give a view level access for a role. I have a situation where I need to give access to a SINGLE view to MULTIPLE roles(around 30). The procedure is to select each role, click on edit in the database and give wh...

Answers: 2

Denodo stored procedure database assign privilages Base View descrptions Access and Role Stored Procedure VQL Role Role and User Management Roles Users

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