WINDOWS/JAVA/SQL Server Environment

A Windows/Java environment utilizing MS SQL Server is another straight forward setup. This example has three physical environments each with its own application machine and database machine. It is possible to put all MS SQL Server databases on one database machine or divide over two machines. If you select to use one or two MS SQL Server database machines, clear and precise naming of the associated databases is recommended.

SoftRater can be run on a non-Windows machine if a compatible application server platform such as WebLogic, WebSphere, or JBoss is running as well. If a non-Windows machine is used for SoftRater, you will need to download a Java version of SoftRater from Oracle Software Delivery Cloud. The Java version of SoftRater will need to be loaded onto the machine with the compatible application server platform.

The Setup

1.  The Development environment.
   • Contains one Windows Server app server and one separate MS SQL Server database.
   • RateManager and IBFA/SR-WIN would be located on the same Windows machine. RateManager and IBFA must run on a Windows Server machine.
   • OBI Publisher is installed for reports to be created.
   • The subscriber ID would be created here.
   • On the IBFA/SR-WIN for this environment, three database connections would be created and three logical environments would be created.
   • Two databases would be attached to the MS SQL Server machine.
2. The QA environment:
   • Contains one JAVA application server with WebLogic, WebSphere or JBoss installed and running and one separate MS SQL Server database.
   • IBSS/SR-JAVA would be loaded on the JAVA machine.
   • On the IBSS/SR-JAVA for this environment, one logical environment would be created.
   • One QA database would be attached to the MS SQL Server machine.
3. The Production environment:
   • Contains one JAVA application server with WebLogic, WebSphere or JBoss installed and running and one separate SQL Server database.
   • IBSS/SR-JAVA would be loaded on the JAVA machine.
   • On the IBSS/SR-JAVA for this environment, one logical environment would be created.
   • One PRODUCTION database would be attached to the MS SQL Server machine.

This is a basic Windows/Java utilizing a MS SQL Server database setup. It is possible to create more than three environments or use fewer than three. There are many combinations of platforms, databases and environments that can be used. Please contact your Insbridge representative for more information on the configuration that you would like to have.

Example