OPC to a database: Writing OPC tags to a database

If you want to write data to a database other than MSSQL or MySQL described in the "Writing OPC to MSSQL" or "Writing OPC to MySQL" sections, you have the following options:

1. If there is an ODBC driver for this database, the configuration process is similar to that described in the "Writing OPC to MSSQL" or "Writing OPC to MySQL" sections. You will only have to create a table complying with the syntax of your database. For example, the Microsoft Access ODBC drivers come together with the operating system starting from Windows XP, and you can use the Microsoft Access visual development tools to create a database;

2. If it is an SQLBase, Oracle, SQLServer, Sybase, DB2, Informix, Interbase, Firebird, MySQL, or PostgreSQL database. In that case, you can use the "SQL Database Pro" data export plugin (fig.1) instead of the "ODBC database" plugin. You should download and install this plugin separately after you install the program. In this case, you also add OPC tags and select the parser, but you configure the "SQL Database Pro" plugin instead of the "ODBC database" plugin the way it is described in the manual on our website.

Fig. 1 Selecting the data export plugin

Related articles: OPC to a database: Writing OPC tags to a database

• Inserting OPC data to MS Access database through ODBC (features: adding groups and items, inserting to an ODBC database)
• Adding a timestamp in the CSV file (features: OPC groups)
• How to log OPC data to a SQL database.
• OPC to MSSQL: Writing a lot of OPC tags to MS SQL 2008 database
• OPC to MSSQL: Writing several OPC tags to separate columns
• OPC to MySQL: Writing OPC tags to MySQL 5 database
• OPC to a database: Writing OPC tags to a database
• OPC to Excel: Writing OPC data to Excel
• Filtering data by a tag value and write data to a database only when the value will change
• Filtering data out if an OPC tag value is not equal to a specified value
• Processing or storing OPC data by an event from the OPC server
• Aggregating data from multiple servers to one OPC server

OPC and DCOM Configuration on Windows 2008 and Windows 7

• Part 1. Installing OPC Core Components.
• Part 2. OPC and DCOM Configuration. Creating a user and giving access permissions.
• Part 3. Configuring the Windows 2008 and Windows 7 firewall for DCOM and OPC.
• Part 4. DCOM Configuration. Dcomcnfg.
• Part 5. OPC and DCOM Configuration. Typical problems and solutions.

OPC and DCOM Configuration on Windows 10, 11, Windows Server 2019, 2022

• Part 1. Installing OPC Core Components.
• Part 2. OPC and DCOM Configuration. Creating a user and giving access permissions.
• Part 3. Configuring the Windows 10, 11, Windows Server 2019, 2022 firewall for DCOM and OPC.
• Part 4. DCOM Configuration. Dcomcnfg.
• Part 5. OPC and DCOM Configuration. Typical problems and solutions.