• EN
Solved

How to use results of one fme workbench to feed into Where statement on reader of the next in FME FLow

  • 15 February 2024
  • 2 replies
  • 26 views
markcoopersdc
Rank
Badge +4

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?

 

 

 

 

icon

Best answer by geomancer 15 February 2024, 14:32

View original

2 replies

oscard
Rank
Userlevel 2
Badge +19

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.

geomancer
Rank
Userlevel 5
Badge +36

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

28,818
Posts
109,853
Replies
36,633
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.