Data repository
- Last UpdatedMar 26, 2025
- 2 minute read
AVEVA™ Production Management enables you to capture data based on specified events. The data is stored in a relational database called the Data Repository. There is only one Data Repository for your project: a Microsoft SQL Server data repository.
The data repository item has several properties to configure properly for the item to the connect to the SQL Server.
Data repository properties
Refer to the following tables for the key configurable properties of data repository.
Connection properties
|
Property |
Description |
Valid values |
|---|---|---|
|
AuthenticationMode |
The mode by which the user is authenticated. Windows authentication means that the data repository item attempts to connect to the SQL server with the security account that is running Server. Typically, the server runs the service with a local system account. If the mode selected is SQL Server, then the extra properties UserId and Password must be filled out and this is the SQL Server user to which the data repository attempts to connect. |
Windows or SQL Server |
|
ComputerName |
The name of the SQL Server host computer. If the SQL Server is the same computer as the server, then localhost, the period symbol (.) or leaving the property blank are also valid. |
Any valid computer name |
|
Database |
The name of the database to store the captured data. |
Any valid SQL Server database name |
|
Instance |
The SQL instance on the computer. Typically, this value is the same as the ComputerName property and can be left blank. However, if the instance is different to the computer name, then fill this value out. |
|
|
NetworkLibrary |
Typically, this can be left blank, but you can select any of the protocol types to use. This is dependent on the way the SQL server is installed and the network infrastructure. If blank does not work, then contact your system administrator. |
TCP/IP, Named Pipes, Multiprotocol, Apple Talk, VIA, Shared Memory, IPX/SPX |
Miscellaneous properties
|
Property |
Description |
Valid values |
|---|---|---|
|
AutoUpgrade |
Indicates if the data repository schema is initialized automatically, or require manual initiation. |
True, False |
|
CheckModuleVersion |
At startup, validates that module tables and stored procedures are up to date. |
True, False |
|
MaxQuerySize |
The maximum number of records to return for all client requests. This includes requests from web services and web APIs. |
-1 (for unlimited number) or any valid number |