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

  • February 15, 2024
  • 2 replies
  • 68 views
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.

    This post is closed to further activity.
    It may be an old question, an answered question, an implemented idea, or a notification-only post.
    Please check post dates before relying on any information in a question or answer.
    For follow-up or related questions, please post a new question or idea.
    If there is a genuine update to be made, please contact us and request that the post is reopened.

    2 replies

    oscard
    Influencer
    Forum|alt.badge.img+22
    • oscardInfluencer
    • Influencer
    • 344 replies
    • 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.

    geomancer
    Evangelist
    Forum|alt.badge.img+58
    • geomancerEvangelist
    • Evangelist
    • 933 replies
    • 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.

    Community Stats

    32,101
    Posts
    121,896
    Replies
    39,748
    Members

    Latest FME

    Terms & ConditionsCookie settingsAccessibility statement
    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.