B2B Integration

Sterling B2B Integration

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

 View Only
Back to discussions
Expand all | Collapse all

Help / Guidance needed to move mass mailbox messages from On-prem to corresponding Cloud mailboxes

  • 1.  Help / Guidance needed to move mass mailbox messages from On-prem to corresponding Cloud mailboxes

    Posted Wed June 10, 2020 04:05 AM
    Problem Statement -

    We are working on cloud migration for our Sterling B2Bi 5.2.6.1 version on AWS. Now we mostly use SFG for file transfer to external partners. There are lot of mailbox messages (mostly sitting on consumer mailboxes) that are yet to be extracted by TP. We need to move / migrate those data files into corresponding cloud mailboxes so that after cutover, the files are available to the external TPs.

    Please suggest different options available for smooth migration of data from on-prem to cloud where we are talking in 1000s of messages

    Let me know if you need more information.


    ------------------------------
    Pranjit Biswas
    ------------------------------

    #SupplyChain
    #B2BIntegration


  • 2.  RE: Help / Guidance needed to move mass mailbox messages from On-prem to corresponding Cloud mailboxes

    Posted Thu June 11, 2020 08:13 AM
    Hi Pranjit,

    Here we create on flow data extract a message from mailbox and sftp that message for a new environment.

    Regards,
    Bortoletto

    ------------------------------
    Ricardo Bortoletto
    ------------------------------

    Original Message


  • 3.  RE: Help / Guidance needed to move mass mailbox messages from On-prem to corresponding Cloud mailboxes

    Posted Thu June 11, 2020 08:49 AM
    Thanks Ricardo..can you share the code sample for the same ? 



    Regards,
    Pranjit | Lead Consultant |B2B
    Cell:- +91-9573080955
    pranjit_biswas@infosys.com
    PTO Plan :- None



    Original Message


  • 4.  RE: Help / Guidance needed to move mass mailbox messages from On-prem to corresponding Cloud mailboxes

    Posted Thu June 11, 2020 09:32 AM
    Hi Pranjit,

    Unfortunately I did this in the client's environment and I didn't have a copy of the process with me.
    Here are one sugestion with we can access the old environment from the new one using SFTP.

    You can use this querie to now and select all messages and mailbox there are, based on this you can create a xml that you can use as input to a bp that will ran on the new enviroment:

    select PATH, MESSAGE_NAME
    FROM MBX_MESSAGE, MBX_MAILBOX
    WHERE MBX_MESSAGE.MAILBOX_ID = MBX_MAILBOX.MAILBOX_ID

    This new bp will open a session of sftp.
    Create a loop that will do the following options:
          sftp cd to the mailbox PATH
          get the message_name
          add the document got with the get command to the PATH message_name using mailbox add message
          release the first ocurrence of xml and repeat the operation until finish the xml elements.

    This approach will be more simple than the first cenario I comment to you.

    I hope this helps you.

    Regards
    Bortoletto



    ------------------------------
    Ricardo Bortoletto
    ------------------------------

    Original Message


Related Content