Page Comparison

...

Create the following databases that are used in WSO2 Open Banking Key Manager (WSO2_OB_KM) and WSO2 Open Banking API Manager (WSO2_OB_APIM):

1. openbank_am_configdb
2. openbank_apimgt_statsdb
3. openbank_apimgtdb
4. openbank_openbankingdb
5. openbank_govdb
6. openbank_iskm_configdb
7. openbank_mbstoredb
8. openbank_userdb

Tip

Localtabgroup

Localtab

title	MySQL

For a MySQL database :

Create the databases using the command below:
Code Block
language sql
CREATE DATABASE <DATABASE_NAME>;
Place the compatible MySQL JDBC drivers in the <WSO2_OB_APIM_HOME>/repository/components/lib and <WSO2_OB_KM_HOME>/repository/components/lib directories. By default, the mysql-connector-java-5.1.42-bin.jar JDBC driver is available in these locations.
Edit the default datasource configurations in the files below with the MySQL configurations.
1. <WSO2_OB_APIM_HOME>/repository/conf/datasources/master-datasources.xml
2. <WSO2_OB_APIM_HOME>/repository/conf/datasources/open-banking-datasources.xml
3. <WSO2_OB_KM_HOME>/repository/conf/datasources/master-datasources.xml
4. <WSO2_OB_KM_HOME>/repository/conf/datasources/open-banking-datasources.xml

Make sure you update the properties such as the url, username, password, driverclassname in the configurations. A sample is given below:

Code Block

language	xml

<datasource>
	<name>WSO2CONFIG_DB</name>
	<description>The datasource used by the registry</description>
	<jndiConfig>
		<name>jdbc/WSO2Config_DB</name>
	</jndiConfig>
	<definition type="RDBMS">
		<configuration>
			<url>jdbc:mysql://localhost:3306/openbank_openbankingdb?autoReconnect=true&useSSL=false</url>
			<username>root</username>
			<password>root</password>
			<driverClassName>com.mysql.jdbc.Driver</driverClassName>
			<maxActive>150</maxActive>
			<maxWait>60000</maxWait>
			<testOnBorrow>true</testOnBorrow>
			<validationQuery>SELECT 1</validationQuery>
			<validationInterval>30000</validationInterval>
			<defaultAutoCommit>false</defaultAutoCommit>
		</configuration>
	</definition>
</datasource>

Localtab

title	MS SQL

For a Microsoft SQL database:

Create the databases using the command below:
Code Block
language sql
CREATE DATABASE <DATABASE_NAME>;
Place the compatible MS SQL JDBC drivers in the <WSO2_OB_APIM_HOME>/repository/components/lib and <WSO2_OB_KM_HOME>/repository/components/lib directories.
Edit the default datasource configurations in the files below with your MS SQL configurations.
1. <WSO2_OB_APIM_HOME>/repository/conf/datasources/master-datasources.xml
2. <WSO2_OB_APIM_HOME>/repository/conf/datasources/open-banking-datasources.xml
3. <WSO2_OB_KM_HOME>/repository/conf/datasources/master-datasources.xml
4. <WSO2_OB_KM_HOME>/repository/conf/datasources/open-banking-datasources.xml

Make sure you update the properties such as the url, username, password, driverclassname in the configurations. A sample is given below:

Code Block

language	xml

<datasource>
	<name>WSO2CONFIG_DB</name>
	<description>The datasource used by the registry</description>
	<jndiConfig>
		<name>jdbc/WSO2Config_DB</name>
	</jndiConfig>
	<definition type="RDBMS">
		<configuration>
			<url>jdbc:sqlserver://localhost:1433;databaseName=openbank_openbankingdb</url>
			<username>root</username>
			<password>root</password>
			<driverClassName>com.microsoft.sqlserver.jdbc.SQLServerDriver</driverClassName>
			<maxActive>300</maxActive>
			<maxWait>60000</maxWait>
			<testOnBorrow>true</testOnBorrow>
			<validationQuery>SELECT 1</validationQuery>
			<validationInterval>30000</validationInterval>
			<defaultAutoCommit>false</defaultAutoCommit>
		</configuration>
	</definition>
</datasource>

Localtab

title	Oracle

For an Oracle database:

Create the databases using the commands below:

Code Block

CREATE USER <DATABASE_NAME> IDENTIFIED BY <PASSWORD>;
GRANT SELECT ANY TABLE TO <DATABASE_NAME>;
GRANT DELETE ANY TABLE TO <DATABASE_NAME>;
GRANT INSERT ANY TABLE TO <DATABASE_NAME>;
GRANT CREATE SESSION, CREATE TABLE, CREATE SEQUENCE, CREATE TRIGGER to <DATABASE_NAME>;

ALTER USER <DATABASE_NAME> QUOTA <SPACE_QUOTA_SIZE_IN_MEGABYTES> ON USERS;

Place the compatible Oracle JDBC drivers in the <WSO2_OB_APIM_HOME>/repository/components/lib and <WSO2_OB_KM_HOME>/repository/components/lib directories.
Edit the default datasource configurations in the files below with your Oracle configurations.
1. <WSO2_OB_APIM_HOME>/repository/conf/datasources/master-datasources.xml
2. <WSO2_OB_APIM_HOME>/repository/conf/datasources/open-banking-datasources.xml
3. <WSO2_OB_KM_HOME>/repository/conf/datasources/master-datasources.xml
4. <WSO2_OB_KM_HOME>/repository/conf/datasources/open-banking-datasources.xml

Make sure you update properties such as url, username, password, driverclassname in the configurations. A sample is given below:

Code Block

language	xml

<datasource>
	<name>WSO2CONFIG_DB</name>
	<description>The datasource used by the registry</description>
	<jndiConfig>
		<name>jdbc/WSO2Config_DB</name>
	</jndiConfig>
	<definition type="RDBMS">
		<configuration>
			<url>jdbc:oracle:thin:openbank_openbankingdb/password@localhost:1521:root</url>
			<username>openbank_openbankingdb</username>
			<password>password</password>
			<driverClassName>oracle.jdbc.driver.OracleDriver</driverClassName>
			<maxActive>150</maxActive>
			<maxWait>60000</maxWait>
			<validationQuery>SELECT 1 from dual</validationQuery>
			<validationInterval>30000</validationInterval>
			<defaultAutoCommit>false</defaultAutoCommit>
		</configuration>
	</definition>
</datasource>

Update the INPUTS field size in AM_APPLICATION_REGISTRATION table in the sql file according to your database. The sql scripts are available in the <WSO2_OB_KM_HOME>/dbscripts/apimgt directory. (mysql5.7.sql, mssql.sql, oracle.sql)

For UK and Australia specifications:
Localtabgroup
Localtab
title MySQL / MSSQL
Code Block
language sql
INPUTS VARCHAR(7500),
Localtab
title Oracle
Code Block
language sql
INPUTS VARCHAR(4000),
For Berlin specification:
Localtabgroup
Localtab
title MySQL/MSSQL
Code Block
language sql
INPUTS VARCHAR(7500),
Localtab
title Oracle
Code Block
language sql
INPUTS CLOB,

Note

icon	false

Note

If you are using Microsoft SQL, do the following changes, in addition to the step above.

Update the IDN_OIDC_REQ_OBJECT_REFERENCE table in <WSO2_OBKM_HOME>/dbscripts/apimgt/mssql.sql file, by replacing the following lines:

Replace FOREIGN KEY (CONSUMER_KEY_ID) REFERENCES IDN_OAUTH_CONSUMER_APPS(ID) ON DELETE CASCADE with
Code Block
FOREIGN KEY (CONSUMER_KEY_ID) REFERENCES IDN_OAUTH_CONSUMER_APPS(ID)
Replace FOREIGN KEY (TOKEN_ID) REFERENCES IDN_OAUTH2_ACCESS_TOKEN(TOKEN_ID) with
Code Block
FOREIGN KEY (TOKEN_ID) REFERENCES IDN_OAUTH2_ACCESS_TOKEN(TOKEN_ID) ON DELETE CASCADE

To create the database schema, execute the following scripts against the given database:

Localtabgroup

Localtab

title	MySQL

Database Name	Scripts to execute
openbank_am_configdb	`<WSO2_OB_APIM_HOME>/dbscripts/mysql5.7.sql`
openbank_mbstoredb	`<WSO2_OB_APIM_HOME>/dbscripts/mb-store/mysql-mb.sql`
openbank_openbankingdb	For `UK` specification: `<WSO2_OB_APIM_HOME>/dbscripts/finance/dynamic-client-registration/mysql-5-7.sql` `<WSO2_OB_KM_HOME>/dbscripts/finance/openbanking.org.uk/mysql-5-7.sql` `<WSO2_OB_KM_HOME>/dbscripts/finance/event-notification/mysql-5-7.sql` For `Berlin` specification: `<WSO2_OB_KM_HOME>dbscripts/finance/berlin-group.org/mysql-5-7.sql`
openbank_govdb	`<WSO2_OB_KM_HOME>/dbscripts/mysql5.7.sql`
openbank_iskm_configdb	`<WSO2_OB_KM_HOME>/dbscripts/mysql5.7.sql`
openbank_userdb	`<WSO2_OB_KM_HOME>/dbscripts/mysql5.7.sql`
openbank_apimgtdb	`<WSO2_OB_KM_HOME>/dbscripts/apimgt/mysql5.7.sql`

Localtab

title	MSSQL

Database Name	Scripts to execute
openbank_am_configdb	`<WSO2_OB_APIM_HOME>/dbscripts/mssql.sql`
openbank_mbstoredb	`<WSO2_OB_APIM_HOME>/dbscripts/mb-store/mssql-mb.sql`
openbank_openbankingdb	For `UK` specification: `<WSO2_OB_APIM_HOME>/dbscripts/finance/dynamic-client-registration/mssql.sql` `<WSO2_OB_KM_HOME>/dbscripts/finance/openbanking.org.uk/mssql.sql` `<WSO2_OB_KM_HOME>/dbscripts/finance/event-notification/mssql.sql` For `Berlin` specification: `<WSO2_OB_KM_HOME>/dbscripts/finance/berlin-group.org/mssql.sql`
openbank_govdb	`<WSO2_OB_KM_HOME>/dbscripts/mssql.sql`
openbank_iskm_configdb	`<WSO2_OB_KM_HOME>/dbscripts/mssql.sql`
openbank_userdb	`<WSO2_OB_KM_HOME>/dbscripts/mssql.sql`
openbank_apimgtdb	`<WSO2_OB_KM_HOME>/dbscripts/apimgt/mssql.sql`

Localtab

title	Oracle

Database Name	Scripts to execute
openbank_am_configdb	`<WSO2_OB_APIM_HOME>/dbscripts/oracle.sql`
openbank_mbstoredb	`<WSO2_OB_APIM_HOME>/dbscripts/mb-store/oracle-mb.sql`
openbank_openbankingdb	For `UK` specification: `<WSO2_OB_APIM_HOME>/dbscripts/finance/dynamic-client-registration/oracle.sql` `<WSO2_OB_KM_HOME>/dbscripts/finance/openbanking.org.uk/oracle.sql` `<WSO2_OB_KM_HOME>/dbscripts/finance/event-notification/oracle.sql` For `Berlin` specification: `<WSO2_OB_KM_HOME>/dbscripts/finance/berlin-group.org/oracle.sql`
openbank_govdb	`<WSO2_OB_KM_HOME>/dbscripts/oracle.sql`
openbank_iskm_configdb	`<WSO2_OB_KM_HOME>/dbscripts/oracle.sql`
openbank_userdb	`<WSO2_OB_KM_HOME>/dbscripts/oracle.sql`
openbank_apimgtdb	`<WSO2_OB_KM_HOME>/dbscripts/apimgt/oracle.sql`

...

Versions Compared

Old Version 39

New Version Current

Key