Skip to main content
  • EN

Is there a way to easily pull all of the SQL statements out of all of the SQLExecutors in a workspace? I have several automations that I need to do this for and some of them have hundreds of SQLExecutors in them.

Yes, it's possible, you can use the FMW reader and look for the SQLExecutor transformers:

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/fmw/fmw.htm

Yes, it's possible, you can use the FMW reader and look for the SQLExecutor transformers:

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/fmw/fmw.htm

This is a good first step! How would I add in a field that provides the SQL statements from the transformer? Out of the box, it keeps it generic to all transformers so all it provides is name, type, id, and some version and other misc. info.

Yes, it's possible, you can use the FMW reader and look for the SQLExecutor transformers:

https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/fmw/fmw.htm

Ah, nevermind. I found it under the TransformerParameters feature type.

Reply


Community Stats

30,120
Posts
114,320
Replies
37,748
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.