Skip to Content
0

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

Feb 23, 2017 at 05:34 AM

135

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Arun Sasi Feb 23, 2017 at 10:33 AM
0

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


ygadl.png (11.3 kB)
Share
10 |10000 characters needed characters left characters exceeded
Soumyadeb Halder Feb 23, 2017 at 10:48 AM
0

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


Share
10 |10000 characters needed characters left characters exceeded
mic grasso Mar 01, 2017 at 01:29 AM
0

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..


capture.png (7.6 kB)
Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Mic,

You can find the Server Manager only in the server where SAP DS platform is installed.

Regards,

Bogdan

screenshot-164.png (78.9 kB)
0

Thanks - we have a unix ds server ..but we'll give it a go thanks..!

0

Yes we still can't find this server manager ...on UNIX..any ideas..

0
mic grasso Mar 29, 2017 at 04:09 AM
0

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?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Please refer to below SAP Note

1629314 - How to set or change SMTP settings in Data Services 3.x

Regards

Arun Sasi

0