FINS MDM Customers System API - Implementation Template

This implementation template has the following dependencies:

• MariaDB

Please review the use cases described on the MuleSoft Accelerator for Financial Services solution pages for more information about dependencies on other APIs and services.

Configure the MariaDB

These instructions assume that you have a MariaDB version 10.6.8 or later. There are DB Scripts located under src/test/resources/scripts folder.

• To initialize a new database, run the following scripts in order:

  • create-customers-schema.sql
  • create-reference-data.sql
  • create-logging-scripts.sql (optional, for debugging)
  • generate-sp-create-script (produces a script to create all stored procs)
  • create-stored-procedures.sql

• To upgrade a database from a prior release, run the following scripts in order:

  • upgrade-customers-schema.sql
  • drop-stored-procedures.sql
  • generate-sp-create-script (produces a script to create all stored procs)
  • create-stored-procedures.sql

• To drop the tables and stored procedures, execute the scripts drop-customers-schema.sql and drop-stored-procedures.sql, respectively.

• To truncate data from the tables, use the truncate-data.sql script.

Next steps

The Deployment tab provides instructions on how to properly configure the application for running locally from Studio or deploying to CloudHub.