End Google Tag Manager (noscript) -->
USA +1 866 806 2068 | UK +44 203 1292 513 | JAPAN +81 3 45208991 担当:萩原 info@openlm.com

External Database Extensions

The External Database Extension lets OpenLM use license usage data from external databases such as MySQL and SQL Server

 

The default OpenLM Firebird Database

OpenLM accumulates usage statistics from various types of license managers. It organizes this information in a relational database. By default, OpenLM uses an embedded Firebird DB which accommodates the requirements of small installations. The Firebird database is installed as part of the OpenLM Server setup.

Benefits of an external Database

An External database is recommended for managing large licensing schemes or when high performance is required. OpenLM has conducted internal experiments that have shown that external databases operated with superior performance to that of the default embedded database.

the external database support capability is provided by the External Database Support extension. The extension seamlessly supports databases such as MS SQL Server, MySQL and External Firebird.

In addition to a boost in performance, license administrators also enjoy the following benefits:

  • The information is stored on 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 database versions

The following database versions have been tested, and OpenLM support for them was validated:

  • MS SQLServer  2008, 2008-R2, 2012, 2014, 2016
  • Firebird Server 2.5.0
  • MYSQL Server 5.6

For more information on supported versions, please refer to the System Requirements page.

For more information regarding migration to external database, please refer to this document.

We Offer a 30 day fully supported evaluation

Start Your FREE Trial