IBM B2B Sterling Integrator (SI) and Sterling File Gateway Installation Procedure

-
1. Install and Configure Sterling Integrator DB. Follow the below link to create and configure database,
         http://sirishg.blogspot.com/2012/12/sterling-integrator-oracle-user-and.html

2. Update License Set.
   Need to update the License Set because while installing SI it will take the out of box license file which needs to be overriden after post installation. Below command will update the Sterling Integrator license,
         InstallDirectory/bin$ AddLicenseSet.sh
        
3. Start SI and go to Operations --> System --> Licenses and do List All and check all carefully that we have got license for all
   required SI components for instance File Gateway Core
   Note: Check under InstallDirectory/properties/licensefiles for SI and SFG License.
 
4. Shutdown Sterling Integrator and proceed for Sterling File Gateway Installation
   InstallDirectory/bin$ InstallService.sh
   Note: We will find SFG under InstallDirectory/packages/filegateway_XXX.jar
 
5. After installation start SI we will be automatically pointed to filegateway URL.

​​Note: Only important factor here is before we trigger SFG installation we need to make sure we have valid licese for SFG, Otherwise your installation will be semi completed.

Comments

Post a Comment

Popular posts from this blog

Java Task Service - Sterling Integrator

-
import com.sterlingcommerce.woodstock.workflow.Document; import java.io.InputStream; import java.io.InputStreamReader; import java.io.BufferedReader; Document doc = wfc.getPrimaryDocument(); Document outPutDoc = wfc.newDocument(); ; InputStream inS = doc .getInputStream(); BufferedReader br = new BufferedReader( new InputStreamReader( inS )); String strData = “<SampleData>” ; String strLine; while ((strLine = br .readLine()) != null ) {     strData = strData.concat(strLine); } br.close(); strData = strData + “</SampleData>”; outPutDoc. setBody( strData .toString().getBytes()); wfc.putPrimaryDocument( outPutDoc );
Read more

Hibernate Connection Fails if there is Database inconsistency or DB fail-over (Oracle RAC)

-
        /**      * A static method with returns Hibernate Sessoin Object.      *      * @return {@link Session}      */     public static Session getSession() throws HibernateException {         Session appSession = sessionFactory .openSession();         try         {                 if (appSession.connection().isClosed()||!appSession.isConnected()||!appSession.isOpen()){                         System. out .println( "Session Closed, Creating Session again..." );                  ...
Read more

​ Configure External Databases to IBM Sterling B2B Integrator

-
We can add multiple ​​ external databases to IBM Sterling B2B Integrator. To add custom database need to do the following things, 1. Stop IBM Sterling B2B Integrator 2. Navigate to SI_INSTALL_DIR\properties and edit jdbc_customer.properties.in and add the below properties. 3. Run setupfiles.bat/sh (SI_INSTALL_DIR\bin\setupfiles.bat/sh) 4. Start IBM Sterling B2B Integrator Note: SI_EXTENSION is my pool name. We can name whatever we want. ​ ​ MS SQL Server Database Need to change the test query depending on server, For MS SQL Server Database SI_EXTENSION.testOnReserveQuery=SELECT GETDATE() Oracle Database Need to change the test query depending on server, For Oracle Database SI_EXTENSION.testOnReserveQuery=SELECT * FROM DUAL jdbc_customer.properties.in SI_EXTENSION.driver=com.microsoft.sqlserver.jdbc.SQLServerDriver SI_EXTENSION.url=jdbc:sqlserver://localhost:1433;databaseName=SI_EXTENSION;SelectMethod=cursor SI_EXTENSION.user=sa SI_EXTENSION.password= #SI_EX...
Read more