Current Version: 2.0
LoggerNet DB (LNDB) is ideally suited for transitioning data from LoggerNet’s data cache to a relational database of your choice. Publishing user-selected LoggerNet collected data to these relational databases enables data administrators to share their data with a large customer base across various platforms and methods. Those platforms could include custom websites (including those developed with RTMC and CSIWEBS), custom data reporting systems, data warehousing, and customer software (web and desktop) applications. This application is for data network administrators that want to push their valuable LoggerNet data into relational databases and have that data published in real time (as often as the data is collected).
The low-cost LNDB software is simple to set up and administer and gives you the flexibility you need for your organization. Most users can have the software installed and LoggerNet data uploading to their relational database in less than 20 minutes' time (assuming the database and LoggerNet are set up and proper credentials are issued to the data manager). After setup, LNDB runs as a service on Windows and continues to reliably push LoggerNet data to the relational database, allowing you to focus your time and energy on other projects.Read More
LNDB can be run as a service on the workstation or server. This ensures that when the computer is restarted, LNDB is automatically started without human intervention. This allows data ingestion from LoggerNet to the relational database to continue after unforeseen power issues or automatic operating system updates.
LNDB Manager is the main client screen used to configure the LNDB engine. It is used to determine which LoggerNet system to connect to and which database is used. LNDB Manager can also be used to watch the status of various data collections and data push events. Data can be reviewed in tabular columns directly from the database without having to use database-specific tools. Status messages and Significant Events can be viewed using LNDB Manager as well.
DBExport is a database client that can be used to retrieve data directly from the relational dabase. Users can pull all the data from the database or select data using data ranges. EDExport also has the ability to check for and inform the user of missing records for the exported data. Exported file formats include TOA5, TOACI1, TOB1, CSIXML, and Custom CSV.
DBImport is a database client that can be used to import data from existing data files. The user can ingest the data into an existing table or create a new one in the database. These data files can be either those created by LoggerNet or database files from other sources or data loggers.
QuickReports is another database client that can be used to generate simple reports and graphs with data from the relational database.
|Operating System||Windows 10, 8, or 7 and Windows Server versions 2012 R2, 2016, or 2019. (Users using Windows Server with security policies other than the default policies will need to work with their IT administrations to resolve any security issues.)|
|Required Framework||This software requires the Microsoft .NET 4.6.2 (or better) Framework to run properly. To use the reporting functions of LNDB 2.0, Microsoft .NET Framework 3.5 also needs to be installed. If the required version of the .NET framework is not already installed on your computer, it can be obtained from the Microsoft Download Center.|
Please note: The following shows notable compatibility information. It is not a comprehensive list of all compatible products.
|LoggerNet Admin Upgrade|
LNDB has been tested and shown to work with the following databases:
Note: LNDB may work with other versions of SQL Server Express, SQL Server Compact, or MySQL.
LNDB runs on Windows® 10, 8, or 7 and Windows® Server 2012 R2*, 2016*, or 2019*.
*Users using Windows® Server with security policies other than the default policies will need to work with their IT administrations to resolve any security issues.
A fully functional 30 day trial version of LNDB (LoggerNet DataBase) software.
Note: This application requires the Microsoft .Net 3.5 and .Net 4.6.2 Frameworks. If they are not already installed on your computer, they can be obtained from the Microsoft Download Center.
Number of FAQs related to LNDB: 25
Expand AllCollapse All
No. LNDB works independently of Baler.
LNDB has been tested to run on Windows 7, Windows 8, and Windows 10.
Because Windows Server installations are all uniquely configured, it is nearly impossible for our application engineers to replicate a customer’s implementation environment at our facility.
To test whether LNDB will work in a particular Windows Server environment, download the 30 day trial versions of LoggerNet and LNDB. Each is available in the Downloads section of the product page: LoggerNet and LNDB.
LNDB uses two fields as primary keys: the record number and time stamp. If the record number and time stamp are both duplicated, the record is discarded. If only the record number or only the time stamp is duplicated, LNDB should import the record.
No. For information about creating live connections to Microsoft SQL Server, Oracle, or MySQL data sources with FileMaker Pro’s External SQL Data Source feature, visit the FileMaker website.
If the stations are all accessed by the same instance of LoggerNet, LNDB can collect table data from multiple stations. In the LNDB Manager, highlight the station in the left tree, and select the checkboxes next to the desired table names.
Note: LNDB can only communicate with one instance of LoggerNet.
Yes, but LNDB can only run on a Windows platform. Run LNDB on the same Windows host on LoggerNet, and post the data to MySQL running under Linux. Configure LNDB (running on Windows) to point to the MySQL server running on Linux.
No. The purchased version is separate from the trial version. Uninstall the trial version, and install the purchased version.
With LoggerNet and LoggerNet Admin, remote connections are not enabled by default. They have to be enabled in the LoggerNet Toolbar. Right-click anywhere on the toolbar, and, in the resulting dialog box, verify that Allow Remote Connections is selected.
Currently, LNDB cannot run under Linux unless it is run under a virtual machine that emulates Windows. However, LNDB has the ability to work with these different database engines:
There is nothing to prevent a user from continuing to run LNDB on the same Windows host on LoggerNet and posting the data to MySQL, Oracle, or PostgreSQL running under Linux. Configure LNDB (running on Windows) to point to the MySQL, Oracle, or PostgreSQL server running on Linux.