DataLogger Plug-In for KEPServerEX®
4Pages

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

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...

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

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...