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
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
- 8391 replies
- 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
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.