This site contains the documentation that is relevant to older WSO2 product versions and offerings.
For the latest WSO2 documentation, visit https://wso2.com/documentation/.

PSD2 Data Reporting Tool

When offering open banking services, organizations need to monitor the following:

  • Performance and Availability: The performance of the system needs to be maintained at an acceptable level. At the same time, the endpoints exposed to clients need to be highly available so that they can carry out their open banking activities in a non-disruptive manner.
  • Number of TPPs: It is important to observe the trends related to the number of Third Party Providers (TPP) registered with the organization for capacity planning as well as to evaluate business success.
  • Daily Volumes: This involves monitoring statistics related to the number of API calls handled so that you can assess the efficiency with which the open banking services are provided and identify any security concerns. In addition, this form of monitoring also helps with capacity planning.

The OB Monitoring Tool is offered to be used with the WSO2 Open Banking solution for the purpose of carrying out the above.

The following topics explain how to download and install the OB Monitoring Tool, and then use it to monitor your APIs.

Downloading and installing the Monitoring Tool

To download and install the monitoring tool, follow the steps below:

  1. Apply the latest WUM update to the following product packs. For more information, see WSO2 Administration Guide - Using WSO2 Update Manager.
    • WSO2 Open Banking - API Manager 2.6.0
    • WSO2 OPen Banking - API Manager Analytics 2.6.0
  2. To enable the publisher to publish monitoring statistics, open the <WSO2OB_AM_HOME>/repository/conf/api-manager.xml file and update the PublisherClass element under Analytics as shown below.

    <PublisherClass>
    com.wso2.finance.open.banking.gateway.uk.monitoring.publisher.OBUsageDataBridgeDataPublisher
    </PublisherClass>
  3. Restart WSO2 Open Banking - API Manager 2.6.0 server.
  4. Download the zip file with the Monitoring Tool from here.
  5. Unzip the file you downloaded to extract the Monitoring Tool.

Creating a report in CSV format

Once you have downloaded and extracted the Monitoring Tool, you can create a report that consists of two CSV files as follows:

  1. Open the config.properties file in the extracted zip file and update the properties.

    Information about the properties that can be configured are included as code comments in the config.properties file.

  2. Copy your database driver class jar to the libs directory of your extracted directory. Then rename the jar it to db.jar.
    This allows the Monitoring tool to connect to the Consent DB database that is already set up for WSO2 Open Banking.

  3. Issue the following command to create the two CSV files of the report.

    java -jar com.wso2.finance.open.banking.analytics.uk.monitoring.tool-1.2.0.jar

The report

The report generated as described above consists of two files. These two files can be used as datasets to generate other output (e.g., PDF documents, dashboards etc.). These two files are as follows:

  • apiresponsetimeresourcepath_<year>_<month>_<generatedtimestamp>.csv
    This file contains data related to the API response time. The format of the file is as shown in the following sample.

    Date (dd/mm/yy), Brand, API Context, API Resource Path, API Response times in milliseconds
    2018-12-05,WSO2OB,/AccountsInfoAPI/v2.0.0,GET /accounts,192
    2018-12-05,WSO2OB,/AccountsInfoAPI/v2.0.0,POST /account-requests,1049
    2018-12-06,WSO2OB,/AccountsInfoAPI/v2.0.0,GET /account-requests/{AccountRequestId},693
    2018-12-06,WSO2OB,/AccountsInfoAPI/v2.0.0,GET /accounts,285
    2018-12-06,WSO2OB,/AccountsInfoAPI/v2.0.0,POST /account-requests,631
  • apiusageresourcepath_<year>_<month>_<generatedtimestamp>.csv
    This file contains count data related to the API resource path. The format of the file is as shown in the following sample.

    Date (dd/mm/yy), ASPSP, Brand, API Type, API Context, API Resource Path, # of Successful API Calls(200 201 or 204 codes), # of API Calls failed for Business Reasons (4xx codes), # of API Calls failed for Technical Reasons (5xx codes),# of TPPs Calling API, # of API Calls with Rejected Status, # of API Calls Not Authorised by PSU
    2018-12-05,WSO2OB,WSO2OB,AIS,/AccountsInfoAPI/v2.0.0,POST /account-requests,2,0,0,1,1,0
    2018-12-05,WSO2OB,WSO2OB,AIS,/AccountsInfoAPI/v2.0.0,GET /accounts,0,1,0,1,,
    2018-12-06,WSO2OB,WSO2OB,AIS,/AccountsInfoAPI/v2.0.0,POST /account-requests,8,3,0,3,0,7
    2018-12-06,WSO2OB,WSO2OB,AIS,/AccountsInfoAPI/v2.0.0,GET /account-requests/{AccountRequestId},2,1,0,1,,
    2018-12-06,WSO2OB,WSO2OB,AIS,/AccountsInfoAPI/v2.0.0,GET /accounts,0,1,0,1,,