Historian Storage Locations (Reference)

Historian → Tutorial | Concept | How-to Guide | Reference

Understanding Storage Locations

The Storage Location defines where Tag data will be archived establishing a clear linkage between tags and the storage infrastructure. When configuring the Storage Location, you can use:

• SQL databases

• Script Classes

• Connections with Third-Party Historians, Like Canary and others. 

When you set the Storage Location, you specify the storage system for Tag data.

By default, the platform uses an SQLite database. You can change the default database or add additional databases if you need to use different ones.

Storage Types

SQL Databases (Default)

Built-in database support with TagHistorian object:

• SQLite (default, embedded)
• SQL Server
• PostgreSQL
• Oracle
• MySQL
• MS Access
• Firebird

Tag Providers

External historian systems:

• CanaryLabs - Industrial historian with compression
• InfluxDB - Time-series database
• GE Proficy - Enterprise historian

Script Classes

Custom storage implementations:

• User-defined archiving logic
• Custom data transformations
• Third-party integrations
• Cloud storage adapters

Default SQL Database Configuration

Modifying Default Database

1. Navigate to Historian → Storage Locations
2. Click Settings icon ??
3. Configure:
   • Provider: Database type
   • Database: Specific database
   • Server IP: Connection endpoint
4. Test connection with credentials
5. Click OK

Supported Providers and Databases

Adding Storage Locations

Configuration Steps

1. Go to Historian → Storage Locations
2. Click Plus icon ?
3. Configure properties (see table below)
4. Click OK

Storage Location Properties

Store and Forward

Operation

When enabled, provides data integrity during connection failures:

1. Connection Lost - Data buffered locally
2. Local Storage - SQLite database cache
3. Reconnection - Automatic retry
4. Data Transfer - Batch synchronization
5. Cleanup - Buffer cleared after success

Configuration

StoreAndForward: True
Buffer Location: Local SQLite
Retry Interval: 5 seconds
Batch Size: 250 rows

Best Practices

• Always enable for critical data
• Monitor buffer growth
• Plan disk space for buffering
• Test failover scenarios

Tag Provider Configuration

CanaryLabs

Industrial historian with high compression:

Protocol: CanaryLabs
Connection: Server=hostname;Port=12345
Features: Compression, Aggregation, Web API

InfluxDB

Open-source time-series database:

Protocol: InfluxDB
Connection: http://server:8086;Database=mydb
Features: High throughput, SQL-like queries

GE Proficy

Enterprise historian platform:

Protocol: GEProficy
Connection: Server=hostname;Username=user
Features: Enterprise integration, Analytics

Script Class Storage

Implementation Requirements

Script class must implement:

csharp

public class CustomStorage
{
    public void StoreData(string table, DateTime timestamp, 
                         Dictionary<string, object> values)
    {
        // Custom storage logic
    }
    
    public DataTable RetrieveData(string table, 
                                  DateTime start, DateTime end)
    {
        // Custom retrieval logic
    }
}

Use Cases

• Cloud storage (AWS, Azure)
• Custom file formats
• NoSQL databases
• Message queues
• Data transformation

Connection Strings

SQL Server

Server=hostname\instance;Database=HistorianDB;
User Id=sa;Password=pwd;

PostgreSQL

Host=localhost;Database=historian;
Username=user;Password=pass;Port=5432;

Oracle

Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)
(HOST=server)(PORT=1521))(CONNECT_DATA=
(SERVICE_NAME=orcl)));User Id=hr;Password=pwd;

MySQL

Server=localhost;Database=historian;
Uid=root;Pwd=password;Port=3306;

Performance Considerations

Database Selection

Optimization Tips

1. Partition large databases - By time or tag groups
2. Index appropriately - Timestamp always indexed
3. Regular maintenance - Archive old data
4. Monitor performance - Query execution times
5. Size buffers correctly - Store and Forward capacity

Multiple Storage Locations

Concurrent Storage

Configure multiple locations for:

• Redundancy
• Performance distribution
• Specialized storage
• Migration scenarios

Assignment Strategy

High-frequency data → Local SQLite
Production records → SQL Server
Compliance data → CanaryLabs
Temporary data → InfluxDB

Troubleshooting

Connection failures:

• Verify connection string
• Check network connectivity
• Confirm credentials
• Test firewall rules

Store and Forward issues:

• Check disk space
• Monitor buffer database
• Verify retry logic
• Review error logs

Performance problems:

• Analyze query patterns
• Check index usage
• Review table sizes
• Monitor network latency

Data not storing:

• Confirm table assignment
• Check storage location status
• Verify permissions
• Review trigger configuration

Best Practices

• Test connections - Before production deployment
• Enable Store and Forward - For critical data
• Document configuration - Connection strings and settings
• Plan capacity - Size databases appropriately
• Monitor health - Track connection status
• Backup regularly - Especially configuration
• Use appropriate storage - Match technology to requirements
• Secure connections - Encrypt sensitive data

In this section...