Configuring Sterling B2B Integrator for SFTP transactions

 BPEL for SFTP Outbound using password Authentication
<process name="default">
  <sequence name="Sequence Start">
    <operation name="SFTP Client Begin Session Service">
      <participant name="SFTPClientBeginSession"/>
      <output message="SFTPClientBeginSessionServiceTypeInputMessage">
        <assign to="." from="*"></assign>
        <assign to="KnownHostKeyId">496337157d395d528node1</assign>
        <assign to="PreferredAuthenticationMethod">password</assign>
        <assign to="ProfileId">203385157d3b59437node1</assign>
        <assign to="RemoteHost">********</assign>
        <assign to="RemotePasswd">murali</assign>
        <assign to="RemotePort">22</assign>
        <assign to="RemoteUserId">murali</assign>
        <assign to="RetryDelay">60</assign>
        <assign to="SFTPClientAdapter">SFTPClientAdapter</assign>
      </output>
      <input message="inmsg">
        <assign to="." from="*"></assign>
      </input>
    </operation>

    <operation name="SFTP Client CD Service">
      <participant name="SFTPClientCd"/>
      <output message="SFTPClientCdServiceTypeInputMessage">
        <assign to="." from="*"></assign>
        <assign to="Directory">/</assign>
      </output>
      <input message="inmsg">
        <assign to="." from="*"></assign>
      </input>
    </operation>

    <operation name="SFTP Client PUT Service">
      <participant name="SFTPClientPut"/>
      <output message="SFTPClientPutServiceTypeInputMessage">
        <assign to="." from="*"></assign>
        <assign to="ResponseTimeout">60</assign>
      </output>
      <input message="inmsg">
        <assign to="." from="*"></assign>
      </input>
    </operation>

    <operation name="SFTP Client End Session Service">
      <participant name="SFTPClientEndSession"/>
      <output message="SFTPClientEndSessionServiceTypeInputMessage">
        <assign to="." from="*"></assign>
      </output>
      <input message="inmsg">
        <assign to="." from="*"></assign>
      </input>
    </operation>

  </sequence>
</process>

Using Public Key Authentication
<process name="sftp_outbound_134_murali">
  <sequence name="Sequence Start">
    <operation name="SFTP Client Begin Session Service">
      <participant name="SFTPClientBeginSession"/>
      <output message="SFTPClientBeginSessionServiceTypeInputMessage">
        <assign to="." from="*"></assign>
        <assign to="KnownHostKeyId">496337157d395d528node1</assign>
        <assign to="ProfileId">203385157d3b59437node1</assign>
        <assign to="RemoteHost">********</assign>
        <assign to="RemotePasswd">murali</assign>
        <assign to="RemotePort">22</assign>
        <assign to="RemoteUserId">murali</assign>
        <assign to="RetryDelay">60</assign>
        <assign to="SFTPClientAdapter">SFTPClientAdapter</assign>
      </output>
      <input message="inmsg">
        <assign to="." from="*"></assign>
      </input>
    </operation>

    <operation name="SFTP Client CD Service">
      <participant name="SFTPClientCd"/>
      <output message="SFTPClientCdServiceTypeInputMessage">
        <assign to="." from="*"></assign>
        <assign to="Directory">/</assign>
      </output>
      <input message="inmsg">
        <assign to="." from="*"></assign>
      </input>
    </operation>

    <operation name="SFTP Client PUT Service">
      <participant name="SFTPClientPut"/>
      <output message="SFTPClientPutServiceTypeInputMessage">
        <assign to="." from="*"></assign>
        <assign to="ResponseTimeout">60</assign>
      </output>
      <input message="inmsg">
        <assign to="." from="*"></assign>
      </input>
    </operation>

    <operation name="SFTP Client End Session Service">
      <participant name="SFTPClientEndSession"/>
      <output message="SFTPClientEndSessionServiceTypeInputMessage">
        <assign to="." from="*"></assign>
      </output>
      <input message="inmsg">
        <assign to="." from="*"></assign>
      </input>
    </operation>

  </sequence>
</process>

Syntax Record for EDI Sterling Integrator

Get path,created date time, message id, extractable count of Mailbox with this query in Sterling Integrator

select MB1.PATH, M1.CREATED_DATETIME,MB2.MESSAGE_ID,MB2.EXTRACTABLE_COUNT from MBX_EXTRACT_COUNT MB2,MBX_MESSAGE M1, MBX_MAILBOX MB1 WHERE MB2.EXTRACTABLE_COUNT='1'