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 April 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

I want to connect with service now problem management tool
answered 01-03-2017 05:23:11 -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 ...

Answers: 1

user creation automation
answered 27-02-2017 12:53:38 -0500

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

Answers: 1

Role and User Management

Webservice and scheduler
answered 27-02-2017 05:48:31 -0500

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

Answers: 1

#Scheduler

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 BY...

Answers: 3

view WITH

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 erro...

Answers: 1

MYSQL

Check all VQL running on database/host
answered 23-02-2017 04:42:59 -0500

Is there a way to check what all queries are running on host other than using the Monitoring & Diagonstic tool?

Answers: 1

monitor

POC for accessing pdf from local computer
answered 23-02-2017 04:21:14 -0500

Hello Team, My requirement is to read data from PDF file which is in local computer and load into a table with structure Question : I'm trying to create a Datasource by Acarne, asking for Host name, port number, login and password. Except Host name,...

Answers: 1

Query seems to be ignoring sql table clustered index
answered 22-02-2017 23:36:20 -0500

I have a base view pointing to a single MSSQL table. The table has a clustered index. The table has approximately 6 million rows in it. When I run the query from DBeaver using a simple where clause I get the same expected result as when I run the quer...

Answers: 1

Ignoring Index MSSQL DBeaver