Skip to main content
  • EN

Hi

I am creating an automation in FME Flow.

My first workbench looks at a SQL database and extracts the most recent date/time. I would like to use this value to feed in to the Where clause of an Oracle reader in a second workbench so I can extract all records greater than that date/time without having to read all the records in. However, I cannot find anyway to pass the attribute value of the first workspace to the second.

 

Im sure I read somewhere that this was possible using parameters with workspace runners in Form?

 

 

 

 

I believe you need to use an Automation Writer in your first workspace  That writer exposes the values to the next workspace on a Flow Automation.

An alternative is to use FMEFlowJobSubmitter.

But I think you can do it all in the same workspace, when you access the Oracle database with a FeatureReader or an SQLExecuter.

Reply


Community Stats

30,102
Posts
114,261
Replies
37,736
Members
Terms & ConditionsCookie settings
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.