Home / Q&A / All Questions

Q&A

You must sign in to ask a question. If you do not have an account, you can register here

Revisions and Deployment automation
answered 18-11-2022 18:23:41 -0500

Hi, Are there any ways to automate the creation of revision, including all the envi changes that we need to make and run it on schedule as needed? In brief what are all possible methods for automating deployments in solution manager? This should inclu...

Answers: 1

#revisions #deployment Deployment using Solution Manager Best Practice

Transform text to data
answered 18-11-2022 18:12:36 -0500

HI everyone, I have a task to transform a text field to a timestamp field. The content of the initial field looks like this: "2017007", so it's like "YYYY0MM". I was trying aroudn with totimestamptz, but I don't know how to deal with this 0 in the ...

Answers: 4

VQL

Shared Views
answered 17-11-2022 08:24:42 -0500

Hello, I have couple of virtual database called "db-A" and "db-B". I have created some baseviews and derived views on "db-A". I am currently on "db-B". I would like to access those derived views which are available on "db-A" and would like to use i...

Answers: 1

Base view

How to verify '%Trace' in the DENODOTEST file
answered 17-11-2022 07:39:22 -0500

I have been reading through the documentation of Trace directive in Denodo Testing Tool. I need to access the 'staticO' element in my trace file. When I am accessing the 'staticO' element in the .DENDOTEST file by using the following code 'PLAN ABC.PLA...

Answers: 3

Automation Denodo Testing Tool DENODO #automation_testing

Columns in VDP Cache Monitor log entries don't match definition
answered 17-11-2022 04:09:58 -0500

Comparing columns in "VDP Cache Monitor" with actual events, two columns are missing. SqlViewName and Truncateddata Has the format changed for V8.X? Columns listed as elasped time, fail to provide the unit of measure. Seconds, milliseconds? From revi...

Answers: 1
Related to: Log column details

denodo V8 log

Joining CTE using a LEFT JOIN in Postgres throw error
answered 16-11-2022 18:48:56 -0500

When using a left join to join a CTE in Postgres, we receive a column "does not exist" error. This error occurs when one or several of the columns in the CTE are not used in the joined query. When inspecting the Execution Trace and reviewing the Postgr...

Answers: 1

CTE PostgreSQL left join

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