topic Re: Generic Database created by Denodo Data virtualization tool is not supported by Talend in Data Quality

Generic Database created by Denodo Data virtualization tool is not supported by Talend

vivekjayapalan — Sat, 28 Apr 2018 01:57:06 GMT

Hello

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.

Thanks,

Re: Generic Database created by Denodo Data virtualization tool is not supported by Talend

Anonymous — Sat, 28 Apr 2018 10:43:31 GMT

Hello,

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?

Best regards

Sabrina

Re: Generic Database created by Denodo Data virtualization tool is not supported by Talend

vivekjayapalan — Mon, 30 Apr 2018 14:24:42 GMT

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?

Pattern_Indicators_error.JPG

Re: Generic Database created by Denodo Data virtualization tool is not supported by Talend

Anonymous — Wed, 02 May 2018 08:22:05 GMT

Hello,

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"

https://jira.talendforge.org/browse/TDQ-15165

Best regards

Sabrina

Re: Generic Database created by Denodo Data virtualization tool is not supported by Talend

vivekjayapalan — Wed, 02 May 2018 14:29:12 GMT

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.

Re: Generic Database created by Denodo Data virtualization tool is not supported by Talend

Anonymous — Thu, 03 May 2018 08:16:56 GMT

Hello,

Currently, there is no denodo option on DQ database wizard. Did you install Denodo database server on your machine when make generic database?

Best regards

Sabrina

Re: Generic Database created by Denodo Data virtualization tool is not supported by Talend

Anonymous — Tue, 06 Nov 2018 04:27:30 GMT

Hello,

Here exists a jira issue about "Basic Column Analysis for Denodo database"

https://jira.talendforge.org/browse/TDQ-15896

Pattern frequency indicator doesn't work with sql engine. It should work with java engine.

Feel free to let us know if it is OK for you to use java engine to run a Basic column analysis as a workaround?

Best regards

Sabrina