Denodo community Q&A RSS feed https://community.denodo.com/answers//feed/rss Latest Denodo community questions Custom MetaModel https://community.denodo.com/answers/question/details?questionId=906Qj00000CmUGDIA3&title=Custom+MetaModel Is it possible to create custom attributes on entities and attributes... otherwise known as a custom metamodel? Wed, 22 May 2024 21:12:50 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000CmUGDIA3&title=Custom+MetaModel 2024-05-22T21:12:50Z Denodo + HikariPool https://community.denodo.com/answers/question/details?questionId=906Qj00000Cky2HIAR&title=Denodo+%2B+HikariPool Hi there! I'm trying to create hikari DataSource with Denodo driver: ``` @Bean DataSource dataSourceDenodo() throws ClassNotFoundException { HikariDataSource dataSource = new HikariDataSource(); dataSource.setDriverClassName("com.denodo.vdp.jdbc.Driver"); dataSource.setJdbcUrl(env.getProperty("denodo.jdbcUrl")); dataSource.setUsername(env.getProperty("denodo.userName")); dataSource.setPassword(env.getProperty("denodo.password")); dataSource.setMaximumPoolSize(30); dataSource.setPoolName("denodo"); return dataSource; } ``` I have denodo-driver jar file in my project, and I've tried different versions from your website. For some reason I'm getting next message: > com.zaxxer.hikari.util.DriverDataSource - Registered driver with driverClassName=com.denodo.vdp.jdbc.Driver was not found, trying direct instantiation. > com.zaxxer.hikari.pool.PoolBase - denodo - Driver does not support get/set network timeout for connections. (null) > com.zaxxer.hikari.pool.HikariPool - denodo - Added connection com.denodo.vdb.jdbcdriver.VDBJDBCConnection@4cad7e97 I saw simillar question, and tried to put ```Class.forName("com.denodo.vdp.jdbc.Driver");``` in the method but this doesn't help. I'm trying to understand this because when I'm trying to query to Denodo, it's only works for the first call, if I'm trying to call second time with the same query I'm getting: > Error querying database. Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLTransientConnectionException: denodo - Connection is not available, request timed out after 30241ms. Please advise, thanks in advance! Wed, 22 May 2024 14:53:31 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000Cky2HIAR&title=Denodo+%2B+HikariPool 2024-05-22T14:53:31Z Virtual DataPort using a JDBC data source. https://community.denodo.com/answers/question/details?questionId=906Qj00000CkMl1IAF&title=Virtual+DataPort+using+a+JDBC+data+source. . We have a company database which we can connect to from Virtual DataPort using a JDBC data source. Everything works fine, but we have detected a problem when using the function 'LOWER' in Virtual DataPort (the 'UPPER' function works correctly) when querying views over that data source. What should we modify in Virtual DataPort as a workaround for this problem? Wed, 22 May 2024 12:34:43 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000CkMl1IAF&title=Virtual+DataPort+using+a+JDBC+data+source. 2024-05-22T12:34:43Z How to escape special character in username field https://community.denodo.com/answers/question/details?questionId=906Qj00000Cc12cIAB&title=How+to+escape+special+character+in+username+field I'm setting up a JDBC connection to an Azure SQL database server. The problem I'm getting is when I enter the username which is in the format of an email address, then the @ character is interpreted by the JDBC connector as an indicator for the Hostname. How do I escape this character entered into the username field? ANSWER: I had to add authentication=ActiveDirectoryPassword to the connection string. Mon, 20 May 2024 10:29:26 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000Cc12cIAB&title=How+to+escape+special+character+in+username+field 2024-05-20T10:29:26Z Could not open denodo web design studio https://community.denodo.com/answers/question/details?questionId=906Qj00000CblsIIAR&title=Could+not+open+denodo+web+design+studio Hi , my denodo design studio could not open after pressing the start button, only could open the VDP server , the rest cant.... Mon, 20 May 2024 06:29:57 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000CblsIIAR&title=Could+not+open+denodo+web+design+studio 2024-05-20T06:29:57Z Connect DataHub as a datasource in Denodo https://community.denodo.com/answers/question/details?questionId=906Qj00000CVpXBIA1&title=Connect+DataHub+as+a+datasource+in+Denodo Hi, Please advise on the steps to connect DataHub (https://datahubproject.io) as a datasource in Denodo. Thank you! Fri, 17 May 2024 14:05:10 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000CVpXBIA1&title=Connect+DataHub+as+a+datasource+in+Denodo 2024-05-17T14:05:10Z OAuth 2.0 API connection Issue https://community.denodo.com/answers/question/details?questionId=906Qj00000CVFtVIAX&title=OAuth+2.0+API+connection+Issue I have a GET URL, It was working fine with postman. When I trying to connect this Rest API to Denodo I have facing an error. like **Unable to establish connection: Connection refused** The Authentication type is OAuth 2.0 Authentication grant - Client credential grant Authentication method used by the authorization servers - Send client credentials using the HTTP Basic authentication scheme I mentioned Client ID, Client Secret, Access token, Token endpoint URL. As well as HTTP Headers also. Fri, 17 May 2024 10:39:25 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000CVFtVIAX&title=OAuth+2.0+API+connection+Issue 2024-05-17T10:39:25Z MFA https://community.denodo.com/answers/question/details?questionId=906Qj00000CTjyxIAD&title=MFA How do you setup the data source to use MFA authentication? Thu, 16 May 2024 21:27:43 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000CTjyxIAD&title=MFA 2024-05-16T21:27:43Z RedHat 9 and Denodo Driver 8.0 https://community.denodo.com/answers/question/details?questionId=906Qj00000CFpBOIA1&title=RedHat+9+and+Denodo+Driver+8.0 i have problem with that, in R studio show in error for Denodo: Error: nanodbc/nanodbc.cpp:1135: 00000: received invalid response to GSSAPI negotiation: R Mon, 13 May 2024 12:17:03 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000CFpBOIA1&title=RedHat+9+and+Denodo+Driver+8.0 2024-05-13T12:17:03Z Import Materialized View Data Lineage in Denodo https://community.denodo.com/answers/question/details?questionId=906Qj00000C7daSIAR&title=Import+Materialized+View+Data+Lineage+in+Denodo We would like to import an Oracle MV dependencies into Denodo, do we have an design option here Below will give all the underlying references of the MV, and we wanted to import those underlying tables/views and associate to the final view, so that we have a tree view. Please advise a optimal auotmated design for this? ``` SELECT * FROM dba_dependencies WHERE owner = 'dts' AND name = 'CAT_MV'; ``` Thu, 09 May 2024 22:41:46 GMT https://community.denodo.com/answers/question/details?questionId=906Qj00000C7daSIAR&title=Import+Materialized+View+Data+Lineage+in+Denodo 2024-05-09T22:41:46Z