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;

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.