Talend Data Catalog SQL Parsing

Anonymous — Sat, 16 Nov 2024 06:59:20 GMT

Does anyone know to what extent TDC can interpret SQL such as stored procedures containing transformations and the like?

I understand that one can harvest metadata from SQL Server, Oracle, etc.

Is the SQL Parsing ability limited to DDL only, or is the Talend Data Catalog smart enough to parse thru a complex stored procedure that contains several stages of temp tables, transformations using sum(), count() etc.

I have several layers of ETL which are all contained in stored procedures that are fairly complex, and need to map them all out.

I have been having a difficult time finding particulars / documentation on this.

thanks !

Re: Talend Data Catalog SQL Parsing

Anonymous — Thu, 28 Feb 2019 12:55:34 GMT

You can go through below link to go find the known limitations

http://metaintegration.net/Products/MIMB/MIMBKnownLimitations.html#RoundTrip

Please see section: 9 - SQL Parsing of Transformation Expressions in Import Bridges

Thanks
Bineesh

topic Talend Data Catalog SQL Parsing in Talend Data Catalog

Talend Data Catalog SQL Parsing

Re: Talend Data Catalog SQL Parsing