The connection information varies depending on the type of driver and database.
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:
com.ibm.db2.jcc.DB2Driver
jdbc:db2://hostname:port/DBName
where:
Is the database name for the repository.
Is the DB2 location name.
Is the host name for the DB2 server.
Is the port for the DB2 server. The default is 324.
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:
jdbc:derby://<host>:<port>/<database>
Based on this information, the installation creates the connection information:
org.apache.derby.jdbc.ClientDriver
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 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:
com.informix.jdbc.IfxDriver
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.
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:
com.mysql.jdbc.Driver
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:
Based on this information, the installation creates the connection information:
oracle.jdbc.OracleDriver
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.
During the WebFOCUS Client installation, you are prompted for:
Based on this information, the installation creates the connection information:
com.microsoft.sqlserver.jdbc.SQLServerDriver
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.
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:
A list of valid network protocols for SQL Server engine is displayed in the right pane.
A message is displayed, which indicates that the MSSQLSERVER service must be restarted before the change is applied.
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:
com.sybase.jdbc3.jdbc.SybDriver
jdbc:sybase:Tds:host:port/database
For example:
jdbc:sybase:Tds:aixppc61:4954/casterdb
WebFOCUS |