https://community.denodo.com/answers//feed/rss Latest Denodo community answered questions https://community.denodo.com/answers/question/details?questionId=906Qj00000IhoGvIAJ&title=Refresh+Time+%2F+Update+frequency Hello, If I want to know the refresh time or update frequency of any particular data table which is on Denodo Data Catalogue how can I find it ? Mon, 09 Sep 2024 14:36:12 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000IhoGvIAJ&title=Refresh+Time+%2F+Update+frequency 2024-09-09T14:36:12Z 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