Latest Denodo community answered questions 2024-09-06T11:00:35Z 2024-09-06T11:00:35Z

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.

2024-09-06T11:00:35Z 2024-08-30T02:42:15Z 2024-08-30T02:42:15Z

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!

2024-08-30T02:42:15Z 2024-08-28T15:05:35Z 2024-08-28T15:05:35Z

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

2024-08-28T15:05:35Z 2024-08-28T05:34:24Z 2024-08-28T05:34:24Z

Hi Team, one question, is it possible to add a .xlsm datasource. BR

2024-08-28T05:34:24Z 2024-08-28T03:48:47Z 2024-08-28T03:48:47Z

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

2024-08-28T03:48:47Z 2024-08-27T15:05:05Z 2024-08-27T15:05:05Z

Hello, Are hotfixes automatically installed on the denodo-platform and solution-manager container images when a new image is pushed? Thanks

2024-08-27T15:05:05Z 2024-08-26T19:42:58Z 2024-08-26T19:42:58Z

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

2024-08-26T19:42:58Z 2024-08-26T04:32:08Z 2024-08-26T04:32:08Z

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!

2024-08-26T04:32:08Z 2024-08-25T21:19:48Z 2024-08-25T21:19:48Z

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,

2024-08-25T21:19:48Z 2024-08-24T10:44:16Z 2024-08-24T10:44:16Z

Hello Denodo Community, I hope you're all doing well. I am currently in the process of setting up Denodo on AMD-based servers and wanted to reach out for advice on best practices or specific configurations that might be beneficial for this setup. My goal is to ensure optimal performance and stability while leveraging the unique features of AMD processors. Here are a few specifics I am curious about: Configuration Settings: Are there any particular JVM or Denodo server settings that should be adjusted when running on AMD processors? For example, adjustments related to memory allocation or garbage collection? Compatibility Issues: Have any of you encountered compatibility issues or unusual behavior when running Denodo on AMD hardware? If so, how did you address them? Hardware Recommendations: For large-scale Denodo deployments, what are the ideal [AMD server](https://www.lenovo.com/ch/de/c/servers-storage/servers-amd/) specifications (e.g., CPU, RAM, storage) to ensure smooth operation? I appreciate any insights or experiences you can share. If there are any resources or documentation specific to AMD server configurations for Denodo, please let me know. Thank you in advance for your help! Best regards, Daniellemorriss

2024-08-24T10:44:16Z