Is there a way to call a pipelined function with parameters and then read the results as a table in FME desktop? I am only interested in non-spatial attributes being used.
Thanks in advance...
Is there a way to call a pipelined function with parameters and then read the results as a table in FME desktop? I am only interested in non-spatial attributes being used.
Thanks in advance...
I think the SQLCreator should be able to do that.
This transformer acts as a reader, based on a SQL statement.
The statement will be passed to the database and the result will be read into FME.
Hope this helps.
Thanks Erik, that works great. Make sure to specify Automatic or Manaul for user attributes for anything consuming the data however, since FME does not pre-parse the return types for Dynamic with this type of call.