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...
wonderful information, I had come to know about your blog from my friend nandu , hyderabad,i have read atleast 7 posts of yours by now, and let me tell you, your website gives the best and the most interesting information. This is just the kind of information that i had been looking for, i'm already your rss reader now and i would regularly watch out for the new posts, once again hats off to you! Thanks a ton once again, Regards, Sandeep Maheshwari Quotes in Hindi
ReplyDeleteThanx a million once again, Regards, Gopinathrao Munde family photo
ReplyDelete