Skip to main content
Question

Can I use a SQL stored procedure as data source of SQL non-spatial reader?

  • May 14, 2018
  • 1 reply
  • 4 views
H

I'm evaluating FME Workbench for our company GIS ETL processes. It doesn't look like the SQL reader supports stored procedure data sources. Is this correct?

I can work around it by using a view as source and a filter string on the reader but want to know if there's a way to use the stored procedure directly.

Thanks.

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.

1 reply

david_r
Celebrity
  • david_rCelebrity
  • 8394 replies
  • May 15, 2018

What database backend are you using?

Anything you can SELECT from ought to work. Notably this is an issue with Oracle that doesn't allow SELECTing from stored procedures, but there are workarounds if you look around.

Community Stats

32,086
Posts
121,847
Replies
39,729
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.