Reduce Operational Costs and Achieve Bi-directional Sync Between Salesforce and Amazon RDS
The client is a lending marketplace that provides a fresh new approach to franchise financing. The firm’s franchise loan marketplace enables entrepreneurs to efficiently obtain financing to start or expand their franchise business.
Business problem
The client offers Loans and leverages Salesforce, along with their unique back-end PostgreSQL database – to track status, update lenders’ details in real-time before a decision is made.
SaaS applications boast of microservices as a means to divide a monolithic architecture into easily manageable solutions. Sometimes these microservices have their own databases. To maintain data consistency across the system, we need to implement a data synchronization system between source and target data persistence
Solution delivered
Amazon AppFlow is a fully managed integration service that enables you to securely transfer data between SaaS and cloud applications like Salesforce, Marketo, Slack, and ServiceNow, and AWS services like Amazon S3 and Amazon Redshift, in just a few clicks. Trantor Inc has developed a solution using AppFlow to easily synchronize the data between Salesforce and Amazon RDS/PostgreSQL database in near real-time.
Results
30% Cost reduction on third party tools like Heroku Connect and operational overhead
AWS Appflow
AWS Lambda
AWS EC2
AWS RDS
AWS WAL
AWS CloudWatch
