Q&A

Link to Tokenization and encryption is dead
answered 16-11-2022 18:47:39 -0500

Hi, the link Tokenization and encryption refers to a dead URL: https://dzone.com/articles/tokenization-vs-encrypti

Answers: 1
Related to: Anonymization in Denodo

@symbolic link

How to test Access Protocols in DENODOTEST file.
answered 16-11-2022 08:51:21 -0500

In DENODOTEST, I need to test the JDBC access protocol that is present in the configuration.properties file. e.g. "jdbc:vdb://<localhost>:<portNumber>/<databaseName>". Is there any information about testing protocols in DENODO? The co...

Answers: 1

Automation DENODO #automation_testing

Dfs custom wrapper
answered 16-11-2022 07:52:42 -0500

Denodo Version : 8 I am trying to fetch the file from minIO and data source connection is sucessfull. When I try to create baseview I'm getting this below error. I am using dfs custom wrapper and selected class name as "com.denodo.connect.dfs.wrapper...

Answers: 1

dfs custom wrapper

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