DataLogger Plug-In for KEPServerEX®

Product catalog summary

Overview: The DataLogger Plug-In for KEPServerEX is designed to log data from the server to an ODBC-compliant database such as SQL, Oracle, or MS Access. It is useful for applications like OEE, quality, performance analysis, and environmental safety data storage.

Step 1: Setting up a Database Connection
Begin by opening the DataLogger's General tab and configuring the Data Source Name (DSN) through the Data Source Administrator. It is recommended to create a System DSN connection for optimal logging results. Select the appropriate driver, such as the Microsoft Access Driver, and configure the database connection.

Step 2: Choosing Data to Log
Access the Data Map tab to select items from the server to log. For testing, use a System Tag like '_Time_Second.'

Step 3: Choosing the Data Logging Table and Format
Configure the MS Access Database by entering a Data Source Name and specifying the database file location. Use the settings 'Create a new table once and always attempt to append to this table' and 'Narrow' for table format. Enter a name in the Table Name field.

Step 4: Triggering the Data to Log
DataLogger's default settings include a 500 millisecond trigger for new log groups. After saving, data should log to the database. Verify data recording by opening MS Access.

Additional Features:
Users can start and stop logging using toolbar icons and configure multiple log groups for different rates or databases. The Batch Identifier feature allows grouping of data rows for easier retrieval. The store and forward capabilities, introduced in KEPServerEX version 5.14, enhance data management. Video tutorials are available on Kepware's YouTube channel.

Catalog excerpts

DataLogger Plug-In Made Easy DataLogger Plug-In for KEPServerEX® The DataLogger Plug-In for KEPServerEX has the ability to pull any data being gathered by the server and log it to an ODBC-compliant database (such as SQL, Oracle, and Microsoft (MS) Access). The many applications for which DataLogger is useful are shown in the diagram below. Save environmental safety data for auditing Save data for historical comparisons Store data to analyze Overall Equipment Eectiveness Quality Performance Whatever the reason, DataLogger’s robust functionality can help you meet your logging and analysis needs. Follow the Steps Step 1: Setting up a database connection To start, open DataLogger’s General tab and then click Configure DSN. This launches the Data Source Administrator, which allows users to either connect to a database that is already configured or to create a new database. Note: For best logging results, always create a System DSN connection. Next, open the System DSN tab and select the type of driver needed to connect to the database. Try logging data using the Microsoft Access Driver (with *.mdb and *.accdb extensions) for testing purposes. Click Add to configure the database connection. 400 Congress Street, 4th Floor | Portland, Maine 04101 | (207) 775-1660 | www.kepware.com

Open the catalog to page 1

DataLogger Plug-In Configuring an MS Access Database is quick: simply type in a Data Source Name (as shown below) and then click Create to specify the location for the database files. ODBC Microsoft Access Setup Data Source Name: DLMadeEasy Select... Create... Repair... Compact.. System Database System Database... Once finished, click OK. Database Name logging table and table Next, open the Data Map tab and click Add to browse the server for the items that will be logged. For testing purposes, choose a System Tag like"_Time_Second." The simplest settings for logging are "Create a new table once...

Open the catalog to page 2

DataLogger Plug-In -Server Item List (group update rate is 10Oms, 1 items defined]- Data Type 400 Congress Street, 4th Floor | Portland, Maine 04101 | (207) 775-1660 | www.kepware.com

Open the catalog to page 3

DataLogger Plug-In Made Easy To start and stop logging, click the and toolbar icons. Users can also configure multiple log groups to log data at different rates or to different databases. Additional Features Users have the option to use the Batch Identifier section (located in the General tab) to group data rows together. Once set, the database can be searched using the Batch ID to pull a group of data at once. Users can also utilize DataLogger’s new store and forward capabilities, which were added in KEPServerEX version 5.14. To access video content for KEPServerEX version 5.14, which includes...

Open the catalog to page 4

All Kepware catalogs and technical brochures

Archived catalogs

*Prices are pre-tax. They exclude delivery charges and customs duties and do not include additional charges for installation or activation options. Prices are indicative only and may vary by country, with changes to the cost of raw materials and exchange rates.

Brand list