Skip to main content

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.

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.