Latest Activity

code

Connection Error (Service Negotiation failed) with the creation of ODBC 32 bits data source

Hi We're trying to create ODBC data sources to Denodo on a Windows Server. The Datasource 64 bits is working fine. But we have a connection error for the 32 bits one. The connection test (with SSL mode=require) gives : Service Negotiation failed;The ...

code

Web Automation

Hi, I read somewhere that ITPilot is now depecated in major versions after v8. Is there a roadmap for what's next in terms of Web Automation / Extract capability within Denodo? Thanks, Kyle.

code

Use Denodo 8 connect HDFS Parquet file

HI team, I am using this manual https://community.denodo.com/docs/html/document/denodoconnects/7.0/Denodo%20Distributed%20File%20System%20Custom%20Wrapper%20-%20User%20Manual to let Denodo 8 to connect HDFS paruet file. I have extend "Denodo Distribute...

code

How to backup user queries under Data Catalog?

Hi, Is there a way to automate backup of the Saved Quries by users? Currently I can see that an admin user has an option to "Export All User Queries" under "My Queries", but this is a manual way to do. Does the export script contain user saved queries...

code

Is there a query to get a list of views with EXECUTE permission for current user?

I want to list views accessible by the current logged user. Seems I should use GET_VIEWS(), GET_PERMISSIONS() and GET_EFFECTIVE_PERMISSIONS(), but cannot realize how

code

Unable to connect with Derived view from REST datasource with variable getting feeded from another view

Version :- Denodo 8.0 Hi, i want to use rest api url as one data source, for which i configured it as https://bioreg-uat.gsk.com:1743/bioreg/api/v1/entities/@{instanceId} Now we dont have instance ID this will be fulfilled from another data source whi...

code

Spring throws: "java.lang.IllegalStateException: Cannot load driver class: com.denodo.vdp.jdbc.Driver" on Data Source instantiation

Hi dears, I imported Denodo JAR using maven and I configured my app to access Denodo views with the following properties and driver class name: spring.datasource.denodo.url: jdbc:vdb://<ip>:<port>/<db> spring.datasource.denodo.usern...

code

Denodo 8: synchronize the VDP server metadata with Data Catalog using Data Catalog REST API

Hi Team, I am following page https://community.denodo.com/docs/html/browse/7.0/vdp/data_catalog/appendix/rest_api/rest_api#rest-api for metadata synchronization from VDP to Data Catalog for Denodo 8. Can you please help confirm if the Denodo 8 can use ...

code

VDPCache for multiple tables

Hi , I want to load cache of multiple views through single VDPCache job from Scheduler . can we do it ? is there any example for the same ? (Version 8.0) TIA SJ

code

LIST DATASOURCES

Hi Guysi am struck with getting List all datasources for Excel dataSourceType i am using this LIST DATASOURCES Excel ON scholar; query it is not working can any one help me on this