Talend Data Catalog SQL Parsing

[Anonymous]

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 !

[Anonymous]

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