To configure a Microsoft SQL Server repository:

1. Ensure that SQL Server authentication is supported.

   For SQL Server 2000, you can do this in the SQL Server Enterprise Manager by right-clicking your SQL Server, choosing Properties, and clicking the Security tab. If Authentication is set to Windows only, change it to SQL Server and Windows, and then restart SQL Server.

2. Create a SQL Server user ID.
3. Create a SQL Server database to use as the repository.

   To do this, you can use the Enterprise Manager to expand the servers and folders on the left, right-click the Databases folder, and choosing New Database. You can name the database anything you wish and can keep default settings.

4. Grant your SQL Server user ID db_owner rights to the repository database.
5. If you have not yet done so, extract the contents of the ibspsql.zip file, for example:

   C:\Program Files\iway7\etc\setup\ibspsql.zip

   Extract the files to a directory on the machine running SQL Server. After extracting files, the SQL Server files are located in an mss directory.

6. Open a command prompt and navigate to the mss directory you extracted from ibspsql.zip. The following file contains SQL to create the repository tables:

   iwse.sql

   For Japanese users, the script is named Iwse-unicode.sql.

7. Issue the following command to create the repository tables:

   osql -S hostname -d databasename -U loginID -P password -i iwse.sql

   where:

   hostname

   Is the host name of the machine where SQL Server is running.

   databasename

   Is the database name you created.

   loginID

   Is the SQL Server ID with db_owner rights.

   password

   Is the password for the SQL Server ID.

   The tables should be created in your database.

8. Proceed to Installing the JDBC Driver.

To configure an Oracle repository:

1. Contact your database administrator to obtain an Oracle user ID and password to create the repository.

   This user ID should have rights to create and modify tables, as well as the ability to create and execute stored procedures.

2. If you have not yet done so, extract the contents of the ibspsql.zip file, for example:

   C:\Program Files\iway7\etc\setup\ibspsql.zip

   Extract the files to a directory on the machine running Oracle. After extracting files, the Oracle files are in an oracle directory. This directory contains SQL to create the repository tables.

   For Oracle 8i	iwse.ora
   For Oracle 9i and higher	iwse.ora9

   Note: For Oracle version 9i and higher, only the ojdbc14.jar driver is supported. In addition, you must use the iwse.ora9 script file when configuring repositories for Oracle version 9i and higher.

3. Issue the following command while logged on as a user ID with the correct environment settings:

   sqlplus userid/password @ iwse.ora

   or

   sqlplus userid/password @ iwse.ora9

4. Proceed to Installing the JDBC Driver.

To configure a Sybase repository:

1. Extract the contents of the ibspsql.zip file to the Sybase machine, which is located in the following directory:

   C:\Program Files\iway7\etc\setup\ibspsql.zip

   The ibspsql.zip file contains the SQL that is required to create the repository. The sybase directory you extract contains the following file to create the repository tables:

   sybase-iwse.sql

2. Submit this SQL to create the repository tables and structure.

   Note: This step should be performed by a Sybase DBA.

3. Proceed to Installing the JDBC Driver.

To configure a DB2 repository:

1. Extract the contents of the ibspsql.zip file to the DB2 machine, which is located in the following directory:

   C:\Program Files\iway7\etc\setup\ibspsql.zip

   The DB2 directory you extract contains the following file to create the repository tables:

   db2-iwse.sql

   Note: For z/OS systems, contact an iWay Software representative to obtain the correct scripts.

2. Submit this SQL to create the repository tables and structure. However, for OS/400 use db2-400-iwse.sql.

   Note: This step should be performed by a DB2 DBA.

3. Proceed to Installing the JDBC Driver.

1. Contact an iWay Software representative to obtain the SQL needed for a MaxDB repository. There are several files in maxdb-ibse-install.zip. The .bat files are used for Windows and the .sh files are used for UNIX.
2. Open install.bat (or install.sh) in a text editor and edit it so that it contains a valid MaxDB username and password. You can optionally change the database name (iwse):

   dbmcli db_create iwse username,passworddbmcli -d iwse -u username,password -i install-maxdb-instance.txt

3. Execute install.bat.

   The database should be created.

4. Open load-tables-maxdb-iwse.bat (or load-tables-maxdb-iwse.sh) in a text editor and edit it so that it contains a MaxDB administrator username and password, not necessarily the same logon as in install.bat. In addition, make sure it contains the same database name as install.bat (iwse by default):

   loadercli -d iwse -u dba_username,dba_password -b maxdb-iwse3.sql

5. Execute load-tables-maxdb-iwse.bat.

   The tables should be loaded.

   Note: If you need to drop the tables and start over, edit and submit maxdb-iwse-droptables.bat (or maxdb-iwse-droptables.sh).

1. Determine the JDBC driver for your repository.

   The required driver files depend on your database and driver type, for example:

   Database Driver	Required Driver Files
   SQL Server 2000	msbase.jar mssqlserver.jar msutil.jar
   SQL Server 2005	sqljdbc.jar
   SQL Server 2008	sqljdbc4.jar
   Oracle 8i	classes12.jar
   Oracle 9i and higher	ojdbc14.jar
   MaxDB	sapdbc-7_5_0_5.jar
   Sybase	jconn2.jar
   DB2 Type 4 Universal JDBC	db2jcc.jar db2jcc_license_cisuz.jar
   DB2 Type 2 Legacy App	db2java.zip See your driver documentation for more information. If both iBSP and DB2 are on z/OS or OS/400, refer to the IBM driver documentation.

2. Copy the required JDBC .jar file(s) into the iway7\lib directory, for example:

   C:\Program Files\iway7\lib

   For information about third-party driver files, see Preparing Adapters.

3. Restart iWay Service Manager from outside the iWay Service Manager Administration Console. On Windows platforms, you can restart it from the Services window.
4. For Servlet iBSP, add the JDBC driver to your application server CLASSPATH. See Configuring iWay Components and refer to your application server documentation for information on setting CLASSPATH.

   Tip: Depending on your application server, you may find it easier to add the driver into the ibse\WEB-INF\lib directory of the iBSP web application (ibse.war or ibse.ear).

5. Restart iWay Service Manager.

1. Open the iWay Service Manager Administration Console and log on:

   http://hostname:9999

   where:

   hostname

   Is the host name where you installed iWay.

2. In the left pane, click Services Provider.
3. Next to the Data Provider Name drop-down list, click the Add hyperlink.

   A form appears for defining the database.

4. Complete the fields as explained in the following table:

   Parameter	Description
   Name	Enter a name that you will use to refer to the connection.
   Driver Class	Use the drop-down menu or manually enter the JDBC Class.
   Connection URL	Use the drop-down menu and edit the default URL. You can also manually enter the URL. Examples are shown after this table. For SQL Server 2000, ensure the URL ends with the following: ;SelectMethod=cursor
   User	Provide the user ID to access the repository database.
   Password	Provide the password to access the repository database.

   The repository URLs have the forms listed in the following table.

   Database	JDBC URL
   SQL Server 2000	jdbc:microsoft:sqlserver://hostname:port;DatabaseName=db name;SelectMethod=cursor
   SQL Server 2005	jdbc:sqlserver://hostname:port;databaseName=dbname
   SQL Server 2008	jdbc:sqlserver://hostname:port;databaseName=dbname
   Oracle	jdbc:oracle:thin:@hostname:port:SID
   MaxDB	jdbc:sapdb://hostname[:port]/DatabaseName[options]
   Sybase	jdbc:sybase:Tds:hostname:port
   DB2	For DB2 Type 4 Universal JDBC driver: jdbc:db2://hostname:port/dbname For DB2 Type2 App driver: jdbc:db2:dbname See your driver documentation for more information. If both iBSP and DB2 are on z/OS or OS/400, refer to the IBM driver documentation.

   where:

   hostname

   Is the host name of the database server machine.

   port

   Is the port number for the database server. The SQL Server default is 1433. The Oracle default is 1521.

   dbname

   Is the database name or DB2 database alias or location name.

   SID

   Is the ORACLE SID.

5. Click Test.

   You should receive a response that says:

   The JDBC data provider test completed successfully.

   If you receive an error, troubleshoot accordingly. Ensure that the driver is in the iway7\lib directory as explained in How to Install the JDBC Driver.

6. Click Add if the test is successful.

   Your connection appears on the Data Provider page. If you need to change its parameters, you can click its link.

7. Click Services Provider on the left.
8. Change the Data Store Type to the type of repository you wish to use.
9. Set the connection you just defined as the Data Provider Name.

   Note: Connection Pooling is not supported for SQL Server 2005.

10. Click Update.
11. Restart Service Manager from outside of the iWay Service Manager Administration Console to ensure it completely restarts. On Windows platforms, use the services Window.

    When Service Manager restarts, you should reverify iBSP using the sample web service at:

    http://hostname:9000

Note: Use iWay Service Monitor to monitor iWay Service Manager events. Monitoring is implemented using AmberPoint components and can be enabled through the iWay Service Manager Administration Console. For details, see the iWay Service Manager User's Guide.

To migrate a repository, see Migrating Repositories.

To enter connection information for Servlet iBSP:

1. Ensure you have added your JDBC driver to your application server CLASSPATH as explained in How to Install the JDBC Driver.
2. Log on to the Servlet iBSP Configuration page at:

   http://hostname:port/ibse

3. At the bottom of the page, provide the repository connection information.

   The following table lists and describes the fields.

   Field	Description
   Repository Type	Specify the type of repository you are using. Note: Data Source is not supported.
   Repository URL	Edit the provide JDBC URL to connect to the database. Examples follow this table.
   Repository Driver	Provide the JDBC Class to connect to the database. For SQL Server 2000: com.microsoft.jdbc.sqlserver.SQLServerDriver For SQL Server 2005: com.microsoft.sqlserver.jdbc.SQLServerDriver For SQL Server 2008: com.microsoft.sqlserver.jdbc.SQLServerDriver For MaxDB: com.sap.dbtech.jdbc.DriverSapDB For Oracle: oracle.jdbc.driver.OracleDriver For Sybase: com.sybase.jdbc2.jdbc.SybDriver For DB2 Type 4 Universal JDBC driver: com.ibm.db2.jcc.DB2Driver For DB2 Type2 App driver: COM.ibm.db2.app.DB2Driver See your driver documentation for more information. If both iBSP and DB2 are on z/OS or OS/400, refer to IBM driver documentation.
   Repository User	Provide the user ID to access the repository database.
   Repository Password	Provide the password to access the repository database.

   The repository URLs have the forms listed in the following table.

   Database	JDBC URL
   SQL Server 2000	jdbc:microsoft:sqlserver://hostname:port;DatabaseName=dbname; SelectMethod=cursor
   SQL Server 2005	jdbc:sqlserver://hostname:port;databaseName=dbname
   SQL Server 2008	jdbc:sqlserver://hostname:port;databaseName=dbname
   Oracle	jdbc:oracle:thin:@hostname:port:SID
   MaxDB	jdbc:sapdb://hostname[:port]/DatabaseName[options]
   Sybase	jdbc:sybase:Tds:hostname:port
   DB2	For DB2 Type 4 Universal JDBC driver: jdbc:db2://hostname:port/dbname For DB2 Type2 App driver: jdbc:db2:dbname See your driver documentation for more information. If both iBSP and DB2 are on z/OS or OS/400, refer to IBM driver documentation.

   where:

   hostname

   Is the host name of the database server machine.

   port

   Is the port number for the database server. The SQL Server default is 1433. The Oracle default is 1521.

   dbname

   Is the database name or DB2 database alias or location name.

   SID

   Is the ORACLE SID.

   Note: For SQL Server 2005, do not check Repository Pooling.

4. Click Save.

   You should be redirected to the Servlet iBSP home page where you can test the sample web service. However, until you redeploy or restart the server, the new repository is not actually used.

5. Restart the application server.

   After the server restarts or the application is redeployed, test it by going to the Servlet iBSP home page at:

   http://hostname:port/ibse/IBSEServlet

   If you receive an error, confirm the settings at the configuration page:

   http://hostname:port/ibse

   If you receive an error, ensure CLASSPATH is properly set and redeploy the iBSP web application.