Database Page

On the Database page you can connect a database with Silk Central and disconnect the database again.

If no database is connected, you will automatically be directed to the Database page.

If a database is connected, you have to log in as System Administrator and click Database to access the Database page. For more information see System Administrator.

Configure the database connection with the following UI controls:

Item Description
DBMS hostname or IP address The name of the computer hosting the DBMS (database management system). Type in the name in the format <computer name>\<instance name>.
Database System
Hostname Description
Microsoft SQL Server
<computer name>\<instance name>. For example: localhost.
Note: An instance name only needs to be provided if the DBMS was installed using an instance.
Oracle Server
<computer name> or Single Client Access Name (SCAN). For example: MyDBMSHost. If you plan on creating custom reports with direct database access, define a DBMS hostname that is available throughout the network.
DBMS type The type of DBMS you want to access, MS SQL Server or Oracle.
Port

The port on which the DBMS listens. The default port for Microsoft SQL Server, including Express, is 1433. The default port for Oracle is 1521.

Database / SID

MS SQL Server database name or Oracle SID provided by your Oracle administrator. To connect to an Oracle RAC environment, precede the SID with a slash (/).

For Oracle database administrators: Configure the Oracle SID to use the UTF-8 character set.

Username / Password
Microsoft SQL Server, including Express
Database user with sufficient credentials, or a valid Windows domain user (domain\username). When using Windows authentication, the database server must support LMv2 and NTLMv2. Single sign-on without specifying a user is not supported.
Note: If you are evaluating Silk Central, the default credentials are sa / SilkCentral12!34.
Oracle Server
Database user with sufficient credentials, provided by your Oracle administrator.
Important: For Oracle Servers, the database username must not contain periods (.).
Read-only username An optional database user with read-only rights on all tables and views in the specified database. This user is used for actions where only read rights are required, for example executing reports. This will ensure that running reports with advanced queries will not change any data in the database, as executing advanced queries could have a detrimental effect on the data. Accessing the database with a read-only user also has a positive impact on performance.

If your DBMS is Microsoft SQL Server and you create a new database, Silk Central automatically creates this user if you specify a name and password. If your DBMS is Oracle or you already have an existing MS SQL database, your database administrator needs to create the user first, before you can specify it on the Database page.

The Oracle read-only user has to have the following privileges in the Silk Central database schema:
  • READ on all tables and views
  • READ, INSERT, DELETE on the table SCC_TEMPTABLE0
Read-only password

Valid password for the specified Read-only Username.

DBMS version info

Displays DBMS and operating system version information.

ALM repository ID Displays the ALM URI of the repository.
Connect Database / Disconnect Database

Click this button to connect to or disconnect from a DBMS.

Note: If the version of the execution server is an invalid older version, but later than version SilkCentral Test Manager 2009 SP1, the execution server is automatically upgraded to the current Silk Central version. Silk Central shows a message concerning the upgrade in the Information column in the list of execution servers. As long as the upgrade procedure is not complete, the upgrading execution server is not used.