What are the prerequisites that we need to consider before integrating new Silktest workbench 12.0 with SCTM 12.0?

[rajendra_penumalli]

[Migrated content. Thread originally posted on 14 May 2012]

What are the prerequisites that we need to consider before integrating new Silktest workbench 12.0 with existing SCTM 12.0?

[Mark H1]

Hi Rajendra

Please see following SCTM help topics that detail SCTM prerequisites:-
- System Requirements and Prerequisites.
- Pre-Installation Requirements.

With regards to SCTM/Workbench integration please note:
- The Microsoft Office Access database type is not supported (Must be Oracle or SQL Server).
- When connecting to a SilkTest Workbench Oracle database, there is a SilkTest Workbench requirement that the TNS name must be the same as the host server name.

Mark

[rajendra_penumalli]

Hi Mark,

Thank for reply,

Could you elaborate the following lines:
"When connecting to a SilkTest Workbench Oracle database, there is a SilkTest Workbench requirement that the TNS name must be the same as the host server name."

Thanks,
Rajendra

[Mark H1]

Hello Rajendra

This is documented in SCTM help section: "Adding SilkTest Workbench Source Control Profiles". If you have any further technical queries, please log a new incident to support.

Mark

[MichaelBr]

Hi Rajendra,

To expand on your question regarding the following line: "When connecting to a SilkTest Workbench Oracle database, there is a SilkTest Workbench requirement that the TNS name must be the same as the host server name."

What this means is that if you are using an Oracle database for SilkTest Workbench when you connect this to SCTM you will need to map the host name of the machine where Oracle is installed to the instance name using the 'tnsnames.ora' file. This file is normally contained in the "ORACLE_HOME\network\admin".

For example the tnsnames.ora file should follow this format:

=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = )(Port = ))
)
(CONNECT_DATA =
(SERVICE_NAME = )
)
)

Please see the knowledge base article here for more information on this.

Let me know if you need any further clarification on this.

Thanks
Michael