https://community.denodo.com/answers//feed/rss Latest Denodo community answered questions https://community.denodo.com/answers/question/details?questionId=906Qj00000IgwGXIAZ&title=Dependencies Hi Team, Is there any way to get the list of all the dependent views of a base view. Mon, 09 Sep 2024 09:49:42 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000IgwGXIAZ&title=Dependencies 2024-09-09T09:49:42Z https://community.denodo.com/answers/question/details?questionId=906Qj00000IZnUvIAL&title=Column+space+issue We have a view which is generated from joining a view from collibra, this view has an extra space in the specific column of the view. This space from the view is affecting other views down the line, we have applied the option 'trim' to eliminate the unwanted space . This space is not available from the source system views, it is observed that the space is present onky after the join. Fri, 06 Sep 2024 11:00:35 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000IZnUvIAL&title=Column+space+issue 2024-09-06T11:00:35Z https://community.denodo.com/answers/question/details?questionId=906Qj00000IArWwIAL&title=S4+Private+Cloud+Source Hello, Anyone connected S4 HANA(on Private Cloud) as datasource in denodo? Did you have to open DB port at S4 HANA end to enable this? What template with SAP had to be used for ticketing? What are the other options for this source? Thanks! Fri, 30 Aug 2024 02:42:15 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000IArWwIAL&title=S4+Private+Cloud+Source 2024-08-30T02:42:15Z https://community.denodo.com/answers/question/details?questionId=906Qj00000I4EbWIAV&title=Time+Format Hello Team I want my hours to be return in 24 hour format and not in the AM/PM format. for exemple, now, i have this kind of hour 03:38:00, and i would prefer 15:38:00. Is there a function that can change it in the output? Thanks Wed, 28 Aug 2024 15:05:35 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000I4EbWIAV&title=Time+Format 2024-08-28T15:05:35Z https://community.denodo.com/answers/question/details?questionId=906Qj00000I2eVHIAZ&title=Excel+Datasource+%28Macro-enabled+spreadsheet Hi Team, one question, is it possible to add a .xlsm datasource. BR Wed, 28 Aug 2024 05:34:24 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000I2eVHIAZ&title=Excel+Datasource+%28Macro-enabled+spreadsheet 2024-08-28T05:34:24Z https://community.denodo.com/answers/question/details?questionId=906Qj00000I2Um1IAF&title=how+to+combine+localdate+and+time+into+one+column%3F Hello Team, I have two columns: one type is localdate and the other is time. Can I combine them directly into one column and make the type of such column be timestamp? How should do that? Thank you Wed, 28 Aug 2024 03:48:47 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000I2Um1IAF&title=how+to+combine+localdate+and+time+into+one+column%3F 2024-08-28T03:48:47Z https://community.denodo.com/answers/question/details?questionId=906Qj00000HzpF7IAJ&title=HotFixes+and+Denodo+container+images Hello, Are hotfixes automatically installed on the denodo-platform and solution-manager container images when a new image is pushed? Thanks Tue, 27 Aug 2024 15:05:05 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000HzpF7IAJ&title=HotFixes+and+Denodo+container+images 2024-08-27T15:05:05Z https://community.denodo.com/answers/question/details?questionId=906Qj00000Hwq7iIAB&title=Not+able+to+connect+to+Denodo+from+EMR+Compute I am trying to connect to Denodo 8 with JDBC 8 from EMR. I am getting below error. However, I am able to connect from EC2 without any issue. Any help is much appreciated. conn = jaydebeapi.connect(jdbc_driver, jdbc_url, [username, password], jdbc_driver_path) Can confirm all of them are correct, as I am able to do it from EC2. On EMR, I am getting this error. sun.security.provider.certpath.SunCertPathBuilderExceptionTraceback (most recent call last) File Thread.java:750, in java.lang.Thread.run() sun.security.provider.certpath.SunCertPathBuilderException: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target The above exception was the direct cause of the following exception: sun.security.validator.ValidatorException Traceback (most recent call last) File Thread.java:750, in java.lang.Thread.run() sun.security.validator.ValidatorException: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target The above exception was the direct cause of the following exception: javax.net.ssl.SSLHandshakeException Traceback (most recent call last) File Thread.java:750, in java.lang.Thread.run() javax.net.ssl.SSLHandshakeException: javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target The above exception was the direct cause of the following exception: com.denodo.vdb.vdbinterface.common.connection.VDBConnectionExceptionTraceback (most recent call last) File org.jpype.JPypeContext.java:-1, in org.jpype.JPypeContext.callMethod() com.denodo.vdb.vdbinterface.common.connection.VDBConnectionException: com.denodo.vdb.vdbinterface.common.connection.VDBConnectionException: Connection error: Check the host name and port number are correct, and that client and server belong to the same Denodo major version. Cannot trust the server to establish a SSL connection The above exception was the direct cause of the following exception: Exception Traceback (most recent call last) File org.jpype.JPypeContext.java:-1, in org.jpype.JPypeContext.callMethod() Exception: Java Exception The above exception was the direct cause of the following exception: java.sql.SQLException Traceback (most recent call last) java.sql.SQLException: java.sql.SQLException: Connection error: Check the host name and port number are correct, and that client and server belong to the same Denodo major version. Cannot trust the server to establish a SSL connection Mon, 26 Aug 2024 19:42:58 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000Hwq7iIAB&title=Not+able+to+connect+to+Denodo+from+EMR+Compute 2024-08-26T19:42:58Z https://community.denodo.com/answers/question/details?questionId=906Qj00000HuEjGIAV&title=Troubles+with+hybrid+cloud+and+Denodo+Integration.+Any+Advice%3F Hey everyone, Iā??ve been working on integrating Denodo with our [hybrid cloud](https://www.lenovo.com/de/de/servers-storage/solutions/hybrid-cloud/) setup, and Iā??ve hit a few roadblocks. Specifically, Iā??m facing issues with data virtualization performance and seamless connectivity between our on-premises infrastructure and cloud services. Has anyone here successfully integrated Denodo in a hybrid cloud environment? What challenges did you encounter, and how did you overcome them? Any tips or best practices would be greatly appreciated! Thanks in advance for your help! Mon, 26 Aug 2024 04:32:08 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000HuEjGIAV&title=Troubles+with+hybrid+cloud+and+Denodo+Integration.+Any+Advice%3F 2024-08-26T04:32:08Z https://community.denodo.com/answers/question/details?questionId=906Qj00000HtjcEIAR&title=Use+array++of+roles+as+attributes+of+the+user+session+in+a+global+policy Is there a way to use the array of roles in the "attributes of the user session" in the audience section of the global policies? The scenario I am trying to work out is that I want to filter given views based on a tag if a user is in a specific role. I am unable to user the "who does the ... apply to" and select the specific role as users will typically have more than one roles so the other roles will bypass the policy. I was therefore wondering if I could use the attributes session and get the array of roles and using the contains operator know if the user was in that specific role or not. I tried using Getsession('Roles'), Roles and setting up a specific denodo token that I wanted to return the roles but I am unable to crack it. I know I can lookup the roles in the condition clause, which I am currently doing, but that means that the global policy pushes down parameters to the server even though the policy should not apply increasing the number of parameters. thank you, Sun, 25 Aug 2024 21:19:48 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000HtjcEIAR&title=Use+array++of+roles+as+attributes+of+the+user+session+in+a+global+policy 2024-08-25T21:19:48Z