Installation & Configuation

SimpleOFAC Suite™ compliance software is a pure-Java server-side web application. It runs on any platform (windows, unix, linux ), supports most Ralational databases (HSQLDB, DB2, Oracle, MYSQL, Mircosoft SQL).

Requirement

In order to install SimpleOFAC Suite, you'll need a server environment that meets the following requirements:

• A servlet engine with at least JSP 1.2 and Servlet 2.4 support.
• JDK 1.5.x or later.
• A supported database with a JDBC 2.0 compliant driver.

Installation

To complete the installation of SimpleOFAC Suite, you'll need to perform each of the following steps:

1. Install application server:
   SimpleOFAC Suite support and test the following application server

   • Apache Tomcat 4.x or later
   • IBM Websphere 5.0 or later
   • Caucho Resin
   • BEA WebLogic
   • Any other appserver that supports the Servlet 2.4 and JSP 1.2 Spec.

   Please refer to each application server documentation on how to setup and install an applcation.

   SimpleOFAC Suite support both datasource or natvie driver to connect to database. Define a jndi datasource here if you want to make use of application

2. Install database:
   SimpleOFAC Suite surpports and test on

   • IBM DB2
   • MYSQL (open source)
   • Oracle
   • Microsoft SQL Server

   Create a database and a user with full privilege on the database of your choice.

3. Configuration:

   Point your web browser to the location on your webserver where you installed SimpleOFAC Suite.
   For example: http://www.[yourserver].com/ats/, login as root with password root

   After login, select the Configuration link the menu.

   

   1. Default Language:
      Select the default language. Current supports English, French and Chinese, more language will be added
   2. Database Connection Type:
      • Use Default HSQLDB: By default, use the embeded HSQLDB database engine. If you choose HSQLDB, skip the other database configuration.
      • Datasource: Use JNDI datasource. consult your application server document on how to create/configure a datasource
      • Native: Use the native database driver manager.
   3. Datasource Name:
      Although you can use any name, We recommend you to name your datasource as jdbc/atsdb, since we create a name reference for jdbc/atsdb in web.xml. Required only if select Datasource as database connection type
   4. JDBC driver Name:
      The java class of jdbc driver. Required only if select Native as database connection type
   5. JDBC Database URL:
      The jdbc URL to connect to your database server. Required only if select Native as database connection type
   6. Database User name:
      The user to connect to your database
   7. Database password:
      The password of the user to connect to your database