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.

A worked example of the connector settings and of the tag-to-column mapping, with screenshots, is in how to log OPC data to a SQL database. If you need a live table with the current tag values rather than a history, see OPC to SQL with Datatag Link.

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 database
• OPC to MSSQL: Writing several OPC tags to separate columns
• OPC to MySQL: Writing OPC tags to MySQL database
• OPC to a database: Writing OPC tags to a database
• OPC to SQL with Datatag Link: a live two-way link instead of a log
• 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