Storage Locations are designated databases that store historical data from Tags on their Historian Tables. It works as the central storage point for this time-series data, enabling long-term trending and analysis essential to industrial processes. System administrators define Storage Locations and configure connection parameters to the chosen database. Historian Tables are then linked to a specific Storage Location, dictating where the table's data will be physically stored. This association ensures the structured organization of historical process information.
On this page:
Table of Contents | ||||
---|---|---|---|---|
|
Understanding
ArchiveStorage Location
The Archive Storage Location defines where Tag data will be archived considering the Historian Tables configuration, establishing a clear linkage between tags and the storage infrastructure. When configuring the Archive Storage Location, you can use:
- SQL databases
- Script Classes
- Connections with a Third-Party Historian
When you set the Archive Storage Location, you specify the storage medium for Tag data.
By default, the platform uses a SQLite database. You can change the default database or add additional databases if you need to use different ones.
Configuring the Default Database
You have several options to choose from when defining the default database. If you would like to change the default database to be something other then the initial SQLite built-in database, follow the steps below:
- Access Historian → Archive Storage Locations.
- Click on the gear icon to open the Dialog.
- Define the default database configuration, defining Provider, Database, and Server IP.
- Test the database connection. Provide the necessary authentication information and click Test.
- Click OK to update the default database.
Available Databases
The following table provides a list of accepted providers and databases for configuring the default options.
Provider | Databases |
---|---|
SQLite | SQLite |
Odbc |
|
OleDb |
|
OracleClient | Oracle |
SqlClient |
|
PostgreSQL | PostgreSQL |
Add a new
ArchiveStorage Location
If you would like to add additional databases, follow the steps below to add and configure them.
- Access Historian→ Archive Storage Location.
- Click on the plus icon.
- On the Dialog, configure the new database. You find the description of each option available in the next section of this documentation page.
- Click Ok.
Storage Location Properties
The table below describes the configuration options available when adding a new Archive LocationStorage Location.
Property | Description |
---|---|
Name | A unique name to identify the new Archive LocationStorage Location. |
Description | Optional description to provide more context or information. |
Store and Forward | If you check this option, the platform will store data locally in case of connection failure with the external database. The data is transferred when the connection is established. |
Archive System | Types available to configure the Archive Storage Location. Currently, two options are available:
|
Protocol (Only available if using Tag Provider) | Defines the protocol used by the External Tag Provider. Currently, you can use the following options:
|
Station Editor (Only available if using Tag Provider) | Configure the connection string to the selected provider and run a test to ensure the setup is correct. |
In this section:
Page Tree | ||||
---|---|---|---|---|
|