Q&A

Incremental cache load
answered 08-03-2022 08:09:58 -0500

Is there any way to implement incremental cache load at derived view level?

Answers: 1

Incremental cache stored procedure
answered 08-03-2022 06:13:47 -0500

While executing the incremental_cache_load stored procedure, Getting error as: INCREMENTAL_CACHE_LOAD [STORED_PROCEDURE] [ERROR] COM.DENODO.CONNECT.INCREMENTALCACHELOAD.STOREDPROCEDURE.INCREMENTALCACHELOADSTOREPROCEDURE [STORED PROCEDURE] [ERROR] Rece...

Answers: 1

How to connect using JDBC driver in Python?
answered 08-03-2022 06:08:14 -0500

###Connection using JDBC import jaydebeapi hostname = 'server name' port = '####' driver = 'com.denodo.vdp.jdbc.Driver' user = '####' password = '#####' path = '/C:/Users/abc/Desktop/Projects/denodo-vdp-jdbcdriver.jar' url = 'jdbc:vdb://'+hostname+':'+...

Answers: 6

Access Denodo #Denodo Access Denodo Express Python

Summaries
answered 08-03-2022 05:27:10 -0500

As mentioned in support.denodo "As a best practice, please specify aliases for all columns in the SELECT clause of the query definition. If the query specified in the creation does not include aliases for all the columns in the SELECT clause, Denodo wi...

Answers: 1

JDBC Connection error and Driver URL error
answered 08-03-2022 04:53:31 -0500

I am trying to establish JBDC connection in my local system by connecting it to Denodo data portal for covid 19 data. When i enter the driver URL I am getting an error : " Unable to establish connection . Check the host and client number are correct an...

Answers: 1

How to handle exception in Denodo if we get any error in GraphQL response . We want to use our own custom exception details Also How to apply input validation in case of GraphQL request.
answered 07-03-2022 20:54:20 -0500

Hi Team: Could you please check on the below questions and update on the same 1) How to handle exception in Denodo if we get any error in GraphQL response . We want to use our own custom exception details ? 2) How to apply input validation in case of...

Answers: 1

GraphQL

Searching for a column in all the views in denodo
answered 07-03-2022 07:28:43 -0500

Is there a way to search for all the views that has let's say "Scan_Date" column in them in Denodo?

Answers: 1

Updating description for a view
answered 07-03-2022 05:34:50 -0500

is there a SQL to update the description for a view. Description in element properties.?

Answers: 1

Getting error "received invalid response to SSL negotiation: H" when trying to connect
answered 07-03-2022 00:43:05 -0500

Getting error "received invalid response to SSL negotiation: H" when trying to connect to my Organisations denodo using Denodo ODBC. this occurs when i test the connection on the windows ODBC control panel as well as when I build the connection string ...

Answers: 1

Error Denodo 8 ODBC SSL

MIGRATION TO 8.0 WARNING SUMMARY
answered 04-03-2022 07:14:14 -0500

need and advice, what should i do if the warning summary description is about roles? it didn't explained in this section about predefined roles and user https://community.denodo.com/docs/html/browse/8.0/en/platform/upgrade/review_the_virtual_dataport_m...

Answers: 1

Migration #Roles export Export