Denodo community Q&A RSS feed https://community.denodo.com/answers//feed/rss Latest Denodo community questions Hiding columns that users cannot execute https://community.denodo.com/answers/question/details?questionId=906Qj00000B4zMjIAJ&title=Hiding+columns+that+users+cannot+execute I have implemented column level security on a view. As expected when the restricted uers executes select * from the view they get an error message that says that they do not have privileges on certain columns. However, the user can see the columns that they do not have access to. Is there a way to prevent the user from seeing the columns that they do not have access to? Fri, 19 Apr 2024 16:24:35 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000B4zMjIAJ&title=Hiding+columns+that+users+cannot+execute 2024-04-19T16:24:35Z Returning a Select Statement in a VQL Stored Procedure https://community.denodo.com/answers/question/details?questionId=906Qj00000B3xLPIAZ&title=Returning+a+Select+Statement+in+a+VQL+Stored+Procedure Hi everyone. Simple question here. I want to create a VQL Stored Procedure that returns a Select Statement, how do I do it? I have searched through the Denodo documentation for this but haven't found any reference about it. Thanks in advance Fri, 19 Apr 2024 16:01:32 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000B3xLPIAZ&title=Returning+a+Select+Statement+in+a+VQL+Stored+Procedure 2024-04-19T16:01:32Z Vdp-queries log generation https://community.denodo.com/answers/question/details?questionId=906Qj00000B3fmfIAB&title=Vdp-queries+log+generation Hello Team, We are aware that Denodo logs are produced in two directories: DENODO_HOME/logs/vdp and DENODO_HOME/tools/monitor/denodo-monitor/logs (when Denodo Monitor is running). The file "vdp-queries.log" exists in both locations mentioned above. However, vdp-requests.log is only generated in the Denodo Monitor directory and not in DENODO_HOME/logs/vdp. Please advise on in which case entries are generated in DENODO_HOME/logs/vdp/vdp-queries.log as well. Additionally, could you confirm if there is a log4j2.xml file for logs in DENODO_HOME/tools/monitor/denodo-monitor/logs? Fri, 19 Apr 2024 09:18:03 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000B3fmfIAB&title=Vdp-queries+log+generation 2024-04-19T09:18:03Z VQL STORED PROCEDURE/INTERFACE VIEW https://community.denodo.com/answers/question/details?questionId=906Qj00000B3cQdIAJ&title=VQL+STORED+PROCEDURE%2FINTERFACE+VIEW Hi everyone, this is the SP that creates the view interface and it's intended to be created in the indicated database specified in the parameter. How can I do that? [quarta-feira 17:22] Diogo Goncalves - Passio Consulting CREATE OR REPLACE PROCEDURE create_interface_view ( vdb_name IN VARCHAR, derived_view_name IN VARCHAR, interface_name IN VARCHAR, prt OUT VARCHAR ) AS ( vdb VARCHAR; d_name VARCHAR; i_name VARCHAR; frst VARCHAR; decimals VARCHAR; radix VARCHAR; size VARCHAR; remarks VARCHAR; code VARCHAR; result VARCHAR; max_rows INTEGER; max_linha INTEGER; rown INTEGER; vql_inter VARCHAR; prt VARCHAR; CURSOR get_max_rows IS 'SELECT COUNT(*) FROM GET_VIEW_COLUMNS() WHERE input_database_name = :vdb AND input_view_name = :d_name'; CURSOR get_data IS 'SELECT CONCAT(column_name, '':'', column_vdp_type), column_decimals, column_radix, column_size, column_remarks, column_sql_type_code FROM GET_VIEW_COLUMNS() WHERE input_database_name = :vdb AND input_view_name = :d_name'; ) BEGIN vdb := vdb_name; d_name := derived_view_name; i_name := interface_name; max_linha := 1; vql_inter := '('; OPEN get_max_rows PARAMETERS (vdb, d_name) VALUES (vdb_name, derived_view_name); FETCH get_max_rows INTO max_rows; CLOSE get_max_rows; RETURN ROW (prt) VALUES (max_rows); OPEN get_data PARAMETERS (vdb, d_name) VALUES (vdb_name, derived_view_name); LOOP FETCH get_data INTO frst, decimals, radix, size, remarks, code; result := CONCAT(frst, ' (sourcetypedecimals = ''', decimals, ''', sourcetyperadix = ''', radix, ''', sourcetypesize = ''', size, ''', description = ''', remarks, ''', sourcetypeid = ''', code, ''')'); IF max_linha < max_rows THEN vql_inter := CONCAT(vql_inter, result, ','); ELSE vql_inter := CONCAT(vql_inter, result, ')'); END IF; max_linha := max_linha + 1; EXIT WHEN max_linha > max_rows; END LOOP; CLOSE get_data; vql_inter := CONCAT(interface_name, ' ', vql_inter, ' SET IMPLEMENTATION ', derived_view_name, ' FOLDER = ''/03 - business entities'''); RETURN ROW (prt) VALUES (vql_inter); EXECUTE 'CREATE OR REPLACE INTERFACE VIEW :param' PARAMETERS (param) VALUES(vql_inter); END Fri, 19 Apr 2024 08:53:31 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000B3cQdIAJ&title=VQL+STORED+PROCEDURE%2FINTERFACE+VIEW 2024-04-19T08:53:31Z LEAD function doesn't work in Denodo 8 https://community.denodo.com/answers/question/details?questionId=906Qj00000AyOZZIA3&title=LEAD+function+doesn%27t+work+in+Denodo+8 Hi there, when I tried to use LEAD function in Denodo 8, the color doesn't change and the error shows the Function LEAD is not executable. From the documentation, the LEAD function is available in Denodo. What I have missed? Thank you! Wed, 17 Apr 2024 21:02:14 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000AyOZZIA3&title=LEAD+function+doesn%27t+work+in+Denodo+8 2024-04-17T21:02:14Z Connecting to VDP with EF/ADO.Net https://community.denodo.com/answers/question/details?questionId=906Qj00000AxRuVIAV&title=Connecting+to+VDP+with+EF%2FADO.Net Hi, We want to use Entity Framework to connect to Denodo VDP Server. The documentation at https://community.denodo.com/docs/html/browse/latest/en/vdp/developer/access_through_an_ado.net_data_provider/access_through_an_ado.net_data_provider shows that a only a very old version of the driver is supported. Could you let me know what the latest version to use with Denodo Platform 8? Thanks! Wed, 17 Apr 2024 17:12:53 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000AxRuVIAV&title=Connecting+to+VDP+with+EF%2FADO.Net 2024-04-17T17:12:53Z ORACLE TO VQL https://community.denodo.com/answers/question/details?questionId=906Qj00000AwivmIAB&title=ORACLE+TO+VQL I need to converter this TO_CHAR(9999, 'fm00000') for a vql. Is that possible? Thank you. Regards Wed, 17 Apr 2024 13:54:53 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000AwivmIAB&title=ORACLE+TO+VQL 2024-04-17T13:54:53Z MongoDB Atlas (through AWS) https://community.denodo.com/answers/question/details?questionId=906Qj00000AvsYzIAJ&title=MongoDB+Atlas+%28through+AWS%29 Hello, I'm trying to connect a MongoDB Atlas cluster from Denodo through the mongodb-customwrapper. Reading the user manual about this custom wrapper, it seems to me that ony clusters "based" on Azure can connect to Denodo. It is correct? I'm using a cluster "based" on AWS and I can't connect with this custom wrapper.. there is a way to connect thi AWS based cluster on MongoDB Atlas from Denodo? Am I missing something? Thanks, Maria B. Wed, 17 Apr 2024 08:20:05 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000AvsYzIAJ&title=MongoDB+Atlas+%28through+AWS%29 2024-04-17T08:20:05Z require guidance on creating new views in Denodo https://community.denodo.com/answers/question/details?questionId=906Qj00000AnytJIAR&title=require+guidance+on+creating+new+views+in+Denodo require guidance on creating new views in Denodo. We are aggregating data from old and new version of RAMOS (basically from two databases) into one source domain and building views on top of that for our downstream systems to consume. Can you suggest the right approach and what all do we need to do in order to achieve this business objective? Mon, 15 Apr 2024 08:19:13 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000AnytJIAR&title=require+guidance+on+creating+new+views+in+Denodo 2024-04-15T08:19:13Z first of current year https://community.denodo.com/answers/question/details?questionId=906Qj00000AiqtBIAR&title=first+of+current+year how do I pull first of current year and forward? for example, when the date is currently 1/1/24 to 12/31/24, I always want to get results from 1/1/2024 and forward. Fri, 12 Apr 2024 17:41:24 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000AiqtBIAR&title=first+of+current+year 2024-04-12T17:41:24Z