Skip to Content

Can we get the information of all the Tables, columns and there Data type from the SQL transform?

Jun 20, 2017 at 08:32 PM


avatar image

Dear Experts,

In our setup, we use SQL transform to extract data from the Source Application. Now for an ongoing migration project, we are required to provide the information for all the Source side tables (there columns and data type) that we being used. I have tried options such as Auto-Documentation feature of DS MC, explored the possibility of using metadata info. but so far haven't been able to meet the requirement.

I would really appreciate if you can help me to figure out a way here.



10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Dirk Venken
Jun 21, 2017 at 09:05 AM

Check my blog

Let the database do the hard work! Better performance in SAP Data Services thanks to full SQL-Pushdown, and more particularly the comment I posted on 18 Feb 2014:


In, general, I do not recommend the use of SQL-transforms to our customers. Why would you want to hand-code something yourself that can be automatically generated by the tool?

Also, with SQL-transform as a source, DS cannot generate a full SQL-pushdown anymore. It will have to pull all data in memory before writing out to the target, not good for performance with high data volumes.

On top of that, it will break lineage and impact analysis functionality. Making your application maintenance more complex.


10 |10000 characters needed characters left characters exceeded