Create Repository DataSource

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

Example

A TelematicsDataSource is created for TelematicsHR Repository.

A Repository contains Workflow definitions, Queues, Calendars, Workflow execution data, and Business Activity Monitoring (BAM) data. The Resource Provider for the repository is also defined while creating the repository.

To create a Repository DataSource

1. On the Windows Start menu, point to Programs, point to AVEVA, and then right-click Central Configuration.

   The Central Configuration web page appears.

2. Click DataSource Settings.

   The Datasource List page appears.

3. Click Add.

   The Manage Datasource page appears.

4. Enter the required details.

   1. Name: Enter a valid data source name. Example: TelematicsDataSource.

   2. Description: Enter a description for the data source. Example: This data source is used to store connection details.

   3. Connection String: Select this option to establish a connection with the database. The connection string contains fields that that defines the connection. The connection information is encrypted and stored.

      Server Name

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

      Note: Server Name can be machine name/IP address/SQL Server AlwaysON/SQL Server instance name. Instead of entering "local host", it is preferable to give the local machine name.

      If the Database Type is SQL Server, then specify an IPV6/IPV4 address 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>\SQLExpress.

      Authentication Type

      Use this field to determine the process to validate a user who is trying to connect to the database. AVEVA Work Tasks uses Windows and SQL Server authentication process. SQL Server authentication requires a user ID and a password already defined in the SQL Server database. The User ID and Password field is disabled if Windows Authentication is selected. Example: Windows

      Note: The repository database password does not support special characters & ; =.

      Advanced Settings

      Use this field to define 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

      or

      For defining maximum connections that can be opened in a connection pool.

      Example: max pool size = 250

      Default connection pool is set as 250. We recommend to enter a higher value on heavily loaded environment.

      While creating a data source for a repository, use the following custom settings to set properties for the connection pool.

      encrypt=true; enableltm=true; connectionretrywaittime=30; maxconnectionretries=10; sqlcommandtimeout=300;

      encrypt: Ensures secure communication between AVEVA Work Tasks Server and SQL Server when a certificate is installed on the SQL Server for SSL encryption.
      

      enableltm: AVEVA Work Tasks internally implements the light weight transaction mode by reusing the connection which is already open within the same transaction. With this implementation, a connection which is used from a transaction is returned back to the connection pool only when the transaction is completed. Since the same connection is used within the transaction, the transaction becoming distributed is reduced to a great extent. With this feature, AVEVA Work Tasks controls the transaction from escalating to an expensive distributed transaction.

      The above property can be used to turn off this feature. The default value is set as True.

      connectionretrywaittime: While opening a new connection, if the database server is not available, the default behavior is to retry for the connection. This setting can be used to set the wait time for retry for a new connection. The default value is 30 seconds. The value should be set in seconds.

      maxconnectionretries: While opening a new connection, if the database server is not available, the default behavior is set to retry for a new connection. This setting can be used to set the retry count. The default value is infinite.

      sqlcommandtimeout: Sets the wait time before terminating the attempt to execute a SQL command and generating an error. The default value is set as 300.

      These settings are case sensitive and should be mentioned only in lower case.

      Database:

      Specify or select a database that can be used as a repository database. This database stores all repository related data. The repository database is created if it does not exist on the database server instance. Example: TelematicsDB

      Enable Table Partitioning:

      Select to enable database table partitioning. For more information, see Partitioning Database.

   4. Connection Provider: Use this to provide connection related information from a Dynamic Link Library (dll). Connection related details are encrypted and stored in the library.

      The selected dll must be copied to all the machines, all servers and all clients, that are connected to the current Farm.

      Assembly Path

      Click to browse and choose the required dll file.

      To use custom properties (enableltm, connectionretrywaittime, maxconnectionretries, and sqlcommandtimeout) in the Assembly connection string, the database must be created before.

      See Implementation of IDBConnectionString Interface under Data source Related Code Samples sub-chapter in the Developer Guide for creating the assembly. Ensure that there is only one class implementing IDBConnectionString interface within this assembly.

5. Click Test Connection to ensure database connectivity.

   A message about successful test connection appears.

6. Click OK.

   A message about successful creation of the data source appears.The message also states that the required tables will be created in the data source after a repository is associated with the data source.

When a data source is saved, an entry is created for the data source in the Farm Database. When a first repository is created for the data source, AVEVA Work Tasks tables are added to the data source. While creating a data source, the archival database is created with the same database name suffixed by _BI. This database is used for archival in future use.

Note: After you configure the AVEVA Work Tasks, you must add the created Farm Database to the SQL Server AlwaysOn Availability Groups. Contact your Database Administrator to add the database to SQL Server AlwaysOn Availability Groups.

To view the data source created, click DataSource Settings link.