Latest Activity

code

Create Base Views only from certain Snowflake databases

Hello, I used the Snowflake JDBC 3.13.1 Driver to connect to Snowflake from Denodo. When creating the data source i filled in values for the database, the chema and the warehouse in the Database URI (this is the pattern for the URI : jdbc:snowflake://...

base view snowflake database restriction

code

Getting Source Tables and Columns of a Datasource through Query

Hi Denodo team, Are there any queries to get all the tables in the datasource and also columns in a datasource for a specified table. I have seen that GET_SOURCE_TABLE() procedure is giving table but it takes view name as a parameter,but I don't want t...

JDBC query Database JDBC DataSource

code

Workaround for double quotes around database name in queries

I'm trying to see how I can configure my database to not need the double quotes around the database name when using queries in the VQL Shell. I realize there is a Restricted vs Unicode configuration that I think I've turned on, but I'm still having to ...

Denodo 8.0 double quote Vql shell Database unicode

code

itpilot database never got installed and is not installed when I view in the virtual data

The itpilot databases.never gets instaleld I logged into the virtual data port, but it is not there only administration db is there? How can I install the itpilot databases.? also when installing the user interace of denod is very small and cannot be ...

database ipilot installation Virtual DataPort

code

How to create self-referential data source?

Hello Denodo experts, I want to create a base view from query from a self-referential data source..how do I create this self-referential data source? Please advise. Thanks!

Database Baseview DataSource

code

Query two data sources(May be sql server and DB2 ) using Denodo Testing tool.

Is it possible to query two different data sources Can i join them in one query and get output? without help of linked server how can i query two different data sources and get single output. Eg Sql and DB2 or salesforces Thank you for help!

Denodo Testing Tool Database Data sources

code

Provide access to SINGLE view to MULTIPLE roles

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

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

code

Connect to data source

Hi, i would like to connect denodo to my local sql server 2014. I tried to set up for new data source but it fail to connect. Please help.

database Data Source

code

A synchronize error has been found

While creating a base view from database I'm getting this error "A synchronize error has been found"

database Denodo 6.0 Error synchonization

code

Compare between two schema or databases

Hi, Is there a smart way to compare two schema or databases using denodo itself? Fro Eg, I have two versions of the same database say DB_v1 and DB_v2. I have added few more functionalities or logic correction / modification on top of DB_v1.vql and cre...

database schema.sql tutorial