FINS Snowflake Financial System API - Implementation Template

(0 reviews)

home

This API implementation template is a component of MuleSoft Accelerators, which accelerate the implementation of essential integration use cases.

The solution includes pre-built APIs, connectors, and integration templates that help unlock business-critical data from external systems and guide you in adopting best practices synthesized from thousands of customer implementations. Use these assets as is or extend them to meet your company’s unique needs.


Overview

This integration template implements the FINS Finanicial Data Cloud System API specification, using Snowflake as the back-end.

This implementation currently supports the following operations:

  1. Create Financial Accounts and Transactions
  2. Search Financial Accounts and Transactions

Getting started

bulb.png The Getting Started with MuleSoft Accelerators guide provides general information on getting started with the accelerator components. This includes instructions on setting up your local workstation for configuring and deploying the applications.

Once your workstation has been set up and the application template imported into Anypoint Studio, proceed with the Prerequisites section.

Prerequisites

This implementation template has the following dependency:

  • Create Tables in Snowflake

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.

Create tables in Snowflake

These instructions assume admin access to the Snowflake org with permissions to create databases, schemas, and tables.

  1. Create a Snowflake instance (account) and open a worksheet.
  2. Copy the contents of the create-db-schema.sql file from the src/test/resources project folder to the worksheet
  3. Run the worksheet to create the database, schema and necessary tables.

To create the required tables in an existing schema, modify the above script as appropriate before running it.

Deployment

Each Accelerator implementation template in Exchange includes Bash and Windows scripts for building and deploying the APIs to CloudHub. These scripts depend on repositories, global settings, deployment profiles, and associated properties configured in the Maven settings.xml file.

For additional details, please refer to the Application Deployment section of the Getting Started Guide.

Preparation

Ensure the Maven profile CloudHub-FINS-DEV has been properly configured in your settings.xml file. In particular, make sure the common properties for your environment have been provided (e.g., Anypoint Platform client ID and secret).

Required property overrides

At a minimum, the following properties must be customized to reflect the target deployment environment.

Property NameDescription
api.autodiscoveryIDRequired if using API Manager to secure this API
db.snowflake.accountnameSnowflake Instance account name
db.snowflake.usernameSnowflake Instance DB user name
db.snowflake.passwordSnowflake Instance DB password

Testing

Use Advanced Rest Client or Postman to send a request over HTTPS. The template includes a Postman collection in the src/test/resources folder. Update the collection variable(s) after successful import.

Additional resources


Reviews

TypeTemplate
OrganizationMulesoft Inc.
Published by
MuleSoft Solutions
Published onNov 10, 2023
Asset overview

Asset versions for 1.6.x

Asset versions
VersionActions
1.6.6
1.6.5
1.6.4
1.6.2