Page Comparison

The API Manager Analytics provides reports, statistics and graphs on the APIs deployed in WSO2 Open Banking API Manager. You can then configure alerts to monitor these APIs and detect unusual activity, manage locations via geo-location statistics and carry out a detailed analysis of the logs.

...

Info
When using Oracle or MS SQL, download the database driver and include it within `<WSO2_APIM_ANALYTICS_HOME>/lib` directory.

Create the openbank_apimgt_statsdb database in your database server.

Configure the worker profile.

Open the <WSO2_OB_API-M_ANALYTICS_HOME>/conf/worker/deployment.yaml file. Update the APIM_ANALYTICS_DB datasource pointing it to the openbank_apimgt_statsdb database using your database configurations.

Note

If you are using Oracle, update the connectionTestQuery in each datasource with the following value.

Code Block

language	xml

connectionTestQuery: SELECT 1 FROM DUAL

Code Block

language	xml
title	deployment.yaml

- name: APIM_ANALYTICS_DB
description: The Datasource used for APIM Analytics
jndiConfig:
  name: jdbc/APIM_ANALYTICS_DB
definition:
  type: RDBMS
  configuration:
    jdbcUrl: 'jdbc:<DB_TYPE>://<DB_HOST>:<DB_PORT>/openbank_apimgt_statsdb?autoReconnect=true&useSSL=false'
    username: <DB_USERNAME>
    password: <DB_PASSWORD>
    driverClassName: <DB_DRIVER>
    maxPoolSize: 50
    idleTimeout: 60000
    connectionTestQuery: SELECT 1
    validationTimeout: 30000
    isAutoCommit: false

Configure the dashboard profile.

Open the <WSO2_OB_API-M_ANALYTICS_HOME>/conf/dashboard/deployment.yaml file. Update the APIM_ANALYTICS_DB datasource with your database configurations.

deployment.yaml

Note

If you are using Oracle, update the connectionTestQuery in each datasource with the following value.

Code Block

language	xml

title

connectionTestQuery: SELECT 1 FROM DUAL

Code Block

language	xml

- name: APIM_ANALYTICS_DB
description: The Datasource used for APIM Analytics
jndiConfig:
  name: jdbc/APIM_ANALYTICS_DB
definition:
  type: RDBMS
  configuration:
    jdbcUrl: 'jdbc:<DB_TYPE>://<DB_HOST>:<DB_PORT>/openbank_apimgt_statsdb?autoReconnect=true&useSSL=false'
    username: <DB_USERNAME>
    password: <DB_PASSWORD>
    driverClassName: <DB_DRIVER>
    maxPoolSize: 50
    idleTimeout: 60000
    connectionTestQuery: SELECT 1
    validationTimeout: 30000
    isAutoCommit: false

Tip

By default, the following datasource entries are configured to H2 databases. If required, you can create external databases and point these entries to them.

Datasource Name	File
`BUSINESS_RULES_DB`	`<WSO2_OB_API-M_ANALYTICS_HOME>/conf/dashboard/deployment.yaml`
`WSO2_PERMISSIONS_DB`	`<WSO2_OB_API-M_ANALYTICS_HOME>/conf/worker/deployment.yaml <WSO2_OB_API-M_ANALYTICS_HOME>/conf/dashboard/deployment.yaml`

Note
The `GEO_LOCATION_DATA` datasource should be configured when you are using Geo-location based statistics

Integrate third-party products when configuring databases.

Note

WSO2 Stream Processor is an OSGi-based product. Therefore, when you integrate third party products such as Oracle and MS SQL with WSO2 API-M Analytics, you need to check whether the libraries you need to add are OSGi based. If they are not, you need to convert them to OSGi bundles before adding them to the <WSO2_OB_API-M_ANALYTICS_HOME>/lib directory.

To convert the jar files to OSGi bundles, follow the steps below.

1. Download the non-OSGi jar for the required third party product, and save it in a preferred directory in your machine.

2. Go to the <API-M_ANALYTICS_HOME>/bin directory. Run the command given below, to generate the converted file in the <API-M_ANALYTICS_HOME>/lib directory.

Code Block
./jartobundle.sh <PATH_TO_NON-OSGi_JAR> ../lib

...

Versions Compared

Old Version 23

New Version 24

Key