Denodo community Q&A RSS feed https://community.denodo.com/answers//feed/rss Latest Denodo community answered questions Is CREATE MATERIALIZED TABLE AS SELECT ? with Folder Location possible? https://community.denodo.com/answers/question/details?questionId=906Qj00000D8XtnIAF&title=Is+CREATE+MATERIALIZED+TABLE+AS+SELECT+%C3%A2%E2%82%AC%C2%A6+with+Folder+Location+possible%3F The example of a CREATE MATERIALIZED TABLE AS SELECT creates the table without issue, but places the base view in the root of the database folder structure. Is there a way to add the FOLDER literal to the CREATE MATERIALIZED TABLE AS SELECT execution? CREATE MATERIALIZED TABLE order_current_year AS SELECT * FROM order WHERE TRUNC(sale_date, 'YEAR') = TRUNC(CURRENT_DATE, 'YEAR'); Wed, 29 May 2024 21:46:52 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000D8XtnIAF&title=Is+CREATE+MATERIALIZED+TABLE+AS+SELECT+%C3%A2%E2%82%AC%C2%A6+with+Folder+Location+possible%3F 2024-05-29T21:46:52Z Encryption and Decryption in Denodo layer https://community.denodo.com/answers/question/details?questionId=906Qj00000D5lwUIAR&title=Encryption+and+Decryption+in+Denodo+layer Need to encrypt PII data in Denodo layer. Also, decrypt data when user who has necessary acces executes view. Could you please share the step by step process to achive this ? Wed, 29 May 2024 07:47:26 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000D5lwUIAR&title=Encryption+and+Decryption+in+Denodo+layer 2024-05-29T07:47:26Z Virtual DataPort using a JDBC data source. https://community.denodo.com/answers/question/details?questionId=906Qj00000CkMl1IAF&title=Virtual+DataPort+using+a+JDBC+data+source. . We have a company database which we can connect to from Virtual DataPort using a JDBC data source. Everything works fine, but we have detected a problem when using the function 'LOWER' in Virtual DataPort (the 'UPPER' function works correctly) when querying views over that data source. What should we modify in Virtual DataPort as a workaround for this problem? Wed, 22 May 2024 12:34:43 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000CkMl1IAF&title=Virtual+DataPort+using+a+JDBC+data+source. 2024-05-22T12:34:43Z How to escape special character in username field https://community.denodo.com/answers/question/details?questionId=906Qj00000Cc12cIAB&title=How+to+escape+special+character+in+username+field I'm setting up a JDBC connection to an Azure SQL database server. The problem I'm getting is when I enter the username which is in the format of an email address, then the @ character is interpreted by the JDBC connector as an indicator for the Hostname. How do I escape this character entered into the username field? ANSWER: I had to add authentication=ActiveDirectoryPassword to the connection string. Mon, 20 May 2024 10:29:26 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000Cc12cIAB&title=How+to+escape+special+character+in+username+field 2024-05-20T10:29:26Z Connect DataHub as a datasource in Denodo https://community.denodo.com/answers/question/details?questionId=906Qj00000CVpXBIA1&title=Connect+DataHub+as+a+datasource+in+Denodo Hi, Please advise on the steps to connect DataHub (https://datahubproject.io) as a datasource in Denodo. Thank you! Fri, 17 May 2024 14:05:10 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000CVpXBIA1&title=Connect+DataHub+as+a+datasource+in+Denodo 2024-05-17T14:05:10Z OAuth 2.0 API connection Issue https://community.denodo.com/answers/question/details?questionId=906Qj00000CVFtVIAX&title=OAuth+2.0+API+connection+Issue I have a GET URL, It was working fine with postman. When I trying to connect this Rest API to Denodo I have facing an error. like **Unable to establish connection: Connection refused** The Authentication type is OAuth 2.0 Authentication grant - Client credential grant Authentication method used by the authorization servers - Send client credentials using the HTTP Basic authentication scheme I mentioned Client ID, Client Secret, Access token, Token endpoint URL. As well as HTTP Headers also. Fri, 17 May 2024 10:39:25 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000CVFtVIAX&title=OAuth+2.0+API+connection+Issue 2024-05-17T10:39:25Z MFA https://community.denodo.com/answers/question/details?questionId=906Qj00000CTjyxIAD&title=MFA How do you setup the data source to use MFA authentication? Thu, 16 May 2024 21:27:43 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000CTjyxIAD&title=MFA 2024-05-16T21:27:43Z Import Materialized View Data Lineage in Denodo https://community.denodo.com/answers/question/details?questionId=906Qj00000C7daSIAR&title=Import+Materialized+View+Data+Lineage+in+Denodo We would like to import an Oracle MV dependencies into Denodo, do we have an design option here Below will give all the underlying references of the MV, and we wanted to import those underlying tables/views and associate to the final view, so that we have a tree view. Please advise a optimal auotmated design for this? ``` SELECT * FROM dba_dependencies WHERE owner = 'dts' AND name = 'CAT_MV'; ``` Thu, 09 May 2024 22:41:46 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000C7daSIAR&title=Import+Materialized+View+Data+Lineage+in+Denodo 2024-05-09T22:41:46Z how to create temporary tables in VQL Stored procedures https://community.denodo.com/answers/question/details?questionId=906Qj00000C5MqfIAF&title=how+to+create+temporary+tables+in+VQL+Stored+procedures Hi Denodo team, Could you please help me on creating temporary tables in VQL stored procedures with example if possible. **I am trying the save the below code but getting error saying** ***Error saving stored procedure: Syntax error: Exception parsing query near 'CREATE*'** (Program_Code IN VARCHAR,Source_Date_From IN DATE,Source_Date_To IN DATE) AS ( // Procedure variables ProgramCode VARCHAR;SourceDateFrom DATE;SourceDateTo DATE; ) BEGIN // Procedure body ProgramCode:=Program_Code; SourceDateFrom:=Source_Date_From; SourceDateTo:=Source_Date_To; CREATE TEMPORARY TABLE TempReq_Rep AS SELECT * from <base_view> left outer join <dervied view> on <join fields> where ( program_code in (Select Value from split (Program_Code,',') ) AND status IN ('A', 'O', 'P') AND nstatus NOT IN('X') AND (source_date >= SourceDateFrom AND source_date <= SourceDateTo) ); END; Your help is much appreciated Thu, 09 May 2024 13:53:58 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000C5MqfIAF&title=how+to+create+temporary+tables+in+VQL+Stored+procedures 2024-05-09T13:53:58Z Trying to connect to datahub api https://community.denodo.com/answers/question/details?questionId=906Qj00000C5Ga1IAF&title=Trying+to+connect+to+datahub+api I am trying to create a datasource via REST APi call to datahub , but gettinbg connection error , CAn anyone please suggest me any way and what all filetrs need to give? Thu, 09 May 2024 13:06:17 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000C5Ga1IAF&title=Trying+to+connect+to+datahub+api 2024-05-09T13:06:17Z