Scalable Tableau Cluster for Insurance Company

USA Fintech
Terraform
Terraform
AWS
AWS
Azure DevOps
Azure DevOps
Tableau
Tableau

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. The infrastructure was managed using Terraform, with CI/CD on Azure DevOps. 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.


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.


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.


Implemented Features

  • Tableau cluster built on AWS with data nodes capable of autoscaling
  • Infrastructure management using Terraform
  • Automated testing and deployment using Azure DevOps
  • Packer-created Tableau image
  • Custom bash script for provisioning
  • Disaster recovery measures for high availability
  • Solution for automated connection to the client's existing company active directory
  • List of connectors for easy data ingestion from various sources, including Microsoft SQL Server, Oracle Database, MySQL, PostgreSQL, Amazon Redshift, Google BigQuery, Salesforce, Excel, and CSV.



See more