About the Database Logger

The CIMPLICITY Database Logger provides you with a seamless way to analyze your system processes and equipment performance by logging data to and reporting data from a wide variety of ODBC (Open Database Connectivity)-compliant databases.

The configuration is straightforward. You do not need to know about SQL or other ODBC database internals to configure Database Logger logging tables.

How to Install Microsoft SQL Server Express 2017 for CIMPLICITY, Part 1 Database Logger Configuration (5:20)

How to Configure Microsoft SQL Server Express 2017 for CIMPLICITY, Part 2 Database Logger Configuration (7:09)

How to Configure the Database Logger for CIMPLICITY, Part 3 Database Logger Configuration, (6:24)

Overview of the Database Logger Functionality

In the Database Logger you easily:

  • Use existing tables or create new tables that will log selected items for any one of the processes.
  • Enter specifications for how, when and to what ODBC data source you want to log data.

When you start the project in which you configured the Database Logger, the Database Logger creates tables you configured based on the attributes you specified.

  • When a project starts, the Database Logger:
  • Creates or repair any missing or damaged databases.
  • Creates any missing tables.
  • Creates any missing columns in the tables.

Creating a report is also straightforward. CIMPLICITY provides sample reports that you use in Excel. You can use these sample reports to quickly generate a report or as a basis to create new reports.

The Database Logger option uses the standard ODBC interface to log your production data.

Refer to the Readme file that accompanies this release for a list of supported database interfaces.