OPC Data Logger - Database Logging

Supported Databases

Always check the OPC Data Logger System Requirements FAQ for more specific details 

• Microsoft SQL Server & SQL Express
• Microsoft Azure SQL 
• Microsoft Access
• MySQL (via native driver)
• Oracle (via Microsoft driver)
• ODBC Compliant Databases 

You must own the necessary licenses including any client access licenses, for your selected databases. OPC Data Logger does not include any database licenses.

Table Builder Accelerates Configuration

As you configure OPC Data Logger Data Storage, you can choose to have it create tables for you in your database, provided the login that you are using for the database has the required permissions and you are using the Data Logger Managed SQL method of logging. 

Tables can be auto-generated from the tagnames and storage format specified in your Data Presentation to further save you time. 

When using Stored Procedures, the table needs to already exist, though you could make it with OPC Data Logger, go to the database manager and add your stored procedures, then come back and change to using Stored Procedures.