Page History

Understanding ArchiveLocationArchive Location

The Archive Location defines where Tag's data will be archived considering the Historian Tables arrangement. ArchiveLocation involve the organization of tags within Historian Tables, establishing a clear linkage between tags and the storage infrastructure. The ArchiveLocation can take the form of a SQL database, a ScriptClass, or a connection You can use SQL databases, ScriptClasses, or connections with a Third-Party Historian .

Definition:

ArchiveLocation encompass the systematic arrangement of tags within Historian Tables, establishing a direct association between tags and the chosen storage medium, which can be a SQL database, a ScriptClass, or a connection with a Third-Party Historian.

Purpose:

The purpose of ArchiveLocation is to provide a structured framework for tags, ensuring their efficient storage and retrieval within Historian Tables, by defining the specific storage medium used.

Function:

ArchiveLocation function as a crucial element in the organization of data, enabling the systematic grouping of tags and the efficient archival of data based on the selected storage medium.

Operation:

In operation, ArchiveLocation specify the storage medium for tags within Historian Tables, allowing for the seamless storage and retrieval of tagged data through a SQL database, a ScriptClass, or a connection with a Third-Party Historian.

Application:

ArchiveLocation find application in the structured organization and storage of tagged data within Historian Tables, particularly by defining the chosen storage medium for optimal data management.

Usage:

when configuring the Archive Location. In other words, when you set the Archive Location, you're specifying the storage medium for Tag's data.

By default, FrameworX uses an SQLite database. You have the option to change the default database or add additional databases, in case you need to use different databases.

Configuring The Default Database

You have several options to choose from when defining the default database. In case the default SQLite option does not work for you, you can change it by following the steps below:

1. Access Historian → Archive Locations.
2. Click on the gear icon to open the Dialog.
3. Define the default database configuration, defining Provider, Database, and ServerIP.
4. Test the database connection. Provide the necessary authentication information and click Test.
   
5. Click OK to update the default database.

Available Databases

The next table list all accepted Providers and Databases when configuring the default database.

Configuration

On Historian tab, click on ArchiveLocation and the + button.

Fields:

• Name: Unique name for the Target Database.
• Description: Optional description to provide more context or information.
• Store and Forward: Option to temporarily store data in case of connection failure to the destination.

Target Type:

You have two options to choose from:

1. ExternalTagSource: In this option, you can select from different ExternalTag Providers such as CanaryLabs, InfluxDB, and GEProficy.

   • Station: Here, you configure the connection string to the selected provider and run a test to ensure the setup is correct.

2. ScriptClass: If you opt for this type, you'll need to either create a script class or point to existing classes that will define how the data will be handled and stored. For help creating classes, see the Script, Classes and Tasks documentation.

In this section...