
ANNOUNCEMENT: IBM Support Blogs are moving to a new home !
Read more about this move and learn how you will now access the content of this blog going forward by reading this announcement . We expect the move of this content will be completed by November 20, 2019. Check back here for any date updates.
|
List of the Producers and Consumers in the IBM Sterling Integrator system, their respective transport protocols and their assigned routing channels
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
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
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?
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
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
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
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
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
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
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
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.
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
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
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]
|