I need to read stored procedure from SQL instead of each table. Please assist. Thanks.
Question
How to read SQL stored procedure in FME?
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.
Hi, I think you can execute a Transact-SQL EXEC statement with the SQLCreator or SQLExecutor.
+26- Contributor
If you mean a stored function (a stored procedure does not return data) you can use the SQLCreator to execute a SQL statement and use that transformer to read data into your workspace.