The Quick and Dirty of Running Spotfire on AWS

A colleague and I were discussing how a quick list of the steps to setting up Spotfire on AWS. These notes should not be considered complete, merely a high-level overview of setting up Spotfire server as of version 7.10.

Enjoy.

AWS

  1. Create an account on AWS
  2. Create a user on IAM
  3. Configure the Administrator group so that you have access to EC2
  4. Know what region you are working in (ex. us-west-2)
  5. Create a security group on EC2
    1. Open the ports 9080 and 9443
    2. Make sure to save that .pem they are going to give you

SQL Server

  1. Either setup something on RDSĀ or install SQL Server express on the Spotfire server itself (do this later)
  2. Get the connection string

Spotfire

  1. Create at a small size Windows box. Free tier is fine except you will run out of memory really quick, and node manager won’t have enough juice to run.
  2. Log onto the server
    1. Press Connect
    2. Decrypt the password using the pem file
    3. Open then box using Remote Desktop with the username Administrator and whatever the decrypted password is.
  3. Install SQL Server express if you need to, get the connection string
  4. Run the SQL scripts from Spotfire
  5. Install the Spotfire Server
  6. Do the bootstrap and enter the connection string
  7. Make sure the firewall is down (the Amazon security group handles that for you)
  8. Fire up the server

Linux (alternate route)

  1. Get a micro Ubuntu
  2. Apt-get install zip
  3. SFTP over the Spotfire zip from TIBCO
  4. Unpack the install in a nice place
  5. Run the SQL scripts from your own desktop
  6. The installation is a configuration batch job you run, you need to setup that configuration file.
  7. Setup the bootstrap
  8. Fire it up

Node Manager

  1. On the same box install node manager.
  2. When it gets the part about how you want to identify the server, remove the IP address and the mac address, just use the name given by EC2. This is very important.
  3. Fire up the node manager.

Technical Director at Ruths.ai

4 thoughts on “The Quick and Dirty of Running Spotfire on AWS

    1. Blank VM, because I usually make a vanilla image of it for dev purposes. The TIBCO images, however, are great and very cost effective. You’ll still need to be proficient in the installation because when it comes time to upgrade, those TIBCO VMs won’t automatically update (correct me if I am wrong here).

  1. Nice write up! Working on an AWS setup as well. In the documentation it says not to install the node manager on the same machine as the spotfire server. Did you run into any issues with that? I have them on separate ec2 instances but haven’t been able to get them to recognize each other.

    1. I had issues with having them on two boxes; I was unable to get the server to accept the node manager’s certificate from the other server. I think that this is specific to the AWS environment because I’ve never had this problem on-premise. Found that putting them both on the same box resolved the issue.

Leave a Comment

Your email address will not be published. Required fields are marked *