Skip to main content

Storage

The plug-ins in this section connect the OPC Router to systems that store data permanently: databases of all types, as well as files and object storage. A connection set up in this way is then available in flow configuration as both a data source and a data destination.

The key factor in making a selection is the format in which the target system stores the data: as tables in a relational database, as time series, as documents, as files—or as a data platform in the cloud.

The pages in this chapter​

Databases:

  • Relational databases—database plug-ins for Microsoft SQL Server, Oracle, PostgreSQL, MySQL, SAP HANA, ODBC, and OLE DB, including their shared transfer objects, triggers, and filter operators.
  • Snowflake – bidirectional data exchange with the Snowflake AI Data Cloud: structured writing of operational data for analysis and reporting, reading data for feedback and follow-up processes.
  • File-based databases – Microsoft Access, SQLite, and dBase, i.e., databases without their own server service.
  • Time-series databases – InfluxDB 1.7 as well as InfluxDB 2.0/3.0 and Cloud for metrics that are recorded with their timestamps.
  • Document-oriented databases – MongoDB, which stores data not as table rows but as JSON documents.

Files and object storage:

  • Microsoft Excel – read and write access to files, spreadsheets, and cells.
  • Local files – read, write, and delete files on the router computer, using the file trigger.
  • Network File Access – File transfer over the network via FTP and SMB, with the same read, write, and delete operations.
  • Cloud File Access – Azure Blob Storage and S3-compatible object storage.

What all database plug-ins have in common​

The relational database plug-ins share connection settings, transfer objects, triggers, and filter operators; the plug-in-specific pages describe only the unique features of their respective database systems. Start with the Relational Databases page, which contains links to the common topics:

Snowflake includes its own transfer objects, triggers, and a custom filter, but follows the same structure.

The pages that pertain solely to Microsoft SQL Server—Authentication, configuration, SQL Server Procedures, Service Broker, and Performance Guide—are located under the Microsoft SQL Server plug-in.