x

When using a DB2 repository, the connection information varies depending on the operating systems and the driver. The most common DB2 JDBC driver is the DB2 Universal JDBC driver.

During the WebFOCUS Client installation, you are prompted for:

• Database Name.
• Database Server Node (host name).
• Location Name.
• Port (50000 by default).
• Database logon and password that will own the repository.
• JDBC Driver (com.ibm.db2.jcc.DB2Driver).
• JDBC Path (db2jcc.jar and db2jcc_license_cisuz.jar).

Based on this information, the installation creates the connection information:

• CLASS:

  com.ibm.db2.jcc.DB2Driver

• URL
  • For Universal DB2 JDBC (UDB) Type 4 Driver:

    jdbc:db2://hostname:port/DBName

    where:

    DBName

    Is the database name for the repository.

    LOCName

    Is the DB2 location name.

    hostname

    Is the host name for the DB2 server.

    port

    Is the port for the DB2 server. The default is 324.

  • For Universal DB2 JDBC (UDB) Type 2 Driver:

    jdbc:db2:DBName 

x

In Derby, you create a database and user ID within a Derby Database Server.

During the WebFOCUS Client installation, you are prompted for:

• Database name for the repository (WebFOCUS80 by default).
• Database Server Node (hostname by default).
• Port (1527 by default).
• Database logon to access the repository (webfocus by default).
• Database password to access the repository (webfocus by default).
• JDBC Driver (org.apache.derby.jdbc.ClientDriver).
• JDBC Path (derbyclient.jar).
• ClassName: org.apache.derby.jdbc.ClientDriverConnection URL:

  jdbc:derby://<host>:<port>/<database>

Based on this information, the installation creates the connection information:

• CLASS:

  org.apache.derby.jdbc.ClientDriver

• URL:

  jdbc:derby://<host>:<port>/<database>

If you install multiple instances of the WebFOCUS Client, you need multiple repositories. To maintain multiple repositories in the same Derby Database Server, create a unique database for each instance.

x

In Informix, you create a database and user ID within an Informix Database Server.

During the WebFOCUS Client installation, you are prompted for:

• Database name for the repository.
• Database Server Node (host name).
• Database Server Name.
• Port (1526 by default).
• Database logon and password to access the repository.
• JDBC Driver (com.informix.jdbc.IfxDriver).
• JDBC Path (ifxjdbc.jar).

Based on this information, the installation creates the connection information:

• CLASS:

  com.informix.jdbc.IfxDriver

• URL:

  jdbc:informix-sqli://<host>:<port>/<database>:informixserver=<dbservername>

If you install multiple instances of the WebFOCUS Client, you need multiple repositories. To maintain multiple repositories in the same Informix Database Server, create a unique database for each instance.

x

In MySQL, you create a database and user ID within a MySQL Database Server. These steps are described in MySQL Repository Set Up.

During the WebFOCUS Client installation, you are prompted for:

• Database name for the repository.
• Database Server Node (host name).
• Port (3306 by default).
• Database logon and password to access the repository.
• JDBC Driver (com.mysql.jdbc.Driver).
• JDBC Path (mysql-connector-java-nn-bin.jar where nn is the version number).

Based on this information, the installation creates the connection information:

• CLASS:

  com.mysql.jdbc.Driver

• URL:

  jdbc:mysql://<server>:<port3306>/<database>

If you install multiple instances of the WebFOCUS Client, you need multiple repositories. To maintain multiple repositories in the same MySQL Database Server, create a unique database for each instance.

x

In Oracle, the database logon determines which tables and tablespaces are accessible within an Oracle Instance (ORASID). Your DBA should set up access to Oracle for you.

During the WebFOCUS Client installation, you are prompted for:

• Database Server Node (host name).
• Port (1521 by default).
• Database logon and password that will own the repository.
• Oracle Instance (ORASID) for the repository.
• JDBC Driver (oracle.jdbc.OracleDriver).
• JDBC Path (ojdbc16.jar for Java 1.6).

Based on this information, the installation creates the connection information:

• CLASS (Oracle 10g or higher):

  oracle.jdbc.OracleDriver

• URL:

  jdbc:oracle:thin:@hostname:port:orasid

If you install multiple instances of the WebFOCUS Client, you need multiple repositories. To maintain multiple repositories in the same Oracle Instance (ORASID), each repository must have a unique database logon (owner).

x

In Microsoft SQL Server, you create a database and user ID within a SQL Server Database Server. These steps are described in SQL Server Pre-Installation Steps.

During the WebFOCUS Client installation, you are prompted for:

• Database name for the repository.
• Database Server Node (host name).
• Port (1433 by default).
• Database logon and password to access the repository. (This must use SQL Server authentication and have db_owner rights.)
• JDBC Driver (com.microsoft.sqlserver.jdbc.SQLServerDriver).
• JDBC Path (sqljdbc4.jar for 2012/2008 or sqljdbc.jar for 2005).

Based on this information, the installation creates the connection information:

• CLASS:

  com.microsoft.sqlserver.jdbc.SQLServerDriver

• URL:

  jdbc:sqlserver://hostname:port/databasename=database_name

If you install multiple instances of the WebFOCUS Client, you need multiple repositories. To maintain multiple repositories in the same SQL Server Database Server, create a unique database for each instance. You can use the same user ID for each instance or create a new user ID for each instance.

x

SQL Server 2012, 2005 and 2008 have TCP/IP disabled by default. Since WebFOCUS and ReportCaster require TCP/IP, you must perform the following steps to enable TCP/IP in SQL Server 2012, 2008, and 2005:

1. Open the SQL Server Configuration Manager.
2. Under the SQL Server Network Configuration select Protocols for MSSQLSERVER.

   A list of valid network protocols for the SQL Server engine is displayed in the right pane.

3. Select TCP/IP from the list of available protocols.
4. Right-click TCP/IP and select Enable from the context menu.

   A message is displayed, which indicates that the MSSQLSERVER service must be restarted before the change is applied.

5. Restart the MSSQLSERVER service.

x

In Sybase, you create a database and user ID within a Sybase Database Server.

During the WebFOCUS Client installation, you are prompted for:

• Database name for the repository.
• Database Server Node (host name).
• Port (7100 by default).
• Database logon and password to access the repository.
• JDBC Driver (com.sybase.jdbc3.jdbc.SybDriver).
• JDBC Path (jconn3.jar).

If you install multiple instances of the WebFOCUS Client, you need multiple repositories. To maintain multiple repositories in the same Sybase Database Server, create a unique database for each instance.

x

In Teradata, you create a database and user ID within a Teradata Database Server.

During the WebFOCUS Client installation, Teradata is supported under the Other DB option. Supply the following Teradata repository information:

• Database logon and password to access the repository.
• JDBC Driver (com.ncr.teradata.TeraDriver).
• DB URL (jdbc:teradata://DatabaseServerName/DATABASE=databasename).
• JDBC Path (terajdbc4.jar and tdgssconfig.jar).

The default port number for the Teradata Database is 1025. However, port number does not need to be specified. If your Teradata Database is listening on a non-default port number that is something other than 1025, then use the DBS_PORT= connection parameter to specify the Teradata Database port. The DBS_PORT= connection parameter is documented in the Teradata JDBC Driver User Guide.

Based on this information, the installation creates the connection information:

• CLASS:

  com.ncr.teradata.TeraDriver

• URL (Type 4):

  jdbc:teradata://DatabaseServerName/Param1,Param2,...

If you install multiple instances of the WebFOCUS Client, you need multiple repositories. To maintain multiple repositories in the same Teradata Database Server, create a unique database for each instance.