Skip to main content
Solved

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

markcoopersdc
Contributor
Forum|alt.badge.img+6

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?

 

 

 

 

Best answer by geomancer

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.

View original
    Did this help you find an answer to your question?

    2 replies

    oscard
    Influencer
    Forum|alt.badge.img+21
    • oscardInfluencer
    • Influencer
    • February 15, 2024

    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.

    markcoopersdc
    1 person upvoted this
    • markcoopersdc
      markcoopersdc
    geomancer
    Evangelist
    Forum|alt.badge.img+47
    • geomancerEvangelist
    • Evangelist
    • Best Answer
    • February 15, 2024

    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.

    hkingsbury
    1 person upvoted this
    • hkingsbury
      hkingsbury

    Reply


    Helpful Members This Week

    Community Stats

    30,980
    Posts
    117,414
    Replies
    38,765
    Members

    Latest FME

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie 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.