Integrations Database Integrations2017-11-16T10:51:24+00:00
Incorrect slider name. Please make sure to use a valid slider slug.

Database Integration

In IT Event Management practices the need frequently occurs to enrich events with information from other products and store them in various databases, or update external databases with new data.

Kriu for IT Operations 3.0 can access databases using different modes:

  • Direct access to a product’s MySQL database through Lua scripts.
  • Access to generic MySQL databases through Lua scripts.
  • Access to any external database through Lua scripts and through scheduled scripts using Dbproxy component.

Steps of Integration

 

  1. Direct access to a product’s MySQL Database through Lua scripts.

Lua scripts running under Receiver or Server components have direct access to a product’s MySQL database using Lua object “SRVDB”.

  1. Access to MySQL database from generic Lua scripts.

Lua scripts running under the Receiver or Server component can access any MySQL database using the Lua “DB” object.

  1. Access to any database using dbproxy.

The dbproxy component is written in java and is extensible with JDBC drivers. It is installed with Kriu for IT Operations 3.0 as a service. Through the configuration file “config.props” it is possible to add JDBC drivers to extend the range of databases.

  1. Restart the Dbproxy service.

Connect to any database from Lua via Dbproxy.

The Lua scripts running under the receiver can access any databse using the EXTDB object. You must configure the server and the port where it gathers information from dbproxy.