Litmus Production Record Database

An executable to setup Litmus Production Record Database inside MSSQL Server

Objective

When operating a manufacturing process, a wide variety of events can occur. This can include but is not limited to:

    • the start and finish of a production operation or step
    • the start of finish of an interruption
    • the moving of a product through a production line

The Litmus Production Record Database is designed to allow Customers full freedom to record exactly this wide range of events also known as Production Records.
The data are stored in an ISA 88 compliant data model / hierarchy.
This is enhanced by an option to store data also in a time series like structure together with customizable meta data. While not having to commit to a full historian deployment.

Out of the box, Litmus Production Record Database provides predefined stored procedures and functions to read data from and share data with other applications like Bi-tools, Visualization software or software for analytics.
Allowing to spend more time on working with the data and spend less time on writing SQL statements.

From Version 1.4.0.0 onward, Litmus Production Record Database allows the ingestion of data coming from Litmus Edge Digital Twin. To make use of this feature, users will also have to deploy the companion solution Litmus Production Record Digital Twin Message Conversion Flow.

Example Use Case

Litmus Production Record Database allows to store data for many different use case.
The only requirement is, that a trigger source for the start and stop and clear identifiers for the source and type of an event/production record do exist.
So that it can clearly be identified when it, where and what happened while executing a production process.
If these conditions are met, Litmus Production Record Database makes it possible to record nearly every possible event type such as:

Basic Attributes
  • Solution Version
    V 1.4.0.1
  • Litmus Edge modules used
    Litmus Integration, Litmus Flows
  • Relevant Non Litmus Software
    Microsoft SQL Server 2017 and above
  • Approximate Size
    1MB
  • Technologies used
    T-SQL
  • Skill Level
    Advanced
Knowledge Prerequisites

Litmus Production Record Database is deployed as a Microsoft SQL Server database using SQL Server 2017 or higher.
Out of the box, it provides all methods for:

    • setting up the data models
    • publishing data to Litmus Production Record Database
    • retrieving data from Litmus Production Record Database
    • monitoring Litmus Production Record Database

as a series of Stored procedures, views or functions.
Users therefore need to have knowledge on how to:

    • access a Microsoft SQL Server for example using SQL Server Management Studio (recommended) for administration
    • Navigate a SQL database
    • Create and execute T-SQL statements

If deployment options such as

    • Docker
    • Kubernetes
    • Azure
    • Other Cloud Providers

are chosen, Users are expected to be knowledgeable about how to deploy, manage, backup and restore MS SQL Server in these scenarios.

Installation Guide

How to deploy Litmus Production Record Database

This section will provide instructions on how to deploy Litmus Production Record Database to a preinstalled MS SQL Server.

NOTE:

If you have been using Litmus Production Record Internal Event Configurator , make sure to get at least Version 1.1.0 of this tool after updating to Litmus Production Record Database V 1.3.0.0.

Requirements

  • Full version of Microsoft SQL Server 2017 or higher is deployed
    • Supported Editions: Enterprise, Standard, Developer, Express
  • A SQL Authentication user with the rights to deploy and manage databases such as the sa user
  • The SQL Server is reachable via its IP / the IP for the SQL Server is known
  • To run the Installer, the .Net version has to be 4.7.2 or higher

Note:

Many organizations will not allow to use the default SQL Authentication user sa in their production environments.

To learn more about recommended actions, please visit our Documentation Portal.

Supported Operating Systems

  • Windows Operating Systems
  • Linux

Deployment options

  • Docker Container
  • Kubernetes
  • Datacentre
  • Azure -> any Virtual machine with SQL Server installed (NOT Azure SQL Database)

Please check out the Documentation Portal.

Additional Information

Documentation is available on the

Solutions Documentation Portal

Version Information

You May Also Be Interested In

© Copyright 2023 Litmus Automation Inc. All Rights Reserved. Legal

Consent Preferences