Q&A

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...

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...

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.

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 ...

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...

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...

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...

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...

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...

i have downloaded ova file for denodo training quickstart virtual machine i import ova file vmware workstation and started vm which is succesfully started but now its required ip address so kindly guide me which i have to enter in it. thanks