Automation, zBlog
Launching Trantor’s Quick Start deployment for data replication from Salesforce to AWS RDS using AppFlow
trantorindia | Updated: August 31, 2021
SaaS applications are becoming highly crucial in today’s world, with the adoption only increasing as time passes. However, it comes with one major challenge – now, data lives in many different places or silos. Therefore, it is important to collate all the data and then analyze it to obtain insights.
Without properly collated data, developers have to spend lots of time developing custom integrations to pass data from SaaS applications to AWS services for analysis. This can be an extremely costly process. Further, companies without any engineering teams or experts might struggle with the manual import and export from applications, which in itself is a time-consuming task, riddled with human errors and data leakages. This is why Amazon AppFlow was developed.
Trantor has developed a Quick Start template that deploys the uni-directional data synchronization solution on the Amazon Web Services (AWS) to sync data from Salesforce to Amazon RDS PostgreSQL.
What is AWS Quick Start?
Quick Starts are automated reference deployments built by Amazon Web Services (AWS) solutions architects and AWS Partners. Quick Starts help you deploy popular technologies on AWS based on AWS best practices for security and high availability. These accelerators reduce hundreds of manual procedures into just a few steps so that you can build your production environment in minutes and start using it immediately.
Trantor’s Innovation Combined with AppFlow and Quick Start Automated Deployment
We went on the mission to combine AppFlow with Quick Start’s easy one-click deployment with our innovation after realizing a few challenges that need to be addressed. Some of those challenges include:
- High syncing costs even for fewer tables
- No support for custom field synchronization
- Difficulty in debugging due to less verbose logs
- No time frame for resolution of new issues
- Customization of replication system resources to bring down costs
Trantor has developed a custom solution that uses Amazon AppFlow to replicate data from Salesforce to Amazon PostgreSQL RDS. This solution is deployed directly by an AWS Quick Start for smoother deployment. Trantor’s unidirectional system makes this possible by making use of the following Amazon services, apart from AppFlow:
- Amazon S3 is an object storage service that offers top-notch scalability, security, data availability, and performance.
- Amazon Lambda is a serverless computing service for running code without deploying or managing servers.
By leveraging the AWS services, Trantor has built a custom replication system to make the system much more secure and scalable. Further, the ability of the solution to be customizable as per the client’s requirements makes it a good fit for data replication. In working on this solution, Trantor has successfully managed to provide the following benefits:
- One-click deployment of AppFlow integration with the help of a Quick Start
- Simplified integration with different applications
- Extensive customization based on data sources
- Simple and easy-to-use user interface
- Low latency and real-time updates
- High volume data analytics
- Reduced operational costs
- Lesser time spent and more accuracy achieved
Apart from this, our solution has saved 40% in cost, 70% in terms of time spent, and enabled cross-functional data integration without hassles!
With the unidirectional information flw offered by Trantor, any changes made by any user on a particular data source – say CRM data for example – are sent to the AWS connector – which connects different sources and brings all the data together. From there, the updated data is reflected on the system in real-time that can be viewed easily.
Since the solution is published as an AWS Quick Start, you can use the following link to check it out: https://aws.amazon.com/quickstart/architecture/amazon-appflow/
The solution lets you synchronize data securely between Salesforce and Amazon RDS for PostgreSQL in real-time. For a Fintech client offering loans, Trantor’s solution leverages Salesforce and the unique backend Amazon RDS database to track status, updates, and lender details in real-time before a decision is made. The data synchronization system includes bi-directional and unidirectional syncing of data across multiple Salesforce and PostgreSQL tables as well.
Trantor has been empowering enterprises across the globe with technologically enabled and growth-oriented solutions. The passion for delivering the best feeds into synergistic bonds we form with our clients. Our forward-looking approaches and ideas help us develop solutions that cater to your business needs – of the present and the future.
