Skip to content

Cloud set up for CTA Datamart DB Tableau Server

Jump to bottom
suryayadavalli edited this page Jul 7, 2015 · 5 revisions

High level steps followed to set up Tableau on the cloud (Create VPC and EC2 Windows Instance)

  • Log in to your AWS console.
  • Under Compute & Networking, select VPC.
  • In the upper-right, use the region selector to choose the nearest location
  • Click Get started creating a VPC, choosing VPC with single Subnet only
  • Configure Networking & Security
  • Select VPC (Our VPC id is vpc-d0242eb5)
  • Create a subnet
  • Create Route tables
  • Create Internet Gateways
  • Create Elastic IP for your EC2 Instance (Elastic IP for the EC2 instance where Tableau Server is installed : 52.7.247.106 )
  • Add Inbound / outbound rules for Security Group
  • Launch your VPC in the same availability zone as your VPC

EC2 Instance Information

Public DNS : ec2-52-7-247-106.compute-1.amazonaws.com Instance type :m4.2xlarge

Change /add storage for EC2 instance

  • Open the Amazon EC2 console at https://console.aws.amazon.com/ec2/.
  • Verify that the instance Shutdown Behavior is set to Stop and not Terminate.
  • Choose the instance.
  • From the context-menu (right-click) choose Instance Settings, and then choose Change Shutdown Behavior.
  • If the Shutdown behavior is set to Terminate, choose Stop, and then choose Apply.
  • If the Shutdown behavior is already set to Stop, then choose Cancel.
  • Stop the instance. For more information about how to stop an instance, see Stopping and Starting Your Instances.
  • Create a snapshot of the volume to expand.
  • In the navigation pane, choose Volumes, and then locate the volume you want to expand.
  • From the context-menu (right-click) choose the volume that you want to expand, and then choose Create Snapshot.
  • Enter information in the Name and Description fields, and then choose Yes, Create.
  • Create a new volume from the snapshot.
  • In the navigation pane, chose Snapshots.
  • When the status of the snapshot that you just created is set to completed, choose the snapshot, and then from the context-menu (right-click) choose Create Volume.
  • In the Create Volume dialog box, choose the desired volume type and enter the new volume size. You must also set the Availability Zone to match the instance Availability Zone. Choose Yes, Create.

Tableau Server Information

  • Microsoft® Windows® Server 2012 R2,

  • 64-bit versions of Windows

  • Tableau Server Version 9.0

  • Installation Location on Ec2 instance : C:\Program Files\Tableau\Tableau Server

  • Windows Account (Tableau needs a windows account to run as) : Domain\ username : WIN-8C1CJNRHGGR\Administrator

  • Port on which Tableau server is running : 80

Cloud MS SQL Server Information

  • Host Name: datamart.cvvhlvb3ryja.us-west-2.rds.amazonaws.com:1433

Connecting to Tableau server

URL : http://ec2-52-7-247-106.compute-1.amazonaws.com

Clone this wiki locally