External Database Support
The External Database Extension lets OpenLM record license usage data in an external database such as MySQL or SQL Server
OpenLM accumulates usage statistics from various types of license managers and organizes the data in a relational database.
By default, OpenLM uses MariaDB, which accommodates the requirements of small installations. OpenLM has conducted internal experiments that have shown that external databases operate with superior performance to that of the default embedded database.
Benefits of a relational database management system
The simple yet powerful relational model is used by organizations of all types and sizes for a broad variety of information needs.
Relational databases
- are used to track inventories,
- manage huge amounts of mission-critical customer information,
- can be considered for any information need in which data points relate to each other and must be managed in a secure, rules-based, consistent way.
Relational databases have been around since the 1970s. Due to its many benefits, the relational model is still the most widely used model for databases.
- The information is stored in a database that is both familiar to the customer and managed by them.
- Customers may employ standard backup procedures to ensure OpenLM’s database functionality.
- Advanced OpenLM users may choose to develop their own reporting interface with the use of OpenLM APIs.
- Observing information in a familiar database will be an integral stage of developing and maintaining such functions.
Supported external databases
MySQL
MySQL is the most-used open source database in the world. DB-Engines says that MySQL is the second most-used database, after Oracle Database. Facebook, Twitter, Netflix, Uber, Airbnb, Shopify, and Booking.com are just some of the most popular websites that use MySQL.
Since MySQL is open source, it has many features that have been built with the help of users over more than 25 years. So it’s likely that MySQL Database will work with your favorite app or programming language.
Open source software is software that anyone can use and change. Anyone can use MySQL software without paying for it if they download it from the internet.
MSSQL Server 2012, 2014, 2016, 2017, 2019
Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network (including the Internet) (including the Internet). Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.
Maria DB
MariaDB Server is an open source relational database management system that can be used for many different purposes. It’s one of the most used database servers in the world, and big names like Wikipedia, WordPress.com, and Google all use it. MariaDB Server is made available under the GPLv2 open source license and will always be open source.
It can be used for transaction data with high availability, analytics, as an embedded server, and a lot of tools and programs work with MariaDB Server.
When Oracle bought MariaDB Server’s predecessor, MySQL, in 2009, the founder of MySQL, Michael “Monty” Widenius, split the project because he was worried about how Oracle would run it. He called the new project MariaDB. MySQL is named after his first daughter, My, and MariaDB is named after his second daughter, Maria.
Most of the original developers moved to the new project, and since then, MariaDB Server has grown quickly.
