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

The CLI tool sftp should work.

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

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
------------------------------

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
------------------------------

Original Message:
Sent: Mon April 04, 2022 01:31 AM
From: Ankit Modi
Subject: CLI interface for customer

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
------------------------------

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
------------------------------

Original Message:
Sent: Tue April 05, 2022 08:36 AM
From: Michael Geier
Subject: CLI interface for customer

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
------------------------------


Original Message:
Sent: Mon April 04, 2022 01:31 AM
From: Ankit Modi
Subject: CLI interface for customer

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

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
------------------------------

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
------------------------------

Original Message:
Sent: Fri April 22, 2022 09:42 AM
From: Dhiraj Patil
Subject: CLI interface for customer

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
------------------------------