Q&A

Not able to execute the generate_stats..getting timeout..
answered 15-02-2021 01:59:25 -0500

Hi Team, I am trying to execute the procedure call GENERATE_STATS('view_name'); calling some 18 baseviews... Info: begin batch execution Info: number of jobs: 18 Command #1 ..... OK Command #2 ..... OK Command #3 ..... OK Command #4 ..... OK Command...

Answers: 2

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 ftp the flat file from local to Denodo shared folder.
answered 11-02-2021 07:24:02 -0500

we need to move the faltfiles whish are the datasources of some baseviews from dev shared folder of denodo to test env. now we copied the file manually. Going forward we would like to go with ftp. I see in tutorial, direction is been provided for ftp s...

Answers: 1

How to export the meta data and resource files with more granularity?
answered 11-02-2021 06:59:35 -0500

Hi Team, We are documenting the procedures for Denodo 7.0 to Denodo 8.0 product upgrade. We are planning for phased migration. We don't want to export the entire meta data as a whole but we would like to split it in several sprints. Say few application...

Answers: 1

#Denodo8.0_Product_upgrade #Export_metadata #Export_Resource_File

Passing Multiple values to multiple parameters in a REST API - Error
answered 11-02-2021 06:44:27 -0500

System Details : Denodo 7.0 - Windows 10 Operating system Query Topic : Passing multiple paramters and multiple values in REST API Web Service through URL Issue : While trying to pass multiple values to the multiple input paramters of REST API throug...

Answers: 1

REST API Multiple values multiple Parameters

Unable to establish connection: ORA-00018: maximum number of sessions exceeded
answered 11-02-2021 05:17:17 -0500

Hi Team, I am getting the below error message while connecting to the Oracle datase. Unable to establish connection: ORA-00018: maximum number of sessions exceeded

Answers: 1

How do I modify input parameters of a created base view?
answered 10-02-2021 07:02:22 -0500

Input parameter values are entered when creating a base view from a linked data source. Is there a way to modify the parameters values of an existing base view?

Answers: 1

Custom Connector

Denodo Web Service
answered 10-02-2021 06:50:52 -0500

I am able to insert single record in source Table using POST method. Here I am using JSON file format in post body part. When I am trying to insert multiple records in one call it is still inserting one record only. Is there any way to insert multiple ...

Answers: 2

post Json REST API Denodo Testing Tool REST Webservice

Caching data sources with > 1024 columns
answered 09-02-2021 06:07:25 -0500

Hi, A lot of the data we work with has > 1k columns. When I try and set caching for such a data set (~2k columns), I get an error (Error modifying view: CREATE TABLE failed because column 'xxx' in table 'xxx' exceeds the maximum of 1024 columns.). ...

Answers: 1

cache 1024 columns

High Volume Data extraction from Denodo 8 - 50 plus million rows (approximately data size is 10 plus GB) per table. We have close to 200 such tables
answered 08-02-2021 06:05:00 -0500

Hi, We are currently using Denodo 8 in our env. We have tables with more 50 Million rows on an average that needs to be exposed via Denodo. What is the best approach to do this. 1) Create a webservice on top of the Denodo View and expose as an API wit...

Answers: 1

Data extraction from Denodo