Denodo community Q&A RSS feed Latest Denodo community answered questions 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 VDP external metadata configuration 2024-07-10T06:02:40Z 2024-07-10T06:02:40Z 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 2024-07-10T06:02:40Z Specify Keystore alias in the SSL configuration 2024-07-09T08:28:29Z 2024-07-09T08:28:29Z Hello. I am configuring ssl/tls on my denodo installation, for this I use the script <DENODO_HOME>/bin/denodo_tls_configurator ( 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. 2024-07-09T08:28:29Z Connectors and storage services 2024-07-08T16:15:59Z 2024-07-08T16:15:59Z 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. 2024-07-08T16:15:59Z Migration to Microsoft Azure 2024-07-08T15:11:15Z 2024-07-08T15:11:15Z 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. 2024-07-08T15:11:15Z DENODO DEMO LITE 2024-07-05T13:59:06Z 2024-07-05T13:59:06Z We are a partner and i am preparing the DEMO LITE environment. I Downloaded the Denodo Platform and Solution Manager 8 (LINUX), and also the objects for the DEMO LITE environment like VM and Metadata Zip files. When I started to import files, i got a 57 erros importing the file **DenodoDemoLiteVM_vdp_09302022**. My first question is about the compatibility between DEMO files and Denodo 8 version of Platform and Solution Manager. Second, may i open a ticket in Denodo support for this ? This is the first error reported : Command #14: CREATE OR REPLACE TAGS (pii_address DESCRIPTION = 'Address Information', pii_credit_card_cvv DESCRIPTION = 'All columns with credit card number verfication value', pii_credit_card_number DESCRIPTION = 'All columns with credit card numbers', pii_phone DESCRIPTION = 'All columns containing phone numbers for 2 factor authentication', pii_verification_email DESCRIPTION = 'All columns containing emails for 2 factor authentication') QUERY ERROR 2024-07-05T13:59:06Z Data source connection 2024-07-05T07:07:49Z 2024-07-05T07:07:49Z Hi I wanted a create a data source connection for Banner Ellucian. How can i create this connection in denodo 2024-07-05T07:07:49Z data source connections for Oracle Fusion (Cloud) instance 2024-07-05T07:05:15Z 2024-07-05T07:05:15Z Hi I wanted to know How i can Create data source connections for Oracle Fusion (Cloud) instance 2024-07-05T07:05:15Z