CSE-Sterling B2B Integrator

All posts

List of the Producers and Consumers in the IBM Sterling Integrator system, their respective transport protocols and their assigned routing channels

KirtirajGopalakrishna Visits (672)

We see that many questions about how to retrieve a list of the Producers and Consumers and associated protocols like FTP, SFTP and about routing channels assigned. For the above question all that information is not located in the same table and might require joining few tables. This articles guides to get above info and please find below some database table information that can help to develop the requires queries. A) The first place to check would be the table YFS_ORGANIZATION B) The best way to get a list of producers and consumers is using... [More]

Tags: channels transport assigned protocol of theconsumers the list producers routing

Want to rename producer filename while routing to consumer inbox? Custom facts in Routing Templates help you

Krishna Kishore Konda Visits (2566)

If you are using Sterling File Gateway to route files between users and ever wanted to rename file in consumer Inbox? So this article is for you. I want to cover "Custom facts" in Routing Channel Template along with an example. Custom facts help you to rename files while routing from producer to consumer Inbox. Screen-print below shows where these custom facts can be configured. You have to be familiar with Regular Expressions to use custom facts to the fullest extent. Consider a requirement where producer sends the file... [More]

Tags: custom fact kishore filegateway

Troubleshooting issues with the SAP Suite Adapter for JCo 3.x in a Unix/Linux environment

Paul Barrie Visits (2336)

I recently worked with a customer who had successfully installed a fix pack to Sterling B2B Integrator only to find that the SAP Suite Adapter for JCo 3.x would longer start. I checked all the usual suspects: <SI Root >/in stal l/pr oper ties /dyn amic clas spat h.cf g contained a reference to the sapjco3.jar. The <SI Root >/in stal l/ja r/sa pjco 3/<s ap version> directory contained the sapjco3.jar <SI Root >/in stal l/sa pjco 3/<s ap version>/linux directory contained the library file. Everything looked fine,... [More]

Deleting "unneeded" SFG objects? Are you sure they aren't needed?

Ekmekvar Visits (2906)

I have seen a number of customers do one or more of the following things in their SFG setup in an attempt to "simplify" or "clean up" things. * delete the user accounts for partners that are listening consumers * delete some user accounts' virtual roots * change the name of the user account that is associated with an SFG partner * delete some partners' default mailboxes At the time, all of these things seemed like a good idea to the person that did them, but they also come with hidden costs. All... [More]

Tags: partners sfg

Security: Extract the information from the certificate using OpenSSL

ManishaKhond Visits (2714)

Author: Manisha Khond There are certain situations where you want to decode the certificate to verify that it contains the correct information. The easiest way to view the certificate content on Windows host, is to open the certificate and view it’s contents field by field. There are tools available to parse the certificate contents. OpenSSL is free tool and it can decode the contents of the certificate as well. This is the certificate that we want to decode (Part of the certificate displayed below is erased due to security... [More]

Updating an expiring AS2 Organization certificate: Part 2, Automatically

John Perry in Michigan Visits (3119)

Automatically updating expiring AS2 certificates This blog is intended to provide steps to aid in replacing an AS2 certificate used in your profile Organization. In it, I describe a method which can be used to replace the certificate automatically on a specified date. AS2 requires users to replace expired system certificates configured in the profile Organizations, and defined as the Exchange and Signing certificates. All certificates, used for any purpose, have an... [More]

Tags: automatically as2 update certificate organization

Updating an expiring AS2 Organization certificate: Part 1, Manually

John Perry in Michigan Visits (3806)

Manually updating an expiring AS2 Organization certificate This blog is intended to provide a few simple steps to aid in replacing an AS2 certificate used in your profile Organization, when it is about to expire. I will outline creating a new certificate, how to update it in the profile Organization, and provide some tips for managing the process of coordinating the replacement of the certificate with partners who need to use it. AS2 requires users to replace expired system certificates configured in the profile... [More]

Tags: organization certificate system as2 replace profile

REST API Java client for B2BAPIs - How to make JSON input for complex data types

Krishna Kishore Konda Visits (4443)

If you are looking to implement Java based REST API Client to invoke B2B APIs, my previous articles would help you. These include working java (REST API Client) classes for 2 of the APIs. REST API Proof Of Concept - Automate Sterling FileGateway Community and Trading Partner creation REST API Client - upload message to Sterling B2B Integrator Mailbox These articles covered how to generate JSON input string for... [More]

Tags: sterling kishore json sfg b2bapi

Obtain the Base64 format public or private keys of SSHUserIdentityKeys when using B2B API

Alex Chia Comment (1) Visits (2662)

When you are using the B2B APIs, you can use the Read SSHUserIdentityKey option to see both private keys and public keys in your B2B Integrator currently. These keys are in base64 encoded format. To see the keys in the non-base64 encoded format similar to when you are using the B2B Integrator Dashboard to check out the User Identity Key, you would need to copy out the string. For example: public key string would show something like below: "publicKeyData":... [More]

An important tool to use prior to SFG migration - sfgdbcheck

Ekmekvar Visits (3372)

The Sterling File Gateway (SFG) product documentation explains the specifics of what to do in order migrate a SFG instance, but misses something in the planning stage. There is a tool named sfgdbcheck that can be used to tell you how well prepared you are to begin a migration. For the more recent versions of SFG, the tool appears in the /<install>/bin directory as sfgdbcheck.sh for installations with a Linux operating system or in the \<install>\bin directory as sfgdbcheck.cmd for installations with a Windows operating system. The... [More]

How to change the file name in an e-mail attachment

Paul Barrie Visits (4360)

Changing the attachment name in a business process is not difficult, but until you know the tricks, it can be maddening. After a little experimentation, I created a sample business process that seems to do the job. I will spare you the wailing and gnashing of teeth that accompanied my first efforts, sharing only what I found to work. As you will see, there are a few things that will make the journey more pleasant. 1. If your file name will be created from concatenated values, it is probably best to get this out of the way. (Should... [More]

Tags: info attachment mail document adapter service send smtp pbarrie mime get

Sample onFault to send an email when a failure occurs.

IBM-Griff Visits (2939)

The following is an example onFault that will send an email whenever a failure happens in a workflow. The email will be sent to (and from) the admin account located in the sandbox.cfg file. The email will contain a subject that reads "Business Process 9999999 failed" It will be sent to the smtp host, email server, that is located in the sandbox.cfg. The following bpml is set to fail so you can see how it works. The lines in red bold is the onFault code that can be added to an existing bpml. As always, please test the code out as... [More]

Binding mode vs non-Binding authentication policy in B2B Integrator

Krishna Kishore Konda Visits (3988)

Sterling B2B Integrator allows configuration for external authentication so that users would get authenticated against servers such as LDAP, Active Directory. Here is supporting documentation. It is not uncommon for some clients to misconfigure authentication policies in authentication_policy.properties . That would lead to authentication errors or Java Exceptions some are hard to troubleshoot. I would like to discuss some common mistakes clients might make and few troubleshooting tips. I am not discussing some... [More]

Tags: ldap password_attribute search_filter b2b kishore sterling

Create SSH User Identity Key in B2B Integrator using API

Alex Chia Visits (3184)

NOTE: This API service is equivalent to Trading Partner > SSH > User Identity Key > Check In option in the dashboard user interface and not the Create option. The Rest API covers each required field pretty straight forward except on the field of Private Key Data. When creating an SSHUserIdentityKey using API, it is askin g us to supply privateKeyData (A Base 64-encoded string repr esentation of the private key.... [More]

Create and attach a Linux/Unix SSH Authorized User key to your SBI user in Sterling B2B Integrator.

srbrandon Visits (3116)

It’s very easy to send a batch of files from a Windows server to Sterling B2B Integrator(SBI), by using popular sftp clients (such as Filezilla or WinSCP). Linux/Unix inherently comes with an sftp utility, which can be used to create shell scripts to directly send files via sftp to any SFTP server. One caveat is that every time the sftp put command is executed in Linux/Unix, it will ask the sftp user's password interactively. This is a guideline on how to set up SBI so that a shell script from Linux/Unix doesn't prompt... [More]

Blogs