Q&A

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

Denodo 7.0 upgrade to Denodo version 8.0
answered 17-11-2021 06:44:36 -0500

Hi Team, Planning to upgrade the denodo 7.0 to denodo 8.0. Before upgrading we are concern about the impact of this upgradation. We are using two nodes of Denodo instance without load balancing feature. Please guide me what are the different points we...

Answers: 1

Denodo 8.0 Denodo upgrade

Denodo 7.0 supports MySQL innoDB cluser 5.7?
answered 17-11-2021 06:19:01 -0500

Hi Team, The underlying Mysql is going to upgrade to EE innoDB 5.7 version. I am concerned about whether Denodo 7.0 supporets this architecture or not. We can connect with Mysql right now but really concern about the comapatibility of Denodo for innoD...

Answers: 1

Denodo_MySQL MYSQL connect database

Getting Source Tables and Columns of a Datasource through Query
answered 17-11-2021 01:37:07 -0500

Hi Denodo team, Are there any queries to get all the tables in the datasource and also columns in a datasource for a specified table. I have seen that GET_SOURCE_TABLE() procedure is giving table but it takes view name as a parameter,but I don't want t...

Answers: 5

JDBC query Database JDBC DataSource

how to create a base view using .tsv.gz file from S3 bucket.
answered 17-11-2021 01:22:54 -0500

we are trieng to add base views from s3 bucket. but files are in tsv.gz format. Kindly assist with procedure to access this files. having read access for the same.

Answers: 1

Import file excel into bv
answered 17-11-2021 01:04:54 -0500

Hello I have a file excel present on the same machine where denodo is installed. I need to import it to be able to query it via denodo. I tried to create a new excel datasource via FTP / SFTP / FTPS Path but I don't risk it as it doesn't recognize the ...

Answers: 2

Import Excel sftp

How to isolate denodo from unexpected source environment updates
answered 16-11-2021 16:39:33 -0500

Hi, Is there any advice on how to isolate denodo from source environment updates that are unwanted/unexpected cascading into denodo base views? We have implemented our views with the branch pruning approach so cascaded changes should be minimised but w...

Answers: 1

dynamically create derived views based on list of multiple base views
answered 15-11-2021 16:50:51 -0500

Is there a way to take a list of specifc base views (based on say a certain prefix and create a derived view with a similar name (dv versus bv, etc.) I have a list of like twenty base views and looking for way to generate the derived views automatical...

Answers: 1

VQL Dynamic Derived views Loops

VQL Query Shows a Long Time Spent in Data Serialization
answered 15-11-2021 11:43:09 -0500

Hello! We are using Denodo 7.0.20200310 and SQL Server 2017. We have a simple SELECT statement joining 2 base views that runs slowly in our test environment (52 seconds) and fast in our QA environment (<1 second). In looking at the trace information...

Answers: 2

How to avoid array data conversion into text format while creating base view?
answered 12-11-2021 07:47:31 -0500

I have created a data source connection with another denodo data base. That data base has view in which data are present in array form. On creating a base view from that view, the array data get converted into text form automatically. Could you tell me...

Answers: 1

Base view ARRAY Create Base View

How to sync user queries in denodo data catalog servers?
answered 12-11-2021 00:48:26 -0500

Hi Team, I have a requiredment to automate the process of export and import user queries between 4 production servers through shell script. Is there any export and import commands available only to export the user queries from one server and to import...

Answers: 1

#userqueries #Datacatalog