Configure DataSource in Silent Mode using Command-Line Parameters

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 AVEVAWorkTasksConfigurator Console Application.

1. Open the Command Prompt in the Administrative mode.

2. Enter the path for the "Bin" folder, which is available in the path where the product is installed, and then press Enter.

   For example: CD <AVEVA Work Tasks Install Path>\Bin

3. On the Command Prompt, type AVEVAWorkTasksConfigurator.exe.

4. Pass the values for the following command line arguments:

   • ConfigurationType = DATASOURCE.

     The parameter used to configure datasource.

   • DataSourceName = <The name of the datasource to be created.>

   • Description = <The description for the datasource.>

   • ServerName = <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 = <The 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 = <The ID of the user who is trying to connect to the database.>

   • Password = <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 = <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 = <The name of the database that can be used as a datasource.>

     Consider the following sample command.

     AVEVAWorkTasksConfigurator.exe ConfigurationType="DATASOURCE" DataSourceName="TelematicsDataSource" Description="Telematics Datasource" ServerName="Server1" AuthenticationType="SQLServer" UserId="skeltalab\user1" Password="****" PasswordEncrypted="false" DatabaseName="TelematicsDB"

     Note: Before you copy the sample command to the Command Prompt, it is recommended that you verify this command in a Text Editor.

     The progress of the Data Source configuration is displayed in the WTLogger Console.

     For more information about creating a datasource, see Creating a repository datasource.