How can I perform a Silent Install of Silk Test including the ODBC configurations?
While Silk Test offers the ability to perform a silent install the ODBC are required to be setup manually. Once the complete setup has been performed on a single machine we can use the following steps to install the Silk Test with ODBC configuration silently on other machines.
1) On the machine where Silk Test Workbench has been installed and configured open the registry editor. If you enter ‘regedit’ into the Windows search field and press enter, the registry editor will open
2) We will now search for the location of where the ODBC connections are stored in the registry. In a 64 bit machine the location will be:
- HKLM\SOFTWARE\Wow6432Node\ODBC\ODBC.ini\ODBC Data Sources
3) Within this node please ensure that the name of the Silk Test Workbench ODBC you require is listed.
If the name of the datasource is not listed you will need to manually add it as follows:-
i) Right Click the folder ‘ODBC Data Sources’
ii) Select New Key -> String Value
iii) Enter the datasource name in the name field and ODBC Driver name in the value field. If you are unsure of this information start the 32-bit "ODBC Data Source Administrator" which will contain the details of the Silk Test Workbench ODBC.
iv) To start the 32-bit "ODBC Data Source Administrator" enter ‘odbc32’ into the Windows search box and press the return key
4) Within the registry editor click the key ‘ODBC Data Sources’ and navigate to File -> Export
5) Enter a name for the registry file, in this example I have named it ‘STWB_DataSources’, ensure that ‘registration files’ is the Save as type.
6) Click Save
7) Locate the saved file, perform a right click on the file and select ‘Edit’
😎 Select all Datasources that we do not wish to use for our silent install and remove them.
9) Your file should resemble the image below:
10) Save the file.
11) Return to the registry editor
12) In this example I wish to capture the ‘STWB_18’ entry for a SQL Server ODBC, select the registry key that you wish to connect to.
13) Within the Registry Editor navigate to File -> Export
14) Enter a name for the registry file, in this example I have named it ‘STWB_ODBC’, ensure that ‘registration files’ is the Save as type.
15) Click ‘Save’
16) Locate the saved file, perform a right click on the file and select ‘Edit’
17) Copy the entry from the file ‘STWB_DataSources’ and paste it to the top of the file ‘STWB_ODBC’.
18) Your file should resemble the image below:
19) Save and close the file.
20) Close the registry Editor
21) Navigate to C:\ProgramData\Silk\SilkTest Workbench\
22) Copy the file ‘DSNConfiguration.ini’ and place it in the same directory as the saved registration files.
23) Locate the install guide for Silk Test and review the section ‘Silk Test Silent Mode Installation’ for details on how to create and configure the SilentInstall.properties file. The Silk Test installation guide will reside in the documentation folder of the Silk Test installation directory.
24) You should now have a SilentInstall.properties file created
25) Place the SilentInstall.properties file, Silk test installation file and registration files in the same folder.
26) We will now create a batch file that will install Silk Test followed by the ODBC registry entries. Open notepad and create a new file.
27) Open Notepad and paste the following, amending the details where highlighted in red:
title Installing Silk Test Workbench and ODBC configurations
@echo Starting installation of Silk Test Workbench
::Change directory to where Silk Test installer resides
CD /D C:\SilkTestInstall
@echo Directory changed to location of Silk Test executable
::install Silk Test With Silent Command
::include name of SilkTestInstallation .properties file the contains the settings for the silent install.
START /wait silktest-180.exe -i silent -f SilkTestSilentInstall.properties
@echo Silk Test installed
::Sleep for 3 seconds
@echo Importing registry key file for Workbench ODBC
reg import STWB_ODBC.reg
::Sleep for 3 seconds
@echo replacing Silk Test Workbench DSN file
::Provide the file path of the DSNConfiguration.ini file you copied earlier
xcopy /s /f "C:\SilkTestInstall\DSNConfiguration.ini" "C:\ProgramData\Silk\SilkTest Workbench\DSNConfiguration.ini" /y
28) Save the file as 'install_ST_WB_ODBC' with a .bat extension and ensure to set the ‘Save as type’ option to ‘All files’
29) The file 'install_ST_WB_ODBC.bat' can now be used to start an installation of Silk Test Workbench on other machines and ensuring the ODBC conncections are installed and configured also.