Repository Connection Information

The connection information varies depending on the type of driver and database.

• For Db2, see Db2 Connection Information.
• For Derby, see Derby Connection Information.
• For MySQL, see MySQL Connection Information.
• For Oracle, see Oracle Connection Information.
• For SQL Server, see SQL Server Connection Information.
• For other repositories, refer to the documentation for your JDBC driver.

Db2 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

Derby Connection Information

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 (WebFOCUS93, 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 (derbytools.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.

MySQL Connection Information

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.

Oracle Connection Information

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 (ojdbc8.jar).

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

SQL Server Connection Information

In Microsoft SQL Server, you create a database and user ID within a SQL Server Database Server. These steps are described in SQL Server Preinstallation 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. At installation, upgrade, or configuration time, the account used by the WebFOCUS installation process to connect to the repository database must be granted db_datawriter, db_datareader, and db_ddladmin roles on the repository database and schema. Alternatively, the object creation and initial data load may be run as a separate utility by a DBA.
• JDBC Driver (com.microsoft.sqlserver.jdbc.SQLServerDriver).
• JDBC Path (type the full path to the JDBC driver). See the ibi™ WebFOCUS® Release Notes for supported versions of JDBC drivers.

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

• CLASS:

  com.microsoft.sqlserver.jdbc.SQLServerDriver

• URL:

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

  jdbc:sqlserver://hostname:port;DatabaseName=databasename

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.