We use Denodo data virtualization tool to model and create views on multiple database. All the views we create in denodo are stored in a Generic Database created as part of Denodo installation. We access this database to query data, also we have existing talend jobs which reads these views. When i say talend reading these views, talend has issues recognizing the columns and datatypes, so we manually update the column and datatypes for each views we read.
Now the main problem we are having is, we are trying to create some analysis on these views and we are having trouble running these analysis. I had created a ticket with Talend and ticket owner suggested to create a topic on the same. Created a Pattern frequency Analysis on one of the view in profiling tool and it does not work. Is anyway Talend can support or add generic database to its supported db list.
It looks like the pattern don't support your database.
Could you please show us your pattern frequency Analysis trouble screenshot? Have you already checked other column data types and other types of Indicator for database also?
Attached is one of the error, when we select any kind of pattern indicators or choose pattern freq analysis. Most of the other type of indicators are working and what do you mean by other column data types?
Does this issue repro on all your columns when you run column analysis?
Here exists a new feature jira issue about "Add support for Denodo database"
Yes this issue happens on any columns which are used by pattern indicators. Also there several other issue we are having when using this database, which we already have several tickets with Talend. We do not see any issues with any other database we have. We tried with Mysql, Oracle and Sql Server and do not get any errors. This is happening only with Denodo database which is a Generic database.
Currently, there is no denodo option on DQ database wizard. Did you install Denodo database server on your machine when make generic database?