Informatica-EIC / Custom-Scanners

Custom Scanner Samples.
11 stars 12 forks source link

denodo: GET_SOURCE_TABLE [STORED_PROCEDURE] [ERROR] for non jdbc wrappers #10

Closed darren-wrigley closed 5 years ago

darren-wrigley commented 5 years ago

the Denodo scanner throws some errors when trying to generate custom lineage for non JDBC source tables.

the error is:-

`** error executing query.Error executing query. Total time 0.001 seconds.

QUERY [SELECTION] [ERROR] GET_SOURCE_TABLE [STORED_PROCEDURE] [ERROR] GET_SOURCE_TABLE [STORED PROCEDURE] [ERROR] Received exception with message 'The view has to be a JDBC base view: '

** end of error ` the scanner needs to know what the source type (wrapper in denodo), and based on that should only generate lineage for relational objects (jdbc wrapper type), until further analysis is done for the other types like DF (data files), JSON/WS for web services and json data & others.

documentation on wrapper types:- here