3 Replies Latest reply: Sep 17, 2013 7:47 PM by 1040446 RSS

    Email reminders

    1040446

      Hi all,

       

      I'm new to ODI and was hoping to get some input on sending email reminders.

       

      I have an Oracle table with email address and expiration date. I want ODI to send an email to the user 5 days, 3 days, and 1 day before the expiration date.

       

      How can i accomplish this task?

       

      Thanks

        • 1. Re: Email reminders
          SH

          You need to do the following:

           

          1) Create an ODI procedure

          2) In the source tab specify the logical schema which is associated with the physical schema containing the table with the email adresses and expiration dates.

          3) In the source command create a query which returns all email adresses based on the date criteria specified

          4) In the target tab set ODI Tools as the technology

          5) Use the ODISendEmail tool to generate an email using the values returned by the source tab query for the address field making use of the in built looping functionality to iterate through all returned entries.

          • 2. Re: Email reminders
            1040446

            Hi SH,

             

            Thanks for the response. I followed steps 1-4 to create the procedure.

            In step 5, i created a package and dragged the procedure into the diagram. Then i dropped an OdiSendMail into to same area.

            In the properties of the Procedure, under the advanced tab, i selected OdiSendMail (Processing after sucess)

             

            How do i specify the To: parameter In the properties of OdiSendMail to refer to the values returned by the Procedure? And where do i set up the in built looping functionality?

            • 3. Re: Email reminders
              1040446

              SH,

               

              Please disregard the above questions. I figured it out. I went down the wrong path when i created the package. I did some more searching of some of the keywords in your answer and came across a step by step tutorial that illustrated the steps your are referring to.

               

              https://blogs.oracle.com/dataintegration/entry/using_an_odi_procedure_to_loop_1

               

              Thanks!