pino-hana

A Pino Transport to write logs on SAP HANA Database.

Options

• connectionOptions accepts an object of type Connection Options
• schema accepts a string which is the schema in which tha table logs will be saved in is present
• table accepts a string which is the name of the table in which logs will be saved (without the schema)

Connection Options

Is an object in which the connection options to SAP HANA Database are specified with the following structure:

• host accepts a string containing the hana database host
• port accepts a number which is the port of the hana database
• user accepts a string which indicates the user you want to use to log into hana database
• password accepts a string which indicates the password you want to use to log into hana database

Getting started

Install pino alongside with pino-hana with the following command:

npm i pino pino-hana

Setup a pino logger in your codebase using the pino-hana transport like shown in the example:

const pino = require('pino')
const logger = pino({
  transport: {
    target: 'pino-hana',
    options: {
      connectionOptions: {
        host: <hana db host>,
        port: <hana db port>,
        user: <hana db user>,
        password: <hana db password>,
      },
      schema: <schema of the table in which you want to save the logs>,
      table: <table in which you want to save the logs>,
    },
  },
})

logger.info('hi') // this log will be saved into SAP HANA

At this point you are set to use pino-hana and all the logged information are saved to specified table in the options.

Note: make sure to provide always connectionOptions, schema and table to the options.

IMPORTANT: Make sure that the corresponding table and schema is already present in the database. The table must be created with the structure provided with the following create statement:

CREATE TABLE <schema>.<table>
(
ID NVARCHAR(40) PRIMARY KEY,
MSG NVARCHAR(5000),
CREATEDAT TIMESTAMP,
LEVEL INT
)

For a full usage guide please refer to the official pino documentation.