Denodo community Q&A RSS feed Latest Denodo community answered questions Denodo as master data management or data cataloging tool 2024-07-23T15:22:39Z 2024-07-23T15:22:39Z Hi Denodo experts, can we use Denodo as master data management or data cataloging tool in the paradigm of Azure cloud. Does it have Azure purview or MDM capabilities? if it does to what extent or any data size restrictions? 2024-07-23T15:22:39Z ADLS connect to Denodo 2024-07-23T11:33:21Z 2024-07-23T11:33:21Z Hi All, since Denodo is virtualisation layer and only has views not data , my question is how ADLS connect with Denodo views and fetch the data . Please provide detailed stepwise approach. 2024-07-23T11:33:21Z Permissions and privileges need for source connection on source database 2024-07-16T13:06:24Z 2024-07-16T13:06:24Z Hello - we are new to Denodo. I'm looking for documentation or direction on permissions and privileges needed at the source database level when connecting. We will have both source Oracle and SQLServer. Other than read only? Create temp table? Reading the internal tables for stats, etc.? This is for source connection only. Not referring to the Denodo databases. TIA. 2024-07-16T13:06:24Z add comments in vql of view 2024-07-16T04:26:58Z 2024-07-16T04:26:58Z hi team, how to add comments in vql of view. Thanks please update 2024-07-16T04:26:58Z certification 2024-07-15T13:54:52Z 2024-07-15T13:54:52Z when is denodo 9.0 certification launching ? 2024-07-15T13:54:52Z Automation of importing jar files 2024-07-14T13:16:45Z 2024-07-14T13:16:45Z I want to automate importing a jar file from my pc to denodo server using a python script..is that possible? 2024-07-14T13:16:45Z java.sql.SQLInvalidAuthorizationSpecException: authentication error: Insufficient privileges to connect to the database 2024-07-12T14:56:44Z 2024-07-12T14:56:44Z Hi I am trying to connect to Denodo from Databricks - Code snippet below pushdown_query = "select * from dbname.view" denodo_table = (spark.read .format("jdbc") .option("url", "jdbc:vdb://<server-name>:9999/dbname") .option("query", pushdown_query) .option("user", "XXXXXX") .option("password", "XXXXX") .option("driver","com.denodo.vdp.jdbc.Driver") .option("sslTrustServerCertificate","true") .load() **Driver on Databricks cluster is** - denodo-vdp-jdbcdriver-8.0-update-20220815.jar **VDB server version** is - Denodo Virtual DataPort Server 8.0 20230301 hotfix 20230828 **Error is - ** - java.sql.SQLInvalidAuthorizationSpecException: authentication error: Insufficient privileges to connect to the database **PS - i can connect to the VDB using the Design Studio directly using the same user/pwd combo and select from dbname.view just fine** Any help or guidance on the issue is appreciated 2024-07-12T14:56:44Z How to determine the path to or the name of a view from the view itself? 2024-07-11T15:47:19Z 2024-07-11T15:47:19Z It is possible to determine the name of the view of its path from view itself? GET_VIEW() is a goed tool, but it needs the name of the view to filter information. as example: Database1 -- Folder_AA ---- view_AA = `select av1.col1, RIGHT(<determine_path_or_view_name>,2) as col2 from another_view av1` => where <determine_path_or_view_name> is a procedure or function or something else that returns path `/Database1/Folder_AA` or name `view_AA`. As result, col2 will contain `AA` -- Folder_BB ----- view_BB = `select av1.col1, RIGHT(<determine_path_or_view_name>,2) as col2 from another_view av1` => col2 will become `BB` -- Folder_CC ----- view_CC = `select av1.col1, RIGHT(<determine_path_or_view_name>,2) as col2 from another_view av1` => col2 will result in `CC` Any idea? 2024-07-11T15:47:19Z Migrating views from Denodo V7 to V8 2024-07-10T14:35:02Z 2024-07-10T14:35:02Z Hi Team, How to compare the views between Denodo V7 and V8 & migrate the views from V7 to V8. 2024-07-10T14:35:02Z Getting metadata of derived views 2024-07-10T12:27:00Z 2024-07-10T12:27:00Z I have a task to get metdata of (derived view) not (a base view) in denodo to my python code but this derived view contains many arrays and registers..when i use DESC VIEW and GET_TYPE_ATTRIBUTES() in my python code.. it only returns the columns names and types without the nested coulmns in the registers and arrays..I want they to return also..How can i do that? 2024-07-10T12:27:00Z