Question Re: Unable to send mail using data services? in Technology Q&A

Unable to send mail using data services?

shiv_parijatam — Tue, 15 Feb 2022 11:00:11 GMT

Hi,

I am using below command to send mail using exec but getting error as shown.

i have changed code to 8 and printed it as per a blog and getting below error now.

Re: Unable to send mail using data services?

former_member645387 — Tue, 15 Feb 2022 12:04:12 GMT

Hi there.

Data Services has a built in smtp_to function that you can utilize. It leverages the settings configured on your database server, If you have 'database mail configured' on a sql server. The below option should work for you. Here's a link explaining how it's configured (SAP Data Services – Mailing Functionality)

Within your Application Server, go to your SAP Data Services Server manager and under the miscellaneous tab, configure your smtp settings and apply.

Within your script you click on the function button and select the system options.

Select smtp_to and enter relevant details.

Hope this helps

Re: Unable to send mail using data services?

DayaJha — Wed, 16 Feb 2022 04:45:02 GMT

Hi ShivRam,

Couple of points, before you proceed for SMTP setup.

Make sure firewall port (by default 25 port) of SMTP should be open between source and destination machine
Make sure in AWS SMTP port (by default 25) should be added in AWS security group if it was setup
Coordinate with mail exchange team to whitelist or add BODS server machine name

Once all done, check connectivity setup using below command

telnet <source ip address of smtp/SMTP Name> <port number> for e.g. telnet email-smtp.eu-west1.amazonaws.com 25

I hope this will help!!!

Regards,

Daya Jha

Re: Unable to send mail using data services?

shiv_parijatam — Wed, 16 Feb 2022 07:15:07 GMT

Hi Jeremy & Daya,

Thanks for your reply. Earlier I have tried with smtp function only by doing all the pre-requisites to enable the functionality. we have set up smtp server settins as in BODS Server manager as per blog (https://blogs.sap.com/2015/10/26/sap-data-services-mailing-functionality/).

I am able telnet smtp server & even able to send mails from PowerShell/Linux os level.

But when trying to same using scripts getting below error that is the reason I though of using PowerShell but not sure on how to trigger it using bods.

As per SAP not they are asking to install any third party smtp client so just wanted to check if any of you have installed any TP. It will be good to know which third party tool I should go as I dont see any recommendation from SAP in reply.

Thanks, Parijatam

Re: Unable to send mail using data services?

DayaJha — Wed, 16 Feb 2022 07:48:54 GMT

Hi ShivRam,

please refer below link and SAP article for your reference.

https://document748.rssing.com/chan-14313668/all_p19.html

1719365 - Issues using the smtp_to function - Data Services

1573029 - How to Send Email Through a Command Line to Verify Connectivity to the SMTP (Email) Server From BI Platform

Regards

Daya Jha