Denodo community Q&A RSS feed Latest Denodo community answered questions Extract Numbers after each point and write in different capturing groups 2024-11-06T15:53:15Z 2024-11-06T15:53:15Z Hi, i am struggeling with the follwing problem: Input String "1.2.3.4.5" -> Result "Value: 1 2 3 4" REGEXP('1.2.3.4.5.', 'dont know how to do this', 'Value: $1') Important is that i can set the Numbers of results i will receive. e.g. when i Set 3 Input String "1.2.3.4.5" -> Result "Value: 1 2 3" Can someone help with this Problem ? Edit: i created this regex (solved) ``` REGEXP('1.2.3.4.5', '(\.*\d+\.*)$', '') ``` It Extracts only the the first 4 (or 3, or 2) and deletes the last Value after the '.' 2024-11-06T15:53:15Z How to query Materialized Tables in Denodo design studio? 2024-11-04T13:58:57Z 2024-11-04T13:58:57Z Hi, New to Denodo, I want to create a Materialized Table and then use it with a base view to create a integrated view. I have created the Materialized Table using 'Create Materialized Table' query but I dont see it in virtual database. And also if I run a Select query in VQL on this Materialized Table, I get error 'Table not found'. But If I try to create the table again, it says 'Table already exists'. Please help me understand how to work with Materialized Tables? Thanks in advance 2024-11-04T13:58:57Z REPLACEMAP and CR/LF char(10).... 2024-10-31T15:02:23Z 2024-10-31T15:02:23Z Hi Denodo Team, i want to Replace CR and LF in some columns. With Replace this is no Problem and working fine. ``` REPLACE(REPLACE(column1, char(10), ''), char(13),'') ``` But for future use i want a MAP for this. ``` CREATE MAP simple forbidden_chars ( 'char(10)' = '' 'char(13)' = '' ); ``` this is not working. how can I do this with a map ? And how can i Change a map ? Do i have to drop it first ? 2024-10-31T15:02:23Z Certified Developer Professional Question 2024-10-28T21:10:42Z 2024-10-28T21:10:42Z Hi, I'm interested in taking all the training courses for the Certified Developer Professional. But looks like the training courses listed above have some for Denodo 9.0 and some for 8.0. Wondering if someone could help understand the approach of taking the courses(if those are going to change soon etc.) Thanks! 2024-10-28T21:10:42Z Unable to login 2024-10-25T07:51:05Z 2024-10-25T07:51:05Z I have just installed express version of denodo. I don't remeber about User Name. I got secuirtycode via email and then entered password. Now it is asking user name. I am typing my email ID as User name but is giving an error. Invalid user / Password. Please advice. 2024-10-25T07:51:05Z Connectivity Issues with Denodo 8 (Design Studio) 2024-10-24T19:27:23Z 2024-10-24T19:27:23Z Hi everyone, I am accessing Denodo 8 (Design Studio) through the browser, and I often have to refresh the page to continue using it. It seems that somehow the browser loses connectivity with the server, but this does not happen in the Control Center. I suspect it might be related to the server or a specific configuration. Has anyone experienced this problem? Itā??s really frustrating to have to refresh the browser practically every minute. This issue occurs in Chrome, Edge, and Brave. I would appreciate any help you can provide. Thank you! Best regards, Elias 2024-10-24T19:27:23Z Error installing Denodo 9 (Linux) 2024-10-24T19:22:44Z 2024-10-24T19:22:44Z Hi, Iā??m trying to install Denodo 9 (Solution Manager) on Linux, and Iā??m encountering the following error: ``` /opt/denodo9/denodo-install-solutionmanager-9$ ./install.sh Exception in thread "main" java.lang.UnsatisfiedLinkError: /opt/denodo9/denodo-install-solutionmanager-9/jre/lib/libawt_xawt.so: libXrender.so.1: cannot open shared object file: No such file or directory at java.base/jdk.internal.loader.NativeLibraries.load(Native Method) at java.base/jdk.internal.loader.NativeLibraries$NativeLibraryImpl.open(NativeLibraries.java:388) at java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:232) at java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:174) at java.base/java.lang.ClassLoader.loadLibrary(ClassLoader.java:2394) at java.base/java.lang.Runtime.load0(Runtime.java:755) at java.base/java.lang.System.load(System.java:1957) at java.base/jdk.internal.loader.NativeLibraries.load(Native Method) at java.base/jdk.internal.loader.NativeLibraries$NativeLibraryImpl.open(NativeLibraries.java:388) at java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:232) at java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:174) at java.base/jdk.internal.loader.NativeLibraries.findFromPaths(NativeLibraries.java:315) at java.base/jdk.internal.loader.NativeLibraries.loadLibrary(NativeLibraries.java:285) at java.base/java.lang.ClassLoader.loadLibrary(ClassLoader.java:2403) at java.base/java.lang.Runtime.loadLibrary0(Runtime.java:818) at java.base/java.lang.System.loadLibrary(System.java:1993) at java.desktop/java.awt.Toolkit$2.run(Toolkit.java:1388) at java.desktop/java.awt.Toolkit$2.run(Toolkit.java:1386) at java.base/java.security.AccessController.doPrivileged(AccessController.java:318) at java.desktop/java.awt.Toolkit.loadLibraries(Toolkit.java:1385) at java.desktop/java.awt.Toolkit.initStatic(Toolkit.java:1423) at java.desktop/java.awt.Toolkit.<clinit>(Toolkit.java:1397) at java.desktop/java.awt.Component.<clinit>(Component.java:624) at com.izforge.izpack.installer.Installer.main(Unknown Source) ``` Has anyone faced this error? Any assistance would be greatly appreciated. Thank you! Best regards, Elias 2024-10-24T19:22:44Z Denodo to MQ 2024-10-24T16:35:16Z 2024-10-24T16:35:16Z Hi could you guide me through the most effective way to connect Denodo to IBM MQ 2024-10-24T16:35:16Z How to find the second occurrence of a character in Denodo 2024-10-24T08:09:27Z 2024-10-24T08:09:27Z Can someone please help me find the third occurrence of a character in Denodo? for example; '\\test\dir1\". Need to find the position of the "\" after test? 2024-10-24T08:09:27Z Denodo on ARM64 win10 / win11 2024-10-24T03:45:54Z 2024-10-24T03:45:54Z I am considering purchasing a MacBook Pro 16'' with the M3 Max chip for personal use. However, since M-series chips only support ARM versions of Windows 10/11 on VMware or UTM, I would like to know if Denodo platforms are compatible with ARM Windows 10/11. Are there any known issues or bugs? 2024-10-24T03:45:54Z