Microsoft Access DB Plug-In for OPC Router - License type: Subscription license for 1 year
This OPC Router plug-in enables you to connect the OPC Router to the Microsoft Access database. The plug-in is an OPC Router accessory. More
Code: OPCR-MSACCE-SUB-PROD
This OPC Router plug-in enables you to connect the OPC Router to the Microsoft Access database. The plug-in is an OPC Router accessory. More
Code: OPCR-MSACCE-SUB-PROD
Options 9
| License type | Code | Availability | Price excl. VAT | |
|---|---|---|---|---|
| Subscription license for 1 year | OPCR-MSACCE-SUB-PROD | In stock |
465 EUR
|
|
| Subscription license for 2 years | OPCR-MSACCE-SUB-PROD 2x | In stock |
930 EUR
|
|
| Subscription license for 3 years | OPCR-MSACCE-SUB-PROD 3x | In stock |
1 395 EUR
|
|
| Perpetual (permanent) license with 1 year support | OPCR-MSACCE-PRP-PROD + OPCR-MSACCE-ATT-PROD | In stock |
1 081 EUR
|
|
| Perpetual license with 2 years support | OPCR-MSACCE-PRP-PROD + OPCR-MSACCE-ATT-PROD + OPCR-MSACCE-EXT-PROD | In stock |
1 283 EUR
|
|
| Perpetual license with 3 years support | OPCR-MSACCE-PRP-PROD + OPCR-MSACCE-ATT-PROD + 2x OPCR-MSACCE-EXT-PROD | In stock |
1 485 EUR
|
|
| Perpetual license support extension for 1 year | OPCR-MSACCE-EXT-PROD 1x | In stock |
202 EUR
|
|
| Perpetual license support extension for 2 years | OPCR-MSACCE-EXT-PROD 2x | In stock |
404 EUR
|
|
| Perpetual license support extension for 3 years | OPCR-MSACCE-EXT-PROD 3x | In stock |
606 EUR
|
OPC Router is a software program that allows you to connect data from various industrial devices and IT/OT systems to each other. All this quickly, automatically and without programming knowledge. In addition, you can see all data flows in a clear visualization.
Collect data, connect systems, perform calculations, compare values and enter results into databases. You can do all this with OPC Router for PLC systems, OPC servers, printers, RFID readers, emails, Excel spreadsheets, databases, cloud systems, MQTT brokers, ERP systems SAP R3, SAP HANA, etc. For installation on a single computer you need a basic module and one or more plug-in modules.
Microsoft Access Plug-In
Access is a small but useful Microsoft database. It is used in office settings as well as for smaller system setups. More demanding applications are not suitable for Access because of lack of multiple user profiles and a limited performance scope. The OPC Router connects Access databases to other systems within the higher system architecture of any company.
System Requirements
Installation and Update
The OPC Router setup installs the configuration environment, Windows services and all plug-ins in demo mode with a runtime of 2 hours. Licensed plug-ins can only be run without time limitation after entering the license key.
The installation does not include a database system or an OPC server for production use. These components must be installed separately and then connected in the OPC Router configuration.
Computer Performance
OPC Router is a server application, so we recommend running it on suitable hardware. For standard use, we recommend:
- a multi-core processor,
- at least 8 GB RAM,
- SSD storage.
Operating System
For production use, we recommend Microsoft Windows Server operating systems. 64-bit client operating systems can also be used, especially for testing purposes.
Supported operating systems:
- Windows Server 2016 x64
- Windows Server 2019 x64
- Windows Server 2022 x64
- Windows Server 2025 x64
- Windows 10 x64
- Windows 10 IoT x64
- Windows 11 x64
Running in Docker
OPC Router can also be run in a Docker container, for example on an Edge device or a Windows device. The minimum requirements for running OPC Router in a Docker container are:
- 64-bit single-core 600 MHz CPU with AVX support,
- 512 MB RAM,
- 3 GB of free disk space.
.NET 8
OPC Router requires .NET 8. If it is not installed on the system, the OPC Router setup will install it if necessary.
In production environments, we recommend installing .NET 8 manually from Microsoft before updating OPC Router. The .NET installation may require Windows updates, take longer to complete and sometimes require several restarts. To reduce downtime, we recommend uninstalling older .NET versions only after .NET 8 has been installed successfully.
OPC Server
To connect controllers via OPC, an installed and accessible OPC server must be available. OPC Router supports connections via OPC DA 4.0, OPC UA and OPC XML.
The corresponding OPC plug-in is required for communication with an OPC server.
Database Server and Data Sources
Database servers are not part of the OPC Router installation. If you want to connect them to OPC Router, they must be installed and made accessible separately.
OPC Router supports connections to the following database systems and interfaces:
- Microsoft SQL Server
- Oracle
- MySQL
- SAP HANA
- OLE DB
- systems accessible via ODBC
The following databases, data sources or files can also be connected:
- MS Access
- SQLite
- dBase
- InfluxDB
- MongoDB
- XML files
Plug-ins for database communication are not included in the Basic license. The appropriate plug-in must be selected for the specific type of database connection.
Oracle Database Connection
To connect to an Oracle database, Oracle Instant Client (ODAC) must be installed.
SAP Plug-in
The SAP Plug-in supports SAP systems version 4.0b and higher. SAP Logon Pad or the librfc32.dll library must be installed on the computer running OPC Router.
To use SAP NetWeaver, SAP NetWeaver RFC SDK must be installed.
The SAP Plug-in is a separately licensed module and is not included in the Basic license.
New features in the OPC Router 5.1 data hub
The new version of OPC Router 5 brings some big changes. The biggest change is the user interface, which brings the user more comfort when working with the program and the ability to work in Linux, macOS, etc. There are also new options for creating user accounts, improvements in application performance optimization and many other improvements.
Connect Your Machines to IT Systems Yourself
The OPC Router program communicates with all OPC servers via the OPC DA or OPC UA protocol. As a result, OPC Router can read data from and write it to all PLCs on the market. And so far, we’ve used only a single OPC Client plug-in module. What else can you connect yourself using additional plug-in modules? Read our article.
OPC Router: 3 Reasons to Choose the New Packages
OPC Router is smart software that allows you to easily connect data from industrial devices to IT/OT systems without the need for programming. Everything is fast and automated, with clear visualisation showing all data flows in real time. You no longer need to purchase individual plug-ins (connectors) separately, as you can now purchase a convenient package containing the most commonly used ones. Alternatively, you can have all plug-ins and add-ons (extensions) in one licence at a great price with the "All in One" package.
Collection & Integration of Machine Data, 3-in-1: Value Bundle — KEPServerEX + DataLogger + OPC Router
Want to streamline production and keep consumption, downtime, or machine condition under control? Looking for a simple yet robust way to connect your machines with IT systems? We’ve put together a bundle for collecting, storing, and integrating machine data that stands out not only for its price but also for its completeness.
OPC Router 5.5: Cloud Integration, Data Standardization, and AI Features
The new version of the data connector brings major improvements for data processing, data standardization, and connecting to artificial intelligence. The features in version 5.5 create an end-to-end data flow—from collecting information at machine level to analyzing it in an AI cloud. The new version also brings the Snowflake plug-in.
OPC Router 5.6: Speed up deployment with the Solution Gallery
A new feature in the OPC Router 5.6 data connector is the Solution Gallery — a gallery of preconfigured integration solutions. Its goal is to speed up project deployment and reduce manual configuration. Instead of building an integration from scratch, you can use a ready-made template, fill in the required parameters, and launch the project immediately.
Highlighted items are mandatory.
OPC Router – Basic Module
286,77 EUR Incl. VAT
Related products1
OPC Router – Basic Module
286,77 EUR Incl. VAT