News CNCnetPDM About us Support  


For both, MS SQL-Server and Oracle databases CNCnetPDM writes data acquired from devices to table RawDataTable (default MTH_RAW_DATA) and/or OnlineDataTable (default MTH_ONLINE_DATA).

Both tables have the following columns (field types are taken from MS SQL Server):



[GROUP_ID] [float] NULL

Used to tie together multiple items (status, part counter value, work order…) from a device acquired in a reading cycle. Prefixed with ServiceID, see chapter ‘CONFIGURE CNCNETPDM.INI’ for details. Example: 10000000159


Date and time when the data was read from the device e.g.
2016-10-12 11:01:07.000


Number of the device from which data was received e.g. 1000

[TAG_CODE] [varchar](255) NOT NULL

Tag code for the item acquired from a device see also chapter ‘CONFIGURE CNCNETPDM.INI’ for details. For items Event, Counter, DowntimeReason, Order, Operation and Item the tag code is created by using entries as defined in CNCnetPDM.ini. For items acquired via sections 1-3 the tag codes are created according to the NAME definitions in the INI file for each device. This INI file is automatically generated by your device driver DLL.


Tag code STATUS ist taken from CNCnetPDM.ini. If a telegram that contains multiple values e.g. STATN|3|STATT|Manual| (status number = 3, status text = manual separated by a pipe character ‘|’) is read CNCnetPDM creates one record for every tag name (e.g. STATN) with its value (e.g. 3) in column [TAG_DATA].

[TAG_DATA] [varchar](255) NULL

Data value received from a device for a specific tag code. Examples:

TAG_DATA = Manual


Date and time when device data was received by CNCnetPDM e.g.
2017-04-23 11:20:57.000


This field is useful for further processing of data from MTH_RAW_DATA for example to update tables with aggregated / condensed values. CNCnetPDM sets the value in this field to 2. When you begin to process the data you can set the field to 1 to get a defined number of records that are processed (new records are continuously coming in from devices)

FIG 1: Database field description MTH_RAW_DATA and MTH_ONLINE_DATA TOP

The following figure shows output of data from CNCnetPDM into table RawDataTable (default MTH_RAW_DATA):

Database output (Raw data)

FIG 2:  Data received from CNCnetPDM in table MTH_RAW_DATA (MS SQL Server)

In the above example CNCnetPDM has received 8 items from device 1002 in a single telegram that contained TAG_CODE and TAG:DATA in a single line separated by a pipe character ‘|’ e.g. PRGCU|4|PRGMN|4712|…

Items collected in the same reading cycle get the same GROUP_ID value (1). READING_TIME (2) is the time when data was read from the device. DEVICE_NUMBER (3) is created according to the devices settings configured in CNCnetPDM.ini. TOP

If the telegram contains a single value TAG_CODE (4) is created according to the settings in CNCnetPDM.ini. In case of multiple values TAG_CODE is created based on the content of the telegram.

TAG_DATA (5) contains the data value returned by the device for the item. CREATION_DATE (6) is the time when the data was received by CNCnetPDM. PROCESSING_FLAG is automatically set to 2 (not shown).

Note: Please make sure that the columns in your database are set up as shown in the description above. Otherwise CNCnetPDM switches to ‘Offline Mode’ and writes all data to the offline-text-file specified for the service. In this case the reason for the issue can be found out by analyzing log file log_db_YYMMDD.txt in the log file folder of CNCnetPDM. TOP

Privacy notice

This website uses cookies. By continuing to use it you agree to our privacy policy.

Support | CNCnetPDM Manual | Overview

Version User Manual | Here you can find everything you need to install, setup and... [read more]

Support | CNCnetPDM Manual | Setup

This section describes the steps to install CNCnetPDM. EXTRACT FILES Create a folder for CNCnetPDM on your PC or at a server. Due to Windows UAC please do... [read more]

Support | CNCnetPDM Manual | Foreground Program

This section describes the steps to start CNCnetPDM as a foreground program. After extracting the files it is possible and save to immediately start CNCnetPDM. If you like to... [read more]
Foreground Program

Support | CNCnetPDM Manual | Background Service

This section shows the steps to install and start CNCnetPDM as a background service. CNCnetPDM is able to and, in a production environment, usually runs as a windows background... [read more]
Background Service

Support | CNCnetPDM Manual | Instances

This section describes the steps to setup and run multiple instances of CNCnetPDM on a single PC. In case you would like or have to work with different parameters for specific... [read more]

Support | CNCnetPDM Manual | CNCnetPDM INI File

This section describes the steps to adjust CNCnetPDM via it's INI file according to your needs. CNCnetPDM.ini contains all information needed to control the functions of the... [read more]

Support | CNCnetPDM Manual | OPC UA Server

The CNCnetPDM Standard OPC UA Server enables to add OPC UA Server functionality to any controller type (e.g. Fanuc, Mitsubishi, Heidenhain, PLCs) supported by CNCnetPDM. It... [read more]
OPC UA Server

Support | CNCnetPDM Manual | MTConnect Overview

The CNCnetPDM MTConnect Adapter enables you to access machine controllers connected to CNCnetPDM from within your applications or any MTConnect compatible program like an... [read more]
MTConnect Overview

Support | CNCnetPDM Manual | MTConnect Getting Started

Here you can find everything you need to know to get started with the CNCnetPDM MTConnect adapter. This section shows all necessary steps to setup CNCnetPDM, use the MTConnect... [read more]
MTConnect Getting Started

Support | CNCnetPDM Manual | MTConnect Standard Agent 1.3

This document describes setup of the MTConnect Standard Agent Version 1.3 it’s usage and test with the CNCnetPDM MTConnect Adapter. CNCNETPDM SETUP | AGENT... [read more]
MTConnect Standard Agent 1.3

Support | CNCnetPDM Manual | SQL Server Database Tables

This section describes the steps to setup an MS SQL Server database and required as well as optional tables for CNCnetPDM. Note: Starting with CNCnetPDM Ver. the names of... [read more]
SQL Server Database Tables

Support | CNCnetPDM Manual | Oracle Database Tables

This section describes the steps to setup required and optional database tables for CNCnetPDM in case you're using an Oracle database. Note: Starting with CNCnetPDM Ver.... [read more]
Oracle Database Tables

Support | CNCnetPDM Manual | MySQL MariaDB Database Tables

This section describes the steps to setup required and optional database tables for CNCnetPDM in case you're using a MySQL or MariaDB (Version >= 5.5!)  database.... [read more]
MySQL MariaDB Database Tables

Support | CNCnetPDM Manual | Database Connectivity

To connect to a database CNCnetPDM uses a Universal Data Link (.udl) file that contains information about your database. Connect to an MS SQL Server database... [read more]
Database Connectivity

Support | CNCnetPDM Manual | Licensing

When you start the program or service the first time without a license CNCnetPDM automatically creates a license key for your copy. Without a purchased license key initially this... [read more]
Modified: 2020-05-26