API Gateway 10.11 | Administering API Gateway | Operating API Gateway | Destination Configuration | Configuring Events for Database Destination
 
Configuring Events for Database Destination
Before you begin
For preparing the database connection, ensure that you have:
*Installed Database Components Configurator with API Gateway database scripts. For details, see Create Database Components Using Database Component Configurator section in Installing Software AG Products Guide.
*Started Database Components Configurator and created tables for the component, APIGatewayEvents. For details, see Create Database Components, Database User, and Storage section in Installing Software AG Products Guide.
*Created database connection pools in the Integration Server UI. For details, see Creating a connection pool section in webMethods Integration Server Administrator’s Guide.
*Configured API Gateway functional alias to the database connection pool in the Integration Server UI. For details, see Pointing functions at Connection pools section in webMethods Integration Server Administrator’s Guide.
You have to configure the database destination so that the events, performance metrics, and audit log data can be published to the configured database.
API Gateway supports the following databases:
*DB2
*Oracle
*SQL Server
*To configure events for Database destination
1. Expand the menu options icon , in the title bar, and select Administration.
2. Select Destinations.
3. Select Database to configure the event types for this destination.
4. In Event types, select the type of events that you want API Gateway to publish to the database.
The available event types are:
*Error: Occurs each time an API invocation results in an error.
*Lifecycle: Occurs each time API Gateway is started or shut down.
*Policy violation: Occurs each time an API invocation violates the policy enforcement that was set for the API.
5. Select Report performance data to publish performance metrics data.
6. In the Publish interval box, provide a time interval (in minutes) to specify how often API Gateway must publish performance metrics. Provide a value from 1 through 60. The default value is 60 minutes.
7. In the Audit log data section, select the required management area for which the audit logs should be recorded in the Database destination.
Audit logs provide a record of system transactions, events, and occurrences in API Gateway. You can configure audit logging to show the following events:
*API management
*Approval management
*Application management
*Alias management
*Team management
*Analytics management
*Group management
*Policy management
*Package management
*Plan management
*Promotion management
*User management
Note:
By default, audit logging is disabled for all the mentioned management areas in the Database destination.
8. Click Save.
Post-requisites:
After performing the database configurations, select Database as a Destination in the Policy Properties page for each policy, to receive the transaction event logs for the assigned policies.