IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
 View Only
Expand all | Collapse all

EmailAdapter

  • 1.  EmailAdapter

    Posted Wed April 22, 2015 09:00 AM

    Originally posted by: DennisRitche


    Hello Team,

    Can any one give the explanation on Email outbound command in Email Adapter. need syntax explanation


    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 2.  Re: EmailAdapter

    Posted Wed April 22, 2015 09:23 AM

    Originally posted by: Tim Rabbitt


    Hello Dennis:

    An overall syntax summary for the WTX email adapter can be found at: http://www-01.ibm.com/support/knowledgecenter/SSVSD8_8.4.1/com.ibm.websphere.dtx.adapemail.doc/topics/g_email_Syntax_Summary.htm?lang=en

    If you need any additional information can you let me know what your email system is and whether you will be sending attachments as this all impacts what the overall syntax would be.

    Do you have a map configured to use this and you experiencing any errors or are you just asking a general question?  If you are getting errors, enable the email adapter trace feature ( -TV )

    There is also a WebSphere Email adapter and this documentation can be found at: http://www-01.ibm.com/support/knowledgecenter/SSVSD8_8.4.1/com.ibm.websphere.dtx.wadapemail.doc/concepts/ac37160_.htm?cp=SSVSD8_8.4.1%2F12-10&lang=en

    Overall the WTX email adapter is a lot easier to use and configure so we suggest you use that instead of the WebSphere Email adpater.

    Regards,

    Tim Rabbitt


    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 3.  Re: EmailAdapter

    Posted Thu April 23, 2015 06:01 AM

    Originally posted by: DennisRitche


    Hello Tim,

    Greetings,

    In my scenario i have to send an email , taking the output from the map presenting it in the body of the mail . 

    If possible can you please explain me in PI.


    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 4.  Re: EmailAdapter

    Posted Thu April 23, 2015 06:25 AM
      |   view attached

    Originally posted by: paul.brett


    I attach a simple example, using the EMAIL adapter, to send the mapped content via an SMTP server.

    Thank-you.

    Paul.

    Follow me on Twitter


    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender

    Attachment(s)

    zip
    simple.zip   4 KB 1 version


  • 5.  Re: EmailAdapter

    Posted Thu April 23, 2015 07:32 AM

    Originally posted by: DennisRitche


    Hi paul,

    I have a question regarding the command you used in the above attachment

    In general as per my knowledge in order to send an email we have to configure sender authentication details like username and password .

    But here how it will be done.


    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 6.  Re: EmailAdapter

    Posted Thu April 23, 2015 07:46 AM

    Originally posted by: paul.brett


    In my example, I am delivering to an SMTP server.  No authentication required.

    Additional command line options can be added to my RUN() command, if authentication is required:

    =RUN("Blob.mmc",ECHOIN(1,Out1)+" -OAEMAIL1 '-PROTO inet -SERVER smtp.company.com -USER wtx -PASS wtxpass -FROM WebSphereTX -TO recipient@company.com -SUBJECT ''This is the stuff you wanted'' -TV '")

    ...but I doubt your target is SMTP, based on your question.

    Can you give more details about your target?

    Thank-you.

    Paul.

    Follow me on Twitter


    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 7.  Re: EmailAdapter

    Posted Thu April 23, 2015 02:14 PM
      |   view attached

    Originally posted by: DennisRitche


    Hi Paul,

    My target is SMTP only .

    Attaching the Trace file , please help me out.


    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange

    Attachment(s)

    mtr
    m4email.mtr   3 KB 1 version


  • 8.  Re: EmailAdapter

    Posted Fri April 24, 2015 05:06 AM

    Originally posted by: DennisRitche


    How to give port number 


    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 9.  Re: EmailAdapter

    Posted Fri April 24, 2015 06:08 AM

    Originally posted by: paul.brett


    I see:

    Server host is 'pswarna@miraclesoft.com'.
    WSAHostData: No host data available for 'pswarna@miraclesoft.com' (authoritative host not found).

    Please send us your complete command line (with the password masked).

    Thank-you.

    Paul.

    Follow me on Twitter


    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 10.  Re: EmailAdapter

    Posted Fri April 24, 2015 07:41 AM
      |   view attached

    Originally posted by: DennisRitche


    -PR INET -SERVER smtp.miraclesoft.com -FROM pswarna@miraclesoft.com -PASS ......... -TO pswarna@miraclesoft.com -SUBJECT test  -TV

    Attaching the latest trace file.


    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange

    Attachment(s)

    mtr
    m4email.mtr   4 KB 1 version


  • 11.  Re: EmailAdapter

    Posted Fri April 24, 2015 08:05 AM

    Originally posted by: paul.brett


    I see:

    <MAIL FROM:<pswarna@miraclesoft.com>
    >530 authentication required (F)
    <RSET

    I think you need to add -USER, as I mentioned before.

    Thank-you.

    Paul.

    Follow me on Twitter


    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 12.  Re: EmailAdapter

    Posted Fri April 24, 2015 09:00 AM

    Originally posted by: DennisRitche


    Sorry paul i missed that in my previous command but I actually used it 

    -PR INET -SERVER smtp.miraclesoft.com -FROM pswarna@miraclesoft.com -USER pswarna@miraclesoft.com -PASS ......... -TO pswarna@miraclesoft.com -SUBJECT test  -TV


    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 13.  Re: EmailAdapter

    Posted Fri April 24, 2015 11:01 AM

    Originally posted by: paul.brett


    I thought that the classic Email adapter did support SMTP authentication, but it appears that I may be wrong.  I will research and get back to you.

    Thank-you.

    Paul.

    Follow me on Twitter


    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 14.  Re: EmailAdapter

    Posted Wed April 29, 2015 04:20 AM

    Originally posted by: paul.brett


    OK, so I find that the classical Email adapter does not support SMTP authentication (with was not part of the original RFC for SMTP, and added later).

    This means using the WebSphere Email adapter instead.  I will create and upload an example soon.

    Thank-you.

    Paul.

    Follow me on Twitter


    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 15.  Re: EmailAdapter

    Posted Wed April 29, 2015 04:43 AM
      |   view attached

    Originally posted by: paul.brett


    A WebSphere Email adapter example, as promised.  This is actually a slightly edited form of the example given with the Design Studio installations.  It does include SMTP authentication:

    -TV j2ca.mtr -is:functionName Create -wtx:ispec com.ibm.j2ca.email.EmailInteractionSpec -wtx:record com.ibm.j2ca.email.EmailStructuredRecord -wtx:schemadir CommonSchemas -mcf:host smtp.company.com -mcf:protocol smtp -mcf:userName Dave -mcf:password dingbat

    The recipient, subject and sender information are all dealt with in card rules.  It would be a simple matter to convert this to a map that could be called via a RUN() function, and override these settings.

    Thank-you.

    Paul.

    Follow me on Twitter


    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender

    Attachment(s)

    zip
    wemail.zip   31 KB 1 version


  • 16.  Re: EmailAdapter

    Posted Fri May 01, 2015 11:44 AM

    Originally posted by: DennisRitche


    Thanks paul 

    This is working fine.


    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender