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

  • Feb 15, 2024 12:58 PM UTC
  • 2 replies
  • 127 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.

View original
    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+23
    • oscardInfluencer
    • Influencer
    • Feb 15, 2024 1:13 PM UTC

    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+69
      • geomancerEvangelist
      • Evangelist
      • Best Answer
      • Feb 15, 2024 1:32 PM UTC

      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.

      Just try it!

        Community Stats

        32,990
        Posts
        125,025
        Replies
        41,912
        Members
        Terms & ConditionsAccessibility 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.