Q&A

Connection Pool Pool
answered 11-11-2022 11:43:05 -0500

HI! Requests are generated using a custom jar function. When filling in all connections in the DATASOURCE JDBC pool, the system freezes. Forced completion of tasks or after a long time, connections in the pool are released, but the system does not prov...

Answers: 1

poolEnabled

core-site.xml configuration on other environments
answered 11-11-2022 08:33:56 -0500

Hi Team, We are using DFS wrapper which requires that core-site.xml file which needs to be configured. How can I export this file to prod environment using Revision or do we have any other way. Thanks

Answers: 1

dfs dfs configuration

Setting-Up an External Database in Solution manager using CLI
answered 11-11-2022 07:51:51 -0500

Hi Team, We would like to automate the process of configuring external metadata DB to store Solution manager information about license, promotion,environments, clusters and servers.Please suggest how it could be done using CLI.Also we tried with regene...

Answers: 1

Solution manager

Solution Manager Setting-Up an External Database
answered 11-11-2022 07:45:50 -0500

Do we have a CLI command for Setting-Up an External Database in Solution Manager like we do below for VDP ? regenerateMetadata --adapter postgresql --version 12 --classPath "postgresql-12" --databaseUri "jdbc:postgresql://psql-db:5432/vdpcatalog" --d...

Answers: 1

Solution Manager External Metadata DB

With sentence with more than 1 subquery
answered 11-11-2022 07:03:09 -0500

hi, in with sentence i saw only one subquery, can i add more than one subqueries samples: this is the documentation : WITH department_salary (deptno, totalpay) AS (SELECT deptno, SUM(salary) FROM EMP GROUP BY deptno) SELECT deptno FROM department_sala...

Answers: 1
Related to: https://community.denodo.com/expert-trails/view/document/Expert Trail: Query Performance Optimization

Missing parameter level info Error 106 - json datasource connection
answered 11-11-2022 06:30:41 -0500

Hi , We are working on Denodo 8 VDP. I have a requirement to extract information from an API. we successfully established connection and extracted few details through the API keys. The real challenge comes when we are trying to access one of the API's ...

Answers: 4

API

How to connect Denodo using PHP. Any syntax or Examples which shows the Connectivity
answered 11-11-2022 01:07:39 -0500

Hi All, we would like to connect our denodo Database using PHP code. Can we have any Steps or Syntax examples which show on how to connect to Denodo using PHP. Regards Raghu

Answers: 1

php

Issue while creating Denodo to ADLS connection
answered 10-11-2022 23:33:55 -0500

Hi, We are trying to connect ADLS from Denodo. For that we have created XML file with all the details and placed in VM. We have created Data Source with Partquet file wrapper. We have permission for one folder to extract the data , with that folder pat...

Answers: 1

Error accessing Parquet file XML

export deata catalog using export.sh
answered 10-11-2022 20:48:20 -0500

using below script but it is not working. is there any sample script used for linux host? sh export.sh -h denodo-de.ap.com -p 9443 -l admin -P pass@123 -f /platform/work/data-catalog/data_catalog_metadata.zip -contentSearch -personalization -kerberos ...

Answers: 1

metada Export

best practice to document my database in design studio
answered 10-11-2022 19:33:45 -0500

I try to describe the organisation of my database I tell what I've try When try in vql shell and write in a vql comment, if I "save" , I download the vql. So it's not keep in the folder so not accessible to collaborators The field description of a ...

Answers: 1

documentation