Q&A BY TAG 'Database'

You must sign in to ask a question. If you do not have an account, you can register here

Getting Source Tables and Columns of a Datasource through Query
answered 14-10-2020 06:23:36 -0400

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

Answers: 1

JDBC query Database JDBC DataSource

itpilot database never got installed and is not installed when I view in the virtual data
answered 06-04-2020 16:13:55 -0400

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

Answers: 1

database installation ipilot Virtual DataPort

How to create self-referential data source?
answered 06-12-2019 15:28:28 -0500

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!

Answers: 1

Database Baseview DataSource

Query two data sources(May be sql server and DB2 ) using Denodo Testing tool.
answered 13-11-2019 13:04:34 -0500

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!

Answers: 1

Denodo Testing Tool Database Data sources

Provide access to SINGLE view to MULTIPLE roles
answered 05-11-2019 08:54:33 -0500

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: 3

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

Connect to data source
answered 24-01-2019 13:00:05 -0500

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.

Answers: 1

database Data Source

A synchronize error has been found
answered 09-05-2018 06:34:16 -0400

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

Answers: 1

database Denodo 6.0 Error synchonization

Compare between two schema or databases
answered 04-05-2016 11:06:57 -0400

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

Answers: 1

database schema.sql tutorial

Denodo Databases
answered 29-06-2015 07:32:27 -0400

Hi, I am confusion with the databases used in denodo.Can you explain me in detail.How these databases will be useful. 1) server uri://host:port/database where database is the virtual data port database.What abt this database refer? 2)Apache derby da...

Answers: 1

database