Configuring External Databases to IBM SI

We can add as many as external databases to the IBM Sterling B2b Integrator (IBM SI). You can add these external databases to the IBM SI by the step wise procedure as explained below:

• First you got to stop IBM Sterling B2B Integrator.
• Now after shutting down your IBM Sterling Integrator, You need to navigate to SI_INSTALL_DIR\properties for editing jdbc_customer.properties.in and now after doing this add the below properties.
• "Run setupfiles.bat/sh (SI_INSTALL_DIR\bin\setupfiles.bat/sh)
• Now, you are done. For confirming, restart the IBM Sterling B2B Integrator.

Note: "Please do make sight that SI_EXTENSION is pool name that I have created. You can name it as you want."

How to Validate Connection Pool Creation?

Go to Dashboard --> Operations --> System --> Troubleshooter --> Database Usage we will find connection pool.

Oracle Database

Need to change the test query depending on server, For Oracle Database

SI_EXTENSION.testOnReserveQuery=SELECT * FROM DUAL

MS SQL Server Database

Need to change the test query depending on server, For MS SQL Server Database

SI_EXTENSION.testOnReserveQuery=SELECT GETDATE()

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_EXTENSION.maxconn=20

SI_EXTENSION.storedProcClassName=com.sterlingcommerce.woodstock.util.frame.jdbc.SybaseStoredProcQuery

SI_EXTENSION.varDataClassName=com.sterlingcommerce.woodstock.util.frame.jdbc.MSSQLVarData

SI_EXTENSION.catalog=SI_EXTENSION

SI_EXTENSION.type=remote

SI_EXTENSION.transaction=true

SI_EXTENSION.testOnReserve=true

SI_EXTENSION.testOnReserveQuery=SELECT GETDATE()

SI_EXTENSION.testOnReserveInterval=60000

SI_EXTENSION.maxRetries=100

SI_EXTENSION.blobPageSize=1024000

SI_EXTENSION.compressBlob=true

SI_EXTENSION.dbvendor=mssql

SI_EXTENSION.buffersize=500

SI_EXTENSION.maxsize=20

SI_EXTENSION.initsize=0

SI_EXTENSION.factory=com.sterlingcommerce.woodstock.util.frame.jdbc.ConnectionFactory

SI_EXTENSION.behaviour=2

SI_EXTENSION.lifespan=0

SI_EXTENSION.idletimeout=86400000

SI_EXTENSION.housekeepinginterval=3600000

SI_EXTENSION.waittime=1000

SI_EXTENSION.errorMissingTable=16945

SI_EXTENSION.systemPool=true