Skip to Content

Data services. How to send an email from a data flow

Hi

I have a data flow and when the data flow completed I would like it to send an email. Currently we exec unix script to achieve this from the flow so we can do it .. but is there a native send email. I have seen an audit menu item but it is greyed out. any ideas.

Mike

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Feb 23, 2017 at 10:33 AM

    Hi

    You can always include your data flow in a Try Catch Block to catch any exceptions. If anything goes wrong within the data flow then you can write the smtp_to() to send an email under the script in Catch block

    Another option is Audit for Data flow. When you click on any data flow, you can see the Audit Options under Tools or simply Right Click the Data Flow and Click Audit. You can set an Auditing Rule and if it fails then send it to distribution list. But the rule can be simple comparing a count between Source table and target table or you can also create your custom Rule.

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 23, 2017 at 10:48 AM

    Nice one Arun.

    I would like to add one point for Mike.

    Before you use smtp_to() or use Audit functionality, you need to add smtp server details and sender mail id in your SAP Data Services Server Manager.

    Please find the below screenshot.

    Regards,

    Soumyadeb Halder

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 01, 2017 at 01:29 AM

    Thats all great but where would one find - the SAP Data Services Server Manager?

    Is it accessable from the PC client ? - this is what I can see from the PC

    capture.png

    any ideas or is it accessable some where else..

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 29, 2017 at 04:09 AM

    Hi I have tested the smtp_to and yes it errors and refers to server manager

    ..my question is

    we have UNIX not windows there is no GUI? how to we set it ?

    any ideas?

    Add comment
    10|10000 characters needed characters exceeded