Latest Denodo community answered questions 2024-09-09T14:36:12Z 2024-09-09T14:36:12Z

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 ?

2024-09-09T14:36:12Z 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