Configure DataSource in Silent Mode Using XML

A Repository DataSource is used to store all repository related data. The Repository DataSource must be created on a machine where the Central Configuration is installed.

You can configure a Data Source using the WWSKBPMConfig.xml configuration file.

For more information about the parameters in the WWSKBPMConfig.xml configuration file, see Configure in Silent Mode Using XML.

1. Open the WTLogger Console.

2. Navigate to the "Bin" folder, which is available in the path where the product is installed.

3. Open the WWSKBPMConfig.xml file.

4. In the XML file, pass the values for the following mandatory parameters.

   • ConfigurationType: Enter the value as Datasource.

   • DataSourceName: Enter the name of the datasource to be created.

   • Description: Enter the description for the datasource.

   • ServerName: Enter the database server or instance name.

     To use a database on the local machine, enter "localhost", ".", or the local computer’s name for the Server Name.

     For SQL Server database type, specify IPv4 and IPv6 addresses for the Server Name.

     To use SQL Server AlwaysOn Availability Groups, enter the SQL AlwaysOn Group name or the IP address, and the port number (separated by comma). For example: localhost,1455

     To use SQLExpress instance as a database instance of the repository database, the Server Name must be <server name>\<instance name>.

   • AuthenticationType: Enter the type of process to validate a user who is trying to connect to the database.

     AVEVA Work Tasks uses Windows or SQL Server authentication process. SQL Server authentication requires a user ID and a password already defined in the SQL Server database.

     For Example: Windows or SQLServer

   • UserId: Enter the ID of the user who is trying to connect to the database.

   • Password: Enter the password of the user.

   • PasswordEncrypted: Enter either "true" or "false".

     If the value is set to "true", then the user has to enter the password in encrypted format.

     If the value is set to "false", then the user has to enter the password in plain text.

   • AdvanceSettings: Enter the advanced connection settings like providing the time (in seconds) that a connection string must wait to connect to the database server before terminating the connection.

     Example: Connection Timeout = 20;

   • DatabaseName: Enter the name of the database that can be used as a datasource.

   • EnableTablePartition: Select to enable database table partitioning by entering either "true" or "false".

   • DatabaseSecondaryDataFilePath: Enter the database secondary data file path, which should be on a Microsoft SQL Server machine with sufficient rights to create files on the specified path. Ensure, you provide a valid path as it is not validated by the business application. If the path is not specified, then the secondary database file will be created at the default path, where the primary database file exists.

   Note: If EnableTablePartition is set to true for a SQL Server version that does not support table partition, then the data source is created without a table partition.

5. Save the XML file.

6. Run the AVEVAWorkTasksConfigurator.exe.

   The configuration progress is displayed in the WTLogger Console.