7 Replies Latest reply on Jun 18, 2019 9:55 AM by Alex.V-Oracle

    ODI Agents

    Alex.V-Oracle

      how does the agent "know" what to do , its schedule and workload   ? does it pulls its info from the repository ?

      does the repository pushes this info to the Agent ? or rather the ODI Studio itself pushes this info to the Agent by some action ?

       

      is it mandatory for the ODI Studio to have connectivity to the Agent itself , to be able to properly test its functionality ?

       

      Thank you

        • 1. Re: ODI Agents
          Adrian_Popescu-Oracle

          Hi,

           

          ODI Agent and ODI Studio both connect to the same ODI repositories which store the ODI metadata.

          Also, the ODI agent is defined in ODI Studio \ Topology.

          So it is mandatory for the ODI Studio to have connectivity to the Agent itself.

           

          Adrian

          1 person found this helpful
          • 2. Re: ODI Agents
            Alex.V-Oracle

            what is not clear to me is if ODI Studio really  need to connect DIRECTLY to the Agent ...  or it writes all info needed to the repository (in regards to the actions that need to be performed by the agent) , and the agent then "reads" this info directly from master/ work repository.

            • 3. Re: ODI Agents
              Adrian_Popescu-Oracle

              ODI Studio writes all the info into ODI repositories.

              And agent reads from  ODI repositories.

              Usually agent is installed on different server than ODI Studio.

              • 4. Re: ODI Agents
                elb666

                Alex.V-Oracle wrote:

                 

                what is not clear to me is if ODI Studio really need to connect DIRECTLY to the Agent ... or it writes all info needed to the repository (in regards to the actions that need to be performed by the agent) , and the agent then "reads" this info directly from master/ work repository.

                The answer is "it depends".

                 

                When you create a schedule (i.e. schedule a job) in ODI Studio, ODI Studio writes to a table (SNP_PLAN_AGENT in 11g).  This does not require connectivity between ODI Studio and the agent you want to execute the job.

                 

                However, the Agent doesn't "know" about your new schedule until it has refreshed it's schedule, which it doesn't do unless it is told to, for example by clicking Update Schedule

                At this point, ODI Studio needs to be able to connect directly to the Agent.

                 

                There are other ways of getting the Agent to update its schedule, such as with the ODI Tool OdiUpdateAgentSchedule.  In fact, you could put this in a scenario, and schedule the scenario to run regularly (daily, hourly, whatever), and the Agent will then "update itself", and you would no longer technically need connectivity between ODI Studio and the Agent.

                 

                Another reason you would want/need connectivity between Studio and an agent is so you can have that agent execute a job.  When you click "execute", you choose a context and logical agent, which resolve to a physical agent.  If studio can't connect to that physical agent, the execution will fail.  It isn't required for Studio to be able to connect to an agent in order to execute a job, since you can execute jobs from Studio using the the "Local (No Agent)" option under "Logical Agent".  In this case, Studio doesn't need to be able to connect to an agent, but it DOES need to be able to connect to any data servers that the job requires.

                 

                This section might be helpful:

                https://docs.oracle.com/cd/E28280_01/integrate.1111/e12643/running_executions.htm#ODIDG1114

                In particular the section "Session Lifecycle".

                1 person found this helpful
                • 5. Re: ODI Agents
                  Alex.V-Oracle

                  Thank you for all these details that clarifies all I that I  needed  !

                  • 6. Re: ODI Agents
                    Adrian_Popescu-Oracle

                    Hi Alex,

                    If you question was replied please mark this thread as Answered, to help also other customers.

                    Adrian