Q&A

Load metadata in Denodo Data Catalog
answered 01-09-2020 05:54:56 -0400

Can you let me know if there is any way I can use a excel file to upload the metadata about the view i.e., lets assume I need to add column description for more than 50 columns in a base view, then can that be done via Excel file loading

Answers: 1

#Metadata Loading

python to run vql shell (select , create view, desc view)
answered 31-08-2020 07:20:47 -0400

Hi Team, I am using python to connect Denodo ad want to run some vql, I am using JDBC connection to connect denodo with python library "jaydebeapi", when I ran some select vql query, it works. But I encounter below two problems, can you help check: ...

Answers: 1

vql shell python create view desc view

Cannot connect to Denodo Virtual port administration
answered 28-08-2020 07:58:04 -0400

Cannot connect to Denodo Virtual port administration after installing denodo express 8.0. Also, VDP server is always running.Not stopping if try to stop VDP server and throwing error "Internal error"

Answers: 1

Access Denodo Express

Dropping folders/views (Access Control)
answered 28-08-2020 07:52:13 -0400

if a user is given the create folder privilege, is he/she allowed to modify/drop folders that are not owned by the user? or is modifying and dropping limited to folders created/owned by the user.

Answers: 1

Dropping Folders (Access Control Privileges)

Database URI in metadata table ?
answered 27-08-2020 08:14:46 -0400

There are many datasources scattered across multiple denodo databases. I would like to get the DATABASEURI for all these daa sources present across multiple Denodo databases. I can extract the databaseURI manually by executig the below DESC command. ...

Answers: 1

DATABASEURI

Denodo - ER Studio Integration
answered 27-08-2020 06:41:15 -0400

Hi, Is there a way to pull the Denodo Tree view from VDP to ER Studio or any other tools. I know ER Studio models can be pushed to Denodo VDP through Denodo Model Bridge, but is the opposite possible? Thanks, -Sameer

Answers: 1

Data Modeling

Port forwarding for AWS instance
answered 27-08-2020 03:07:36 -0400

I have enabled port forwarding for the port 9999 of denodo instance residing in AWS to my localhost 8888, and using the local denodo client. I am getting "connection timed out" error. Parallely I have enabled for mysql port 3306 to 3309 as well and I...

Answers: 1

putty Port forwarding AWS tunnel

Unable to Connect to VDP via ODBC drivers
answered 27-08-2020 02:16:14 -0400

Hello - I am able to connect no problem via JDBC to VDP (tutorial example). ODBC is not working and getting the below error in configuring the DNS. I am running everything locally on Windows. My ports are all defaults and VDP admin console shows por...

Answers: 1

Denodo 8.0 ODBC Denodo Express

PowerBI Dataset
answered 25-08-2020 07:38:22 -0400

Good Day, The data that I need Denodo to access is a PowerBI Dataset. Can you please assist with the connection settings for this. Regards, Kaashief

Answers: 1

Sign in to Data Catalog
answered 25-08-2020 02:48:57 -0400

Hi, Team, It's my first time to sign on to Data Catalog. Data Catalog is running and I used admin and admin to log in. The "Sign In" button is grey. Does that mean I don't have access for some reason? or I am missing some steps? Thanks Ming

Answers: 3

Data Catalog first time ever