ArtsVision's platform provides their clients with a robust RESTful interface for securely accessing client data. However, the RESTful interface is not condusive for certain client use cases, e.g. heterogenous reporting, internal SLA access requirements to ArtsVision data, or bulk data analysis and cleansing. ArtsVision clients needed a secure and cost efficient mechanism to receive continual data updates which can be stored within their own RDMS systems.
Kickstep was able to meet ArtsVision's needs through the use of AWS Services, AWS SAM (Serverless Application Model) Framework and the application of AWS Well Architected Framework principles.
Benefit 1 - Operating as a serverless solution, the recurring monthly operating costs are under $50 per month for even the largest client of ArtsVision.
Benefit 2 - By following AWS SAM best practices, the benefits of a strong DevOps environment are realized, including maintaining similarities between development and production environments as well as eliminating requirements for humans to manually configure AWS infrastructure and services.
Benefit 3 - Building the solution around AWS Data Migration Services allowed the solution to work with almost any client RDBMS environment while also preventing any customization of the application logic per install.
1 - The step function is initiated either through the AWS CLI or through the AWS console.
2-4 - The step function is supported by a series of NodeJS 10 Lambda functions which querty the 3rd party REST server to:
5 - Perform a one time full import from an S3 source to an RDS SQL target. Each entity has it's own folder in S3 and it's own source endpoint in DMS.
1 - The CDC step function is initiated either through the AWS CLI, through the AWS console or through a time-based event in CloudWatch.
2-4 - The step function is supported by a series of NodeJS 10 Lambda functions which query the 3rd party REST server to:
5 - The DMS tasks is configured to perform CDC functions using the entity's CDC folder in S3 as a source and the SQL RDS environment as the target.
Kickstep Technologies is a leading technology firm providing cloud consulting, software development, data analytics and machine learning services. We use our experience to ensure clients have the best technical solutions to solve their business challenges and deliver value for their organization. We are fully committed to the success of our clients and commit to always putting their needs and interests before our own.