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

Merge search parameters for derived view to other 3 underlying views
answered 30-03-2021 08:46:37 -0400

Hello, I have following tree view: View / | \ View1 View2 View 3 | | | BV BV BV | | | DS DS DS The DS is a Web Service Datasource...

Answers: 1

Denodo 7.0 VQL search methods join Derived views

Changing parameter
answered 30-03-2021 08:40:58 -0400

Hi there, I have made one comparision parameter in a join view, like input '=' or 'in' localdate(2201/02/03) but if I want to add between range here, then what changes I have to do and how it works. I am trying to chnage it but it won't work.

Answers: 4

change parameter

PGP Encryption Custom Input Filter
answered 30-03-2021 06:33:56 -0400

We have a need to retrieve a PGP Encrypted file using the SFTP Delimited File connector. It appears that the only way to handle it (without having a preprocessor pull and decrypt) is to build a custom input filter. Has anyone already built this type of...

Answers: 1

encrypt PGP Custom Input Filter

Saving the VQL from Denodo Model Bridge?
answered 29-03-2021 09:33:31 -0400

Is there a way to save the VQL generated from the DMB into an external file?

Answers: 2

Denodo Model Bridge

python cur.execute result is not the same as the query result from VDP
answered 29-03-2021 08:20:44 -0400

Hi team, I used jdbc connect VDP on linux server, I am execute below query in my python script: select * from view_a limit 3; Its result is below: [('2021-03-27', '1970-01-19 10:39:21.600000', '', 'EF\x01\x01', None, None, None, None, None, None, None,...

Answers: 1

python VDP cur.result not correct

Connect to Denodo from Lambda
answered 29-03-2021 06:44:00 -0400

Hello, I need to get the view and its information in one of the Lambda function built on AWS Lambda. I tried the below link but it says about the ODBC and JDBC connections but since the Lambda is serverless, can we have a connection to Denodo from Lam...

Answers: 5

lambda DENODO AWS

Calling Kafka link via JSON data source
answered 26-03-2021 09:50:33 -0400

I am calling an link with HTTP Method under JSOn Data source and it says this error : Message returned by the server: {"error_code":406,"message":"Consumer format does not match the embedded format requested by the Accept header."} edit: Please sugg...

Answers: 1

Kafka

Can we commit offset value while fetching data from Kafka using Connector
answered 25-03-2021 08:46:02 -0400

Hi, Can we commit offset value while fetching data from Kafka using Connector

Answers: 1

kafka

How to search for / list in Denodo columns (of a view) that make use of a certain function?
answered 25-03-2021 08:37:01 -0400

How can I search for / list in Denodo all columns (of a view) that make us of a certain function? For example, I would like to list all columns that make use of "getdaysbetween"?

Answers: 1

Denodo stored procedure Metadata Catalog

User and Role Management menu items under Administration in Denodo Express Dimmed
answered 24-03-2021 08:58:16 -0400

We have server running Denodo Express that we are using for a training environment. I suspect that the default admin account was inadvertanty changed to remove some of the admin permissions. Is there a backdoor way to either access the Admin tool with...

Answers: 3

Denodo Express