Q&A BY TAG 'Database'
Workaround for double quotes around database name in queries
answered
16-02-2021 11:48:05 -0500
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 ...
Answers:
1
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
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
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
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
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
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
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
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