Q&A BY TAG 'denodo'

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

Connect to Denodo from Lambda
answered 04-03-2021 07:50:00 -0500

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: 4

lambda DENODO AWS

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

"SELECT top 1 1 as ID FROM <base view> uanble to excute
answered 13-01-2021 02:26:45 -0500

We have connected the SAP Database. when we are unable to excute the below query "SELECT top 1 1 as ID FROM &lt;base view&gt; " for the expected result ID 1 what changes can be done as the expected result thanks in Advance

Answers: 1

Top N SAP DENODO SAP BW/4HANA denodo with tableau

The version of Denodo on which window (analytic) function of SQL can be used
answered 12-01-2021 07:09:17 -0500

&lt;Reference&gt; https://community.denodo.com/answers/question/details?questionId=90670000000k9oHAAQ&amp;title=When+will+Denodo+support+analytic+functions+(i.e.+RANK%2C+NTILE%2C+PARTITION+BY....)%3F &lt;Denodo VDP Version&gt; 6.0 Administration tool:...

Answers: 1

DENODO #Analytic function

Continuous Error at Excel Microsoft Query data retrieval from Denodo (6.0) through ODBC connectivity
answered 08-01-2021 05:42:07 -0500

All the time when retrieving data from Denodo (6.0) to Microsoft Excel using Excel Microsoft Query intermediated by ODBC connectivity, I faces next error, and can't retrieve data to Excel from Denodo. &lt;Error Description when retrieving data from De...

Answers: 1

ODBC Excel Microsoft Query DENODO data types

Fetching Column issue in VQL
answered 05-01-2021 05:39:50 -0500

we have SAP Data Base, when we excute the base view in the denodo tool we could able get the 150 records. But, while excuting in the VQL shell for the specific Query like Select &lt;Column_name&gt; from &lt;data_base&gt;.&lt;Base_view_name&gt; throwin...

Answers: 1

VQL SAP DENODO SAP BW/4HANA