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.
Solved
Get SQL Statements from SQLExecutor Transformer
Best answer by david_r
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
- Best Answer
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
david_r wrote:
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.
david_r wrote:
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
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.