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 updated version of the Denodo Express 6.0 with new features and issues fixed starting in September 2016.

If you want to try it or if you want to update your current Denodo Express version you can download the brand new Denodo Express 6.0 at the Express home page in the Denodo Community

View Parameters and Aggregation
asked 24-02-2017 14:50:23 -0500

I am fairly new to Denodo and I have read through the Advanced VQL and VDP Administration Guide but I am not able to resolve the following issue: Sample Base View For the sake of this issue, let's consider a base with student, months and rank. STU...

Answers: 0

parameter derived view Aggregate

user creation automation
asked 24-02-2017 10:08:11 -0500

Hi Team, Is there any way to automate the user creation activity in VDP, other than VDP admin tool option.

Answers: 0

Role and User Management

Fetch plan of the query cache
answered 24-02-2017 09:32:19 -0500

Hello. I work with a cache for views. And faced with strange behavior. When I am disabled the cache for a view, the execution time amounted ~50ms. When I am enabled partial cache, the execution time amounted ~400ms. I need opportunities for fetching pl...

Answers: 2

execution plan cache

Scheduling Jobs in Denodo using BMC Contol-M (without using the Denodo Scheduler)
answered 24-02-2017 03:31:00 -0500

I am using Version 6.0 (update 12192016) on RedHat Linux. I need to use Control-M with Denodo - to run jobs in Denodo to populate the Cache engine tables. Can I use ODBC to connect from Control-M to to Denodo to run VQL scripts to run Base/Derived View...

Answers: 1

Denodo Scheduler 6.0 wrapper contol-M

Unable to connect to SQL Server 2012
answered 23-02-2017 23:04:02 -0500

I've reviewed and gone thru the steps noted in this article -- https://community.denodo.com/kb/view/document/Security/Accessing%20MS%20SQL%20Server%20using%20Windows%20Authentication Errors persist and not able to generate a data source -- variations ...

Answers: 5

How to use "WITH" clause query using temporary tables to create a view in DENODO
answered 23-02-2017 11:58:26 -0500

I am trying to create a view using the query which is having WITH clause for temporary table but getting syntax error.. please help me asap. ex: WITH dept_count AS ( SELECT deptno, COUNT(*) AS dept_count,ROW_NUMBER() OVER(PARTITION BYdeptno ORDER B...

Answers: 3

view WITH

Webservice and scheduler
asked 23-02-2017 10:43:12 -0500

How to check if web service is up and running from scheduler?

Answers: 0

#Scheduler

I want to connect with service now problem management tool
asked 23-02-2017 10:18:37 -0500

Hi I am using denodo 5.5 and i wanted to fetch couple of records from service now like incidents and their comments and outages details and i wanted to fetch this reocrds into denodo database. Please let me know if we do have any adapter for this or h...

Answers: 0

Code promotion: updating views from one environment to another
answered 23-02-2017 05:44:05 -0500

HI, I need to migrate/promote multiple views from my Developmet environment to Testing environment, what is the easiest way to do it? Both the environments are on different server.

Answers: 1

code migration

Issues connecting to a MSQL Data Source
answered 23-02-2017 05:09:53 -0500

I am have issues connecting to a MYSQL data source. I am using " mysql-connector-java-5.1.40\ " driver along with "com.mysql.jdbc.Driver" Connection is local : jdbc:mysql://localhost:port- (assigned port) /dbname - ( My dbname). I keep getting the...

Answers: 1

MYSQL