OpenLM Features Extensions Icon_8

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

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.

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.

Skip to content