Tag: denodo

Technology – How Long Can A Description In Denodo Be?

How Long Can A Description In Denodo Be?

Denodo descriptions for base views, Derived views, and fields have a limit of 4,000 characters.  If you exceed this limit, you will not be able to save the view in denodo, and the offending description will turn red. Denodo Developer Note The limit is applied to each description; meaning 4,000 characters in the view description and 4,000 in the description of each field description. Denodo Character Limit Workaround The denodo description length limit is definitely something to keep in mind.  If you need to have a description length of more than the 4,000-character limit, then you may want to use

Continue reading

Technology – Can A Hyperlink Be Added To A Denodo View Description?

In a recent meeting, we are running up against the maximum length of the view descriptions of 4,000 characters.  When someone asked the question “Can a hyperlink be added to a denodo view description?” So, I did some testing. Denodo Virtual Data Port (VDP)  in Denodo Virtual DataPort (VDP) and the short answer is yes.  However, there are a few caveats: When you enter the hyperlink URL under Edit > Metadata > Description the URL will not look like a hyperlink. It will not turn blue, nor act like a hyper link. VDP Appearance Once the denodo view has been

Continue reading

Technology – Denodo ODBC And JDBC Driver Virtual DataPort (VDP) Engine Compatibility?

Recently, while patching a Denodo environment, the question arose as to whether an older ODBC or JDBC driver can be used against a newer patched environment. It is described in the first paragraph of the denodo documentation, the directionality of the compatibility can be overlooked easily. Can An Older ODBC Or JDBC Driver Be Used Against A Newer Past Environment? The short answer is yes.  Denodo permits backward compatibility of older drivers with newer versions. Even across major versions for denodo version 7 and 8. ODBC and JDBC driver Compatibility The older ODBC and JDBC drivers can be of an

Continue reading

Technology – Denodo 8 Java Version Requirements

In a recent customer meeting about the denodo installation requirements, the discussion turned to the supported Java version for denodo 8.   So, we looked it up to confirm, and as it turns out, the supported version of Java for denodo 8 is Oracle 11. Fortunately, it is well documented in the denodo documentation, the links to which have been provided below. P. S. This is an increase in the Java version required for version 7, which was 1.8. Related References Denodo / Home / Knowledge Base / Installation & Updates / Java versions supported by the Denodo Platform https://community.denodo.com/kb/en/view/document/Java%20versions%20supported%20by%20the%20Denodo%20Platform Denodo

Continue reading

Denodo – VQL Script To Add A Primary Key to derived Views?

Here is a Denodo Virtual Query Language (VQL) code snippet to add a primary key to multiple derived views in Virtual DataPort (VDP).  This code snippet assumes the primary key is the first field in the table.  Useful when needing to do bulk work on data warehouse-style views where the surrogate key of the view is the first field. I have found the script occasionally helpful when working with a large number of views, which need to be updated. VQL To Add A Primary Key On A Semantic Views select ‘ALTER VIEW ‘|| ‘ “‘||View_name||’” ‘|| ‘ADD CONSTRAINT ‘ ||”’PK_’||Column_Name||”’

Continue reading

Technology – When To Cache A Denodo View

Here’s a quick summary of practices about when to use cache when developing denotative views.  These guidelines come from the usual documentation and practical experience and may help you decide whether to cache a view. These are general guidelines, and they should happen the conflict with any guidance you’ve gotten from the Denodo; Please use the advice provided by Denodo. What is a table cache? In denodo, a cache is a database table that contains a result set of a view at the point in time, which is stored in a JDBC database Why Cache? Cache in Denodo can be

Continue reading