Latest Denodo community answered questions 2024-09-09T09:49:42Z 2024-09-09T09:49:42Z

Hi Team, Is there any way to get the list of all the dependent views of a base view.

2024-09-09T09:49:42Z 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