Access to the ServiceTrade Data Warehouse with Amazon QuickSight is available only to ServiceTrade Enterprise customers.  For more information about ServiceTrade Enterprise, contact sales@servicetrade.com.


Amazon QuickSight is a low-cost, high-performance business intelligence and reporting tool.  By leveraging ServiceTrade's integration with QuickSight, managers, owners, and business analysts can gain insights into customer service data.

Connecting to Amazon QuickSight

Before you begin

  1. If you are not currently a ServiceTrade Enterprise customer:  contact sales@servicetrade.com to upgrade your ServiceTrade account to Enterprise.  More information about ServiceTrade Enterprise is available here.
  2. Sign up for an Amazon QuickSight account.
  3. Contact ServiceTrade support at support@servicetrade.com to receive your ServiceTrade Data Warehouse username, password, and schema.

Connecting to the data warehouse

Your ServiceTrade data is made available to QuickSight through an Amazon Redshift data warehouse.  To use QuickSight, you will need to connect your QuickSight account to your data warehouse.  The initial connection process will connect QuickSight to your data warehouse and 

  1. Log into QuickSight
  2. Click ‘Manage Data’
  3. Click ‘New Data Set’
  4. Click ‘Redshift (manual connect)’
  5. Enter the following:
  • Data source name:  ServiceTrade Data Warehouse
  • Database server:  redshift-1.servicetrade.com
  • Port:  5439
  • Database name:  main
  • Username:  <your assigned data warehouse username>
  • Password:  <your assigned data warehouse password>
  1. Click ‘Validate Connection’ to confirm connection parameters
  2. Click ‘Create data source’
  3. Choose the schema that you were assigned
  4. Choose the data source table that you want to visualize, such as ‘jobs’.  (You can create additional data sources for other tables later)
  5. Click ‘Directly query your data’
  6. Click ‘Edit/Preview data’
  7. If desired, change the name of the data source, then click ‘Save’

Adding more data source tables

  1. Log into QuickSight
  2. Click ‘Manage Data’
  3. Click ‘New Data Set’
  4. In ‘Existing data sources’, click the data source you created when originally setting up QuickSight (such as 'ServiceTrade Data Warehouse')
  5. Click ‘Create data set’
  6. Choose the schema that you were assigned
  7. Choose the data source table that you want to visualize
  8. Click ‘Directly query your data’
  9. Click ‘Edit/Preview data’
  10. If desired, change the name of the data source, then click ‘Save’

Repeat this process for each additional data source table that you want to visualize.

Refreshing a data source table

ServiceTrade may periodically add new columns to your data warehouse tables.  To gain access to those new columns, you will need to refresh your data source table.

  1. Log into QuickSight
  2. Click ‘Manage Data’
  3. Cick the data set to be refreshed
  4. Click ‘Edit data set’
  5. See that the new columns are available in the list of fields on the left
  6. Click ‘Save’

Note:  It is NOT necessary to refresh your data source tables to get updated data (new jobs, invoices, etc) from ServiceTrade -- that data will be updated automatically on a set schedule.  Manually refreshing a data source table is only needed to gain access to new columns of data in your data warehouse.

Please review this article for more information about the specific fields included in each data warehouse dataset.

Did this answer your question?