Denodo community Q&A RSS feed https://community.denodo.com/answers//feed/rss Latest Denodo community answered questions Permissions and privileges need for source connection on source database https://community.denodo.com/answers/question/details?questionId=906Qj00000FabYHIAZ&title=Permissions+and+privileges+need+for+source+connection+on+source+database 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. Tue, 16 Jul 2024 13:06:24 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000FabYHIAZ&title=Permissions+and+privileges+need+for+source+connection+on+source+database 2024-07-16T13:06:24Z certification https://community.denodo.com/answers/question/details?questionId=906Qj00000FVybyIAD&title=certification when is denodo 9.0 certification launching ? Mon, 15 Jul 2024 13:54:52 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000FVybyIAD&title=certification 2024-07-15T13:54:52Z java.sql.SQLInvalidAuthorizationSpecException: authentication error: Insufficient privileges to connect to the database https://community.denodo.com/answers/question/details?questionId=906Qj00000FPR2oIAH&title=java.sql.SQLInvalidAuthorizationSpecException%3A+authentication+error%3A+Insufficient+privileges+to+connect+to+the+database 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 Fri, 12 Jul 2024 14:56:44 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000FPR2oIAH&title=java.sql.SQLInvalidAuthorizationSpecException%3A+authentication+error%3A+Insufficient+privileges+to+connect+to+the+database 2024-07-12T14:56:44Z How to determine the path to or the name of a view from the view itself? https://community.denodo.com/answers/question/details?questionId=906Qj00000FLNaUIAX&title=How+to+determine+the+path+to+or+the+name+of+a+view+from+the+view+itself%3F 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? Thu, 11 Jul 2024 15:47:19 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000FLNaUIAX&title=How+to+determine+the+path+to+or+the+name+of+a+view+from+the+view+itself%3F 2024-07-11T15:47:19Z Migrating views from Denodo V7 to V8 https://community.denodo.com/answers/question/details?questionId=906Qj00000FGw94IAD&title=Migrating+views+from+Denodo+V7+to+V8 Hi Team, How to compare the views between Denodo V7 and V8 & migrate the views from V7 to V8. Wed, 10 Jul 2024 14:35:02 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000FGw94IAD&title=Migrating+views+from+Denodo+V7+to+V8 2024-07-10T14:35:02Z Getting metadata of derived views https://community.denodo.com/answers/question/details?questionId=906Qj00000FGW8AIAX&title=Getting+metadata+of+derived+views 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? Wed, 10 Jul 2024 12:27:00 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000FGW8AIAX&title=Getting+metadata+of+derived+views 2024-07-10T12:27:00Z VDP external metadata configuration https://community.denodo.com/answers/question/details?questionId=906Qj00000FFfbhIAD&title=VDP+external+metadata+configuration Hi Team, We are planning to setup external metadata for VDP. due to huge elements getting more than 12 hours while importing the exported VQL to new external metadata (mysql). is there any way to speed up the process. can we directly export the derby metadata to mysql using etl tool or any other tools , Kindly suggest. Thanks Wed, 10 Jul 2024 06:02:40 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000FFfbhIAD&title=VDP+external+metadata+configuration 2024-07-10T06:02:40Z Specify Keystore alias in the SSL configuration https://community.denodo.com/answers/question/details?questionId=906Qj00000FBe9ZIAT&title=Specify+Keystore+alias+in+the+SSL+configuration Hello. I am configuring ssl/tls on my denodo installation, for this I use the script <DENODO_HOME>/bin/denodo_tls_configurator (https://community.denodo.com/docs/html/browse/8.0/en/platform/installation/postinstallation_tasks/enable_ssl_connections_in_the_denodo_platform_servers/denodo_tls_configurator_script#enable-ssl-tls-using-a-jks-keystore-and-public-certificates-in-cer-format). In my Java Keystore, there are several certificates including one for the server. My problem is that once SSL/TLS is enabled, the certificate used is the first available certificate in the keystore and not the one I used during the configuration, in other words, each of my keystores must contain only the server certificate. So I am looking for a solution to specify the name of the alias of the certificate to use. Thanks in advance. Tue, 09 Jul 2024 08:28:29 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000FBe9ZIAT&title=Specify+Keystore+alias+in+the+SSL+configuration 2024-07-09T08:28:29Z Connectors and storage services https://community.denodo.com/answers/question/details?questionId=906Qj00000F8eAwIAJ&title=Connectors+and+storage+services Hello all, how can I connect to denodo to azure ? what are the connectors available and what storage services in azure I can store the data? Thank you in advance. Mon, 08 Jul 2024 16:15:59 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000F8eAwIAJ&title=Connectors+and+storage+services 2024-07-08T16:15:59Z Migration to Microsoft Azure https://community.denodo.com/answers/question/details?questionId=906Qj00000F8io1IAB&title=Migration+to+Microsoft+Azure Is there any good documentation or links that details the approach of migration of Denodo to Microsoft azure ? What are the potential challenges and pitfalls,if there are any to be aware of? Thank you in advance. Mon, 08 Jul 2024 15:11:15 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000F8io1IAB&title=Migration+to+Microsoft+Azure 2024-07-08T15:11:15Z