B2B Integration

 View Only
  • 1.  CLI interface for customer

    Posted Fri April 01, 2022 09:15 AM
    Initially, Customer was using a server with enabled SFTP connection where users used to upload / download the files. File transfer was carried out using scripts within organization. Customer monitoring team used to perform  files analysis operation by directly accessing the server and used to hit commands like grep, find, tail, head, wordcount, and many more. 
    Customer has moved from legacy SFTP server to Sterling File Gateway - B2BI setup. All users are onboarded as trading partners. Customer expect a similar access to B2BI mailbox and perform the standard legacy operation . Since customer belong to bank domain, no file download /upload is allowed for Customer monitoring team . 

    Could anyone suggest how to implement a command line interface / functionality for B2BI?
    Is it possible to have a SSH connection between trading partner and B2BI where user is allowed to read files / perform operation with read permission only  - no upload/download/ editing of files will be allowed?

    ------------------------------
    Regards
    Suparna Dey Karmakar
    ------------------------------

    #SupplyChain
    #B2BIntegration


  • 2.  RE: CLI interface for customer

    Posted Fri April 01, 2022 09:44 AM
    The CLI tool sftp should work.

    ------------------------------
    Dustin Souers
    ------------------------------



  • 3.  RE: CLI interface for customer

    Posted Mon April 04, 2022 01:32 AM
    For controlling read/write permissions, you can explore "Adapter policies" in B2Bi. You can create a policy with appropriate permissions and associate it with a particular SFTP server adapter

    ------------------------------
    Ankit Modi
    ------------------------------



  • 4.  RE: CLI interface for customer

    Posted Tue April 05, 2022 08:37 AM
    Edited by System Wed March 22, 2023 11:53 AM
    I believe there has been some confusion interpreting the original post.  OP has stated that the support team had the ability to ssh into the server and perform UNIX/Linux native commands on the file system used to store inbound documents, with read only permissions.

    There are no options for ssh connectivity into the SBI application.  If SBI is using the file system for document storage (optional; recommended over database when files are typically smaller), it is storing them using a database key as the file name, and any document stored on the filesystem may also be encrypted during the write process (optional; absolutely recommended if PII or PCI could be contained in document).

    There is no support for UNIX/Linux native tools inside of SBI to perform the identified commands (find, grep, head, tail) on a broad range of documents stored inside of one or more mailboxes.  It might be possible to perform individual file tasks using a customized BP, configuration and sandboxed filesystem, or by writing a custom java service:
    - retrieve specific document into process data
    - write to sandbox via FSA
    - execute commands via CLA2
    - write results to process data
    - report from process data via XSLT
    - clean up sandbox

    Otherwise, OP would need to add a step during the processing of inbound files to collect specific file content information and offload it to an external solution for review at a later time.

    ------------------------------
    Michael Geier
    IT Engineer 3
    Enterprise Holdings, Inc
    St. Louis MO
    ------------------------------



  • 5.  RE: CLI interface for customer

    Posted Wed April 06, 2022 03:30 AM
    Thank you Michael for your suggestion. I found it very helpful. 
    I will test it and present the idea to customer. Lets see if they agree else will need to raise a request for product enhancement.


    ------------------------------
    Suparna Karmakar
    ------------------------------



  • 6.  RE: CLI interface for customer

    Posted Fri April 22, 2022 09:42 AM
    The simplest solution if it is allowed by your organization is to make a copy of each file to File System using FSA during the "send" business process. And then provide access to the users for that file system. This is very common to do this for offline archiving.

    -Dhiraj Patil

    ------------------------------
    Dhiraj Patil
    ------------------------------



  • 7.  RE: CLI interface for customer

    Posted Fri April 22, 2022 11:17 AM
    Some customers in B2Bi own ITX/WTX also. 
    ITX has an adapter that support Azure Blob Storage and SQL.  Here are the links:
    Azure Blob Storage Adapter

    Azure SQL Adapter commands

    ------------------------------
    Rex Chan
    ------------------------------