How does the BFSI connector ensure data consistency and integrity during operations?
@naveen.gupta @Vikas_Dhillon could you answer this please?
The BFSI Connector ensures data consistency and integrity through below mechanisms:
-
Transaction Management: All CRUD operations within the microservice are managed in a transactional manner. This ensures that any operation that involves multiple steps (such as updating related tables) is either completed or rolled back if an error occurs, maintaining data consistency.
-
Validation Layers: Before performing any operation, the BFSI Connector will perform input validation to ensure data integrity (As of now it is not available, part of roadmap). As of now it does the basic checks like primary key, foreign key constraints, data types specific to each entity & table.
-
Concurrency Control: The microservice handle concurrent updates, preventing data corruption when multiple users try to modify the same data at the same time.
-
Database Constraints: The tables are defined with proper primary keys, foreign keys, unique constraints, and other database-level integrity rules to prevent invalid data from being stored.
-
Error Handling & Logging: In case of errors during any CRUD operation, appropriate error messages are generated and logged for further troubleshooting.
By combining these techniques, the BFSI Connector maintains data consistency and integrity during all operations.
1 Like