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
Informix Connection Information

In Informix, you create a database and user ID within an Informix 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 Informix 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 2012, 2008, and 2005 Connection Information

In Microsoft SQL Server, you create a database and user ID within a SQL Server 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 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 2012, 2008 and 2005

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

Top of page

x
Sybase SQL Anywhere Connection Information

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

During the WebFOCUS Client installation, you are prompted for:

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.

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

For example:

jdbc:sybase:Tds:aixppc61:4954/casterdb

Top of page

x
Teradata Connection Information

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

During the WebFOCUS Client and ReportCaster installation, you are prompted for:

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:

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.


WebFOCUS