Not sure if correct location :-
This post explains how to pull code information from SAP Data Services repos using AL_LANGXMLTEXT allowing you to harvest / extract any settings you want to analyse in a Data Services landscape right down to the flags which have been ticked on or not for transforms that are used. DQ Transforms are omitted due to the complexity of their structures.
Why?
For example:-
See where Global Variables are being used.
See which dataflows are bloated (have too many transforms).
Build a more relational Universe for SDS Code.
See whats using API Truncate and what is not.
Pull all code from all SDS repos over a SAP Data Services Landscape.
Build RAG statuses on repo design to help design standards.
etc etc…
If there is a good response more examples will follow. I did this to help myself and my team have full visibility of everything we are coding to.
Uses XPATH and XMLTYPE within Oracle 11g
http://allangxmltextharvest.blogspot.co.uk/
If anyone wants to help on this post in anyway (Any Microsoft SQL Gurus out there to provide an equivalent?) to help provide even more examples please feel free to do so.
NOTE: The code used on the blog could probably be done more efficiently or made to run even faster, however I hope its a stepping stone for all of you coders out there.
As always make any backups before running anything. Its your responsibility to run code not mine.
Good Luck!
Phatz
icon_wink.gif
phatz (BOB member since 2009-04-21)