...
A UI will be provided (Figure 1) for a user to select the service he want to migrate into the platform. After selecting the service, the user will be redirected to the migration page (Figure 2).On this page by clicking on download button, the user will have a sample excel sheet template that is acceptable by the platform for the service selected, he can fill the sheet and upload it backto the system , or directly upload the excel sheet containing the data he want to migrate to the platform. After clicking on the upload button, the excel sheet will be send through a POST requestto the data migration service API that I will implement. By the use of Apache POI, the data available on the sheet will be extracted. Considering the fact that each microservices has its own database,I will send the data retrieved in the excel sheet through a POST request to the corresponding service in Fineract CN for the data to be store in the database.
As an example, To migrate offices data form one financial institution to Fineract CN(Figure 3), After selecting the office service on Figure 1, the platform will redirect us to Figure 2 to upload the office excel sheet containing data for migration. After clicking on the upload button, the office excel sheet will be send through a POST request to the data migration service API and by the use of Apache POI the available data on the office sheet will be extracted and send through a a POST request to the office service API available on Fineract CN for the data to be store in the office table.
Sequence diagram showing a workflow of how to migrate customer data using POI,
Various endpoints that will be used for migration.
Figure 2
Group : /datamigration/v1/group
Teller : /datamigration/v1/teller
Customer : /datamigration/v1/customer
Loans : /datamigration/v1/loans
Deposit Account :/datamigration/v1/deposit
Offices : /datamigration/v1/offices
Employees : /datamigration/v1/employees
Tenants : /datamigration/v1/tenants
Journal Entries : /datamigration/v1/journal