Q&A

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

Quick Start on AWS - can't access solution-manager-web-tool (public IP)
answered 30-04-2021 16:28:34 -0400

Hello - I followed the instructions on the "Denodo Standard for AWS 8.0 - Quick Start Guide" When I try to access http://<private_ip>:19090/solution-manager-web-tool/Login, the connection times out. I assume it's because my instance does not hav...

Answers: 3

AWS "Quick Start" IP

PostgreSQL v 13.2 Database connector/JDBC drivers - When?
answered 30-04-2021 13:30:37 -0400

Hi there, I know it is very early on to be asking this question, but does anyone know by when the JDBC drivers for v13.2 of PostgreSQL will be available, or if they are already available, where to get them? At the moment the highest version in the se...

Answers: 1

Denodo 8.0 Connector PostgreSQL JDBC Remote Tables

Compare VQLs of two vies
answered 29-04-2021 17:48:39 -0400

Hi, How can we compare VQLs of two views in same or different virtual databases?

Answers: 1

Metadata Comparison VQL comaparison

Does Denodo support legacy source systems like mainframe/zOS databases for data virtualization?
answered 29-04-2021 16:07:56 -0400

Want to know if Denodo supports the following mainframe/zOS databases (source): VSAM / QSAM Adabas IMS DB2 IDMS Sequential Files Does it also support AS400 applications?

Answers: 1

Mainframe

Joins with Paginated Data
answered 29-04-2021 13:48:58 -0400

If we have a schenario where results from two paginated APIs are to be JOINED. e.g. We have 1 million customers, and an API that returns 100 at a time. And another API that reutrn All Customer Orders, again 100 at a time, with no guarantee about what p...

Answers: 1

Pagination join

Creating Base View from LDAP Data Source
answered 29-04-2021 07:59:34 -0400

I have created user base view from an LDAP data source object but whenever I run a select on the object, I keep receiving below error. LDAP authentication has been setup and users are already using it to login to Data Catalog/VDP server. ERROR 2021-04...

Answers: 1

LDAPDatasource

regexp no argument for repetition operator: ?'
answered 28-04-2021 17:36:11 -0400

I have the following regexp function: SELECT TRIM(REGEXP(REGEXP(REGEXP(CUSTOMER_NAME_COLUMN, '[,\.]\s*', ' '), '\s+\w(?=\s+|$)', ' '), '\s{2,}', ' ')) AS CUSTOMER_NAME_CLEAN FROM TABLE When trying to run this, I get the following error: [JDBC ROUTE] ...

Answers: 1

regexp

how to check denodo data catalog is in sync or not.
answered 28-04-2021 16:30:57 -0400

how to check data catalog is in sync or not. One of our user could access to a data catalog url & unable to access another data catalog.

Answers: 1

Denodo dialect for python
answered 28-04-2021 11:54:21 -0400

Hi, I downloaded the denodo dialect for python connexion to use with sqlAlchemy on the support site. (Denodo Dialect for SQLAlchemy). I tried to add the dialect like I was told in this article : https://community.denodo.com/docs/html/document/denodoco...

Answers: 3

python dialect

How to obtain the input parameters of the custom stored procedure in the overridden initalize() method?
answered 28-04-2021 07:57:50 -0400

We want to execute some refresh vql command and get back the response through jdbc connection. Is it possible to obtain the input parameters in the initalize() method like we do in the doCall() And how do we extract and return the response of said vql...

Answers: 1
Related to: Executing VQL statements from a stored procedure

Custom stored procedure JDBC