Tableau Cluster for Insurance Company
Location: USA
Industry: Fintech
About the project
Client and Product
The client, an insurance company, required a highly scalable and resilient Tableau cluster built on AWS with data nodes capable of autoscaling.
The system needed to seamlessly integrate with their existing company active directory, and allow for easy data ingestion from various sources using connectors.
Challenges
The main challenge for the project team was to build a highly scalable and resilient Tableau cluster that could handle the client’s analytics needs, while also integrating seamlessly with their existing company active directory.
In addition, the team needed to implement a solution for easy data ingestion from various sources using connectors.
Job Done
The AppRecode team successfully built a highly scalable and resilient Tableau cluster on AWS that met the client’s analytics needs.
They used Terraform to manage the infrastructure, and Azure DevOps for automated testing and deployment. Packer was used to create a Tableau image, and a custom bash script was developed to automate the provisioning process.
Disaster recovery measures were implemented, and a solution for automated connection to the client’s existing company active directory was developed. A list of connectors was also implemented to enable easy data ingestion from various sources.
Implemented features
Highly Scalable and Resilient Tableau Cluster on AWS
Deployed a Tableau cluster on AWS with data nodes capable of autoscaling, ensuring high availability and fault tolerance through load balancing and real-time resource adjustment based on demand.
Infrastructure Management with Terraform
Utilized Terraform for Infrastructure as Code to automate the provisioning and management of AWS resources, creating reusable and version-controlled modules for consistent and rapid deployments across environments.
Automated Testing and Deployment using Azure DevOps
Integrated Azure DevOps pipelines for Continuous Integration and Continuous Deployment, setting up automated testing frameworks to validate infrastructure configurations before deployment and streamlining the deployment process.
Custom Tableau Server Image Creation with Packer and Automated Provisioning
Used Packer to build a custom Amazon Machine Image pre-installed with Tableau Server and developed a custom bash script to automate the provisioning and configuration of Tableau Server instances, ensuring consistency and reducing setup time for new instances.
Disaster Recovery Measures for High Availability
Implemented backup and restore procedures, configured multi-Availability Zone deployments to protect against data center failures, and set up automated failover mechanisms to minimize downtime during outages.
Implementation of Data Connectors for Easy Data Ingestion
Integrated a comprehensive list of data connectors to facilitate data ingestion from multiple sources, including databases like Microsoft SQL Server, Oracle Database, MySQL, PostgreSQL, Amazon Redshift; cloud services like Google BigQuery and Salesforce; and files like Excel spreadsheets and CSV files.
Outcomes
The insurance company now has a highly scalable and resilient Tableau cluster that seamlessly integrates with their existing company active directory and allows for easy data ingestion from various sources. The system is managed efficiently using Terraform, and automated testing and deployment is facilitated using Azure DevOps. The use of Packer to create a Tableau image and the custom bash script for provisioning allowed for faster and more reliable deployments. Disaster recovery measures ensure high availability of the system.
REQUEST A SERVICE
Get in touch
Contact us today to find out how DevOps consulting and development services can improve your business tomorrow.
Anna Dzuba
VP of Delivery of “Relevant Software” Company
The DevOps services provided by Apprecode are comprehensive and cover all aspects of a project, from planning to deployment. They worked closely with me to assess my needs and develop a strategy to best address them. The team was able to quickly create a deployment plan that was tailored to my specific requirements.