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.
Important - please read first:
- Access to your Data Warehouse for use with Amazon QuickSight is available only to Enterprise customers. More information about ServiceTrade Enterprise is available here.
- Amazon QuickSight is a cloud application and tool separate from your ServiceTrade account. You will need first to sign up for an Amazon QuickSight account and log into it before being able to move your ServiceTrade data into it.
- Contact ServiceTrade support at support@servicetrade.com to receive your ServiceTrade Data Warehouse username/schema and password. This information is specifically for connecting ServiceTrade to QuickSight after you have logged in to the application and is not your account name or password to log into Amazon's QuickSight services.
Step 1: Connecting to Amazon QuickSight
Amazon QuickSight is a cloud application and tool separate from your ServiceTrade account. You will need first to sign up for an Amazon QuickSight account and log into it before being able to move your ServiceTrade data into it.
- Open https://aws.amazon.com/ in your browser.
- Select the Sign in to the Console button in the top right corner.
- Select Create a new AWS account
- Enter the administrator account email address and a AWS account name.
- Example: ServiceTrade's AWS account name is 'servicetrade'
- When done click select Verify email address
- Amazon will email you a verification code from no-reply@signup.aws.com for the next step
- Enter the Code in the Verification code field and select Verify
- Set the password for the account, remember to save it securely.
- Enter your business information in the next screen.
- Enter your payment information
- Amazon will send you a code or call you to confirm your identity.
- On the Select a support Plan screen, choose the Basic support - Free plan option.
- Click Complete sign up.
- Then sign in to your AWS account.
Step 2: Subscribing to QuickSight
- Login to your AWS Account.
- Open the Services Directory in the top left corner of the screen.
- Select Analytics.
- From the AWS Management Console, click QuickSight.
- You can find it under the Analytics Menu or by searching 'QuickSight'
- You can find it under the Analytics Menu or by searching 'QuickSight'
- Choose Sign up for QuickSight.
- Choose Enterprise. The one without 'Q'.
- In the Authentication method section, select Use IAM federated identies & Quicksight Managed Users.
- For QuickSight region select US East (N. Virginia)
- Enter a unique account name for QuickSight.
- Your account name can only contain characters (A–Z and a–z), digits (0–9), and hyphens (-).
- Enter a notification email address for the QuickSight account owner or group. This email address receives service and usage notifications.
- Select Finish.
Step 3: Connecting to the Data Warehouse
Your ServiceTrade data is available to QuickSight through an Amazon Redshift data warehouse. To use QuickSight to create reports and visualizations from your ServiceTrade data, you must connect your QuickSight account to your data warehouse.
The initial connection process will connect QuickSight to your data warehouse and allow you to access any ServiceTrade data warehouses going forward.
- Log into Amazon QuickSight
- Click ‘Manage Data’
- Click ‘New Data Set’
- Click ‘Redshift (manual connect)’
- Enter the following:
Field Enter the following Data source name ServiceTrade Data Warehouse Database server redshift-1.servicetrade.com Port 5439 Database name main Username (schema) <your assigned data warehouse username> Password <your assigned data warehouse password> - Click ‘Validate Connection’ to confirm connection parameters
- Click ‘Create data source’
- Choose the schema that you were assigned
- Choose the data source table that you want to visualize, such as ‘jobs’. (You can create additional data sources for other tables later)
- Click ‘Directly query your data’
- Click ‘Edit/Preview data’
- *optional If desired, change the name of the data source.
- Click ‘Save’
Adding More Data Source Tables
- Log into Amazon QuickSight
- Click ‘Manage Data’
- Click ‘New Data Set’
- In ‘Existing data sources’, click the data source you created when originally setting up QuickSight (such as 'ServiceTrade Data Warehouse')
- Click ‘Create data set’
- Choose the schema that you were assigned
- Choose the data source table that you want to visualize
- Click ‘Directly query your data’
- Click ‘Edit/Preview data’
- *optional 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.
- Log into QuickSight
- Click ‘Manage Data’
- Click the data set to be refreshed
- Click ‘Edit data set’
- Confirm that the new columns are available in the list of fields on the left
- 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.
Alternate BI Tools
You may choose to visualize your data with a business intelligence tool other than Amazon QuickSight (such as Domo or Power BI). If so, your BI tool will need to support PostgreSQL connections. The instructions above should provide enough information for you to configure your BI tool. Please note the following:
- ServiceTrade provides support only for Amazon QuickSight. Other BI tools are not officially supported.
- You will need to provide ServiceTrade with a static IP address from which your BI tool will connect to your ServiceTrade data warehouse.
Comments
0 comments
Please sign in to leave a comment.