Open topic with navigation

Modify a generic database connection

1. In the Administration Console, click Collection Configuration > Generic Database.
   The Generic Database page opens.
2. Click Configure.
   The Connection Parameters dialog box opens.
   
3. In the Connection Parameters dialog box, type the following values:
   

Field	Description
Host name	Address (IP or name) of the generic database server.
Port	Port number to query the database server.
TimeZone	The time zone under which the database instance is configured.
Database type	The type of database engine that is used to create the generic database. It can be Sybase IQ, Sybase ASE, Oracle, or MSSQL.
Domain	Select the domain(s) for which you want SHR to collect data from the selected database type.
URL	The URL of the database instance. The syntax for the URL for each of the database types is: Oracle: jdbc:oracle:thin:@<server>:<port>:<dbInstance> MSSQL: jdbc:jtds:sqlserver://<server> <port>/<database>;instance=<dbInstance> Sybase IQ: jdbc:sybase:Tds:<server>:<port>/<database> Sybase ASE: jdbc:sybase:Tds:<server>:<port>?ServiceName=<dbInstance> where <server>, <port>, <database>, and <dbInstance> are replaceable variables that must be filled by the user.
User name	Name of the generic database user.
Password	Password of the generic database user.

4. Click OK.
5. Click Save.
   A Saved Successfully message appears in the Information message panel.