Correlation for BizTalk POP3 and SMTP RRS feed

  • Question

  • Hi,

    Currently am using POP3 Adapter for receiving Mail and doing business logic in orchestration and sending mail using SMTP Adapter.

    Am receiving Email message as a XML Message.  In this mail, To address is a Group Name and getting the Mail ids of group name from database then sending the mail.

    There is scheduler job is running for storing the mail ids in database.

    Here Biztalk orchestration should wait until the mail ids are available in database.

    Can we implement the above scenario using correlation?

    Could you please let me know how to achieve?

    Thanks in Advance

    Monday, April 16, 2018 8:05 AM

All replies

  • I personally do not see the need to have the correlation set up here.

    what I would in this is 

    1) Create the orchestration, poll the database from the orchestratin (by executing stored proc), keep this stored proc in a loop to be executed at regular interval,

    2) Configure the loop to exit as soon as the stored proc fetches the data from the database.

    3) Send the mail.

    Mandar Dharmadhikari

    Tuesday, April 17, 2018 2:41 AM