Documentation forKiwi Syslog Server
Legacy KSS reached its End of Service Life on March 28, 2026. Users should migrate to the next generation of KSS. See the release history for the latest version.

Add an action to log messages to a database in KSS NG

You can add an action to log messages to a database using a bulk insert. You can use a bulk insert to log multiple events in a single connection to the database, rather than establishing and closing a session for each event.

  1. From the KSS NG navigation bar, choose Setup > Rules.
  2. Locate an existing rule. If the rule does not exist, add a rule and start the New Rule wizard.
  3. If you are adding an action to an existing rule, select the rule and click Edit. If you are creating a new rule, navigate to the Actions step of the New Rule wizard.
  4. Click Add Action. Define the action name in the provided field.

  5. In the Action drop down, select Log to database - new bulk insert.

  6. Select the database type and enter the connection string. See example connection strings below.

    MSSQL Data Source=127.0.0.1;User Id=KiwiUser;Password=***;Initial Catalog=kssNG
    PostgreSQL Host=127.0.0.1;Database=ng1;Username=kiwiuser;Password=***;
    OracleSQL (EZCONNECT) User Id=system;Password=***;Data Source=127.0.0.1:1521/orcl;
    OracleSQL (Full descriptor) User Id=system;Password=***;
    Data Source=(DESCRIPTION=
    (ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521)))
    (CONNECT_DATA=(SERVICE_NAME=orcl))
    );
    MongoDB mongodb://kiwiuser:***@127.0.0.1:27017/kiwi?authSource=admin
    MySQL Server=127.0.0.1;Port=3306;Database=ng1;User ID=KiwiUser;Password=***;AllowLoadLocalInfile=true;
    Elasticsearch (via Endpoint) {
    "url": "https://10.218.209.117:9200",
    "username": "kssng",
    "password": "testAutotest123",
    "caThumbprint": "956a567f776aab4b3eeb4bc07beb097c73489261"
    }
    Elasticsearch (via CloudID) {
    "cloudId": "My_deployment:ZXUtY2VudHJhbC0xLmF3cy5jbG91ZC5lGy5pbyRlZWQ1MDE2Y6RlZTE0OTZlODRmMDBjMjM4Y2E4YmJiMyRkNzM0NDk5MTMzODY0MzNiYWE3NTg2NTY5YzhmY2Q5OQ==",
    "apiKey": "c1hkRmtaMEsDUnpJaVpkMU8yclQ6bzhFc2R1UX66dFF6dlFiGFpNWWJYUQ==",
    "index": "TableName"
    }

  7. Enter the database table name. Click Create new... to generate the database.

  8. (Optional) Click Advanced Options to specify the number of maximum records, maximum milliseconds, and connection inactivity timeout, if desired.
  9. Click Test to verify that records log to the database in bulk correctly.
  10. If you are adding an action to an existing rule, click Apply. If you are creating an action in the New Rule wizard, click Add.