Repository Connection Information

In this section:

How to:

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


Top of page

x
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:

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


Top of page

x
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:

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

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.


Top of page

x
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:

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

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.


Top of page

x
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:

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

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


Top of page

x
SQL Server 2014, 2012, 2008, and 2005 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 Pre-Installation Steps.

During the WebFOCUS Client installation, you are prompted for:

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

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.


Top of page

x
Procedure: How to Enable TCP/IP in SQL Server 2014, 2012, 2008, and 2005

SQL Server 2014, 2012, 2008, and 2005 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.

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

    A list of valid network protocols for 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.

WebFOCUS