Q&A BY TAG 'Denodo'

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

Denodo storing the data in external database.
answered 15-04-2021 08:41:35 -0400

Hi Team, If connection breaks from Denodo to exteranl database dues to some network issue or if external database instance goes down then what is retry startergy? How often Denodo tries to reconnect? what is max retry count?

Answers: 1

external database denodo retry

Denodo Hot backup
answered 15-04-2021 07:48:22 -0400

We wanted to setup a Denodo hot backup. I understand that this will be a separate always running server where metadata will be backed up/synchronized by the Solution manager and which will come up once main server goes down. However, I didn't find an...

Answers: 1

Denodo active-passive

Query to Json and send result
answered 02-04-2021 08:49:30 -0400

Good Morning, Could someone be able to help me carry out the task we are trying to achieve. Since we did not finish finding the key. The tasks would be the following: 1- Connect to BBDD (We can connect without problems) 2- SQL query to the DB (It...

Answers: 3

DENODO

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

Error when using RANK function for SAP data source
answered 17-03-2021 04:08:03 -0400

Hi, I am getting error while using a RANK function in Denodo v7. Error: "Finished with error: Error executing view: Function rank is not executable" Please let me know Will denodo support RANK function for SAP data source? If Yes, let me know how to f...

Answers: 1

SAP BO RANK Function DENODO RANK Rank

Denodo view expose into kafka
answered 03-03-2021 08:55:17 -0500

Hello, I have some views in Denodo and I waant tthem to be exposed into kafka The views can be exposed to kafka using creating a REST API. Question Moreover is it possbile to send the view without an API? Can we expose the views using VCS int...

Answers: 1

Denodo kafka

Denodo 7.0 - Estimate and Actual Memory Used by a Query
answered 03-03-2021 07:28:58 -0500

We're encountering an error suggesting a query is too large. How do you derive the estimated and actual memory of a query? -John

Answers: 3

Maximum Query Memory DENODO Memory Settings

Denodo unable to fetch all the records for an entity which contains different Schemas file extensions for the parquet files from S3
answered 24-02-2021 06:15:56 -0500

Hello, I tried to create a base with file pattern (.) for the parquet file entity/table in s3 region. Then, when i excute the count query to fetch all the recodrs in the entity.I could able to get the below mentioned error. Finished with error: Error ...

Answers: 3

custom S3 HDFSCustomWrapper; S3 DENODO AWS S3 Create Base View

Bring rules of the tables to base views
answered 12-02-2021 03:48:37 -0500

we have implemented security on tables in sql server ...we are using denodo 7.0.when we import the tables to create the base view do they bring them all or do we need to recreate them all again in denodo ? the denodo security doc dont have any comments...

Answers: 1

Access Denodo Express DENODO

How to convert a date in string format to interval date
answered 18-01-2021 05:54:50 -0500

Hi community I need to convert a date in string format to interval. Does anyone knows how ? Example : I need to convert this '1974873205059' to interval Thank you,

Answers: 1

Date Conversion VDP DENODO