Repository Connection Information

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).
• Credentials for the account 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 

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 (WebFOCUS82, by default).
• Database Server Node (hostname, by default).
• Port (1527, by default).
• Account 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.

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).
• Account 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.

In Oracle, the account 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).
• Credentials for the account that will own the repository.
• Oracle Instance (ORASID) for the repository.
• JDBC Driver (oracle.jdbc.OracleDriver).
• JDBC Path (ojdbc17.jar for Java 7).

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

• CLASS (Oracle 12c 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 account (owner).

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).
• Account 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 (latest version of sqljdbc4.jar or sqljdbc41 is required. sqljdbc42.jar is not supported).

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.