UI Step |
---|
Create a new AWS stackAccess the Perspectium On-demand DataSync appLog into your AWS account and navigate to Services > CloudFormation (under Management & Governance). Then, click Create Stack. Then, go to the AWS Marketplace and search for Perspectium On-demand DataSync. On the app landing page, click Continue to Subscribe in the upper right-hand corner of the screen. On the Subscribe to this Software page, click Accept Terms to accept the terms of the Perspectium End User License Agreement (EULA) and the AWS Customer Agreement. Then, wait for your request to be processed and click Continue to Configuration. |
UI Step |
---|
On the Configure this software page, choose Perspectium On-demand DataSync Deployment from the Fulfillment Option dropdown. Then, choose a Software Version and the Region where your AWS server is located and click Continue to Launch in the upper right-hand corner of the screen. On the Launch this software page, choose to Launch CloudFormation from the Choose Action dropdown. |
UI Step |
---|
Specify the ServiceBond for AWS CloudFormation template URL On the Select Template page, make make sure the Specify an Amazon S3 template URL is selected . Then, enter the following URL: https://s3.amazonaws.com/perspectium-marketplace-apps/psp-ondemanddatasync-download.json and the URL is populated from subscribing to the app. Finally, click Next. Image Removed |
UI Step |
---|
On the resulting page, type a name for your Stack name consisting of letters, numbers, and dashes (e.g., Perspectium-On-demand-DataSync). Under Parameters, enter your Email Address. Optionally, you can specify a range of IP addresses (as a CIDR block; e.g., 192.168.0.0/16) used to SSH to your ServiceBond EC2 instance in the IPRangeforEC2SSH field. Then, choose a previously created EC2 Key Pair for authentication when accessing your ServiceBond EC2 instance via SSH. NOTE: If you haven't already created an EC2 Key Pair, you can create one within your AWS account or using a command line interface.
![](/download/attachments/9110726/screenshot_oddstrial_parameters1.png?version=1&modificationDate=1559953513000&api=v2&effects=border-simple,blur-border)
In the Database Configuration section, choose the Database Type that you want to sync your ServiceNow incident data with from the DBType field. You can optionally enter an existing RDS instance to use (if you have already created one in your AWS account) in the RDSInstanceEndpoint field. Then, specify a range of IP address (as a CIDR block; e.g., 192.168.0.0/16) used to connect to your AWS RDS. Finally, click Next to go on to the Configure stack options page. ![](/download/attachments/9110726/screenshot_oddstrial_parameters2.png?version=1&modificationDate=1559953513000&api=v2&effects=border-simple,blur-border)
|
UI Step |
---|
The Configure stack options page contains some optional configurations you can set for your ServiceBond EC2 instance. For more information on these configurations, see setting AWS CloudFormation Stack Options. However, in most cases, you can simply accept the default options on this page and click Next at the bottom of the page to navigate to the Review page and review your EC2 instance settings. |
UI Step |
---|
Review and launch your AWS stackAt the bottom of the Review page, check the box to acknowledge that AWS CloudFormation might create IAM resources. Then, click Create stack to finish configuring your ServiceBond EC2 instance. NOTE: Your EC2 instance will take approximately 15-20 minutes to fully initialize. You can confirm that your EC2 instance is ready by navigating to Services > EC2 (under Compute) > Instances. Your EC2 instance will be ready when the icon appears in the Status Checks column for your instance.
|
UI Step |
---|
Check for your confirmation emailYou will receive an email from Perspectium Support confirming that your Perspectium On-demand DataSync stack has been configured. Once you receive this email, complete either Step #6a or Step #6b as applicable: 6a) New to Perspectium?If this is your first time using a Perspectium product, note your Perspectium Account ID and Perspectium License Key in your confirmation email. You will need to enter this information on the AWS On-demand DataSync Setup page in Step #9. But for now, proceed to Step #7. ![](/download/attachments/9110726/screenshot_oddstrial_newtopsp.png?version=1&modificationDate=1559953513000&api=v2&effects=border-simple,blur-border)
6b) Already using a Perspectium for ServiceNow app?If you have already installed a Perspectium app on your ServiceNow instance and are comfortable creating ServiceNow shared queues and bulk shares, you can use the Queue name, Endpoint URL, Queue username, Queue password, and Queue Encryption Key in your confirmation email to create a new ServiceNow shared queue in your instance. Then, create a ServiceNow bulk share pointing to the target queue and proceed to Step #11. NOTE: To enable On-demand DataSync with your existing Perspectium app, you must have at least the Fluorine Patch 1 of the Perspectium app with the add display values option enabled in Replicator Properties and the Share schema option enabled under the Advanced tab in your bulk share.
![](/download/attachments/9110726/screenshot_oddstrial_existingpspuser.png?version=1&modificationDate=1559953513000&api=v2&effects=border-simple,blur-border)
|
UI Step |
---|
Install the DataSync for ServiceNow appLog into your ServiceNow instance and use the Filter Navigator to navigate to System Update Sets > Retrieved Update Sets. In the resulting form, click Import Update Set from XML under the Related Links section. Upload the Perspectium DataSync update set (.xml file) from the directory you saved the file in for Step #7. Then, click into the Perspectium Data Sync update set and click Preview Update Set. ![](/download/attachments/9110726/screenshot_oddstrial_previewupdateset.png?version=1&modificationDate=1559953513000&api=v2&effects=border-simple,blur-border)
After Preview Update Set finishes running, close out of the pop-up and check if there are any errors or warnings. If errors or warnings have occurred, they will appear in the list at the bottom of the form under the Update Set Preview Problems tab. Check the box next to each error or warning and choose whether to Accept remote update or Skip remote update. To view previously configured fields and updates that may be affected for each error or warning, click Show local field and/or Show local update. For more information, see preview a remote update set. Once any errors or warnings have been addressed, click Commit Update Set in the upper right-hand corner of the form. After Update Set Commit finishes running, close out of the pop-up. ![](/download/attachments/9110726/screenshot_oddstrial_commitupdateset.png?version=1&modificationDate=1559953513000&api=v2&effects=border-simple,blur-border)
|
UI Step |
---|
Set up your DataSync appIn ServiceNow's Filter Navigator, navigate to Perspectium DataSync > Control and Configuration > Setup. On the User Agreement page, read through the terms of the Perspectium User Agreement and then click I Accept to accept these terms. On the AWS On-demand DataSync Setup page, enter your ServiceNow username and password in the appropriate fields. NOTE: The ServiceNow user must have the role of admin.
Then, enter the Perspectium Account ID and License Key you received in your confirmation email in Step #6 and click Finish Setup. NOTE: If you change your ServiceNow password after entering it on the AWS On-demand DataSync Setup page, you will need to update your ServiceNow Password in your Perspectium Properties by navigating to Perspectium DataSync > Control and Configuration > Properties and then clicking Save after updating your password. For more information about using Perspectium DataSync, see DataSync for ServiceNow.
![](/download/attachments/9110726/screenshot_oddstrial_setupdatasync.png?version=1&modificationDate=1559953513000&api=v2&effects=border-simple,blur-border)
|
UI Step |
---|
Run your ServiceNow bulk shareYou will then be automatically redirected to the Perspectium Bulk Share list view. Click into the On Demand DataSync Incidents bulk share record and then click Execute Now, which will initiate the bulk migration of your existing incident data from ServiceNow to your AWS RDS. ![](/download/attachments/9110726/screenshot_oddstrial_runbulkshare.png?version=1&modificationDate=1559953513000&api=v2&effects=border-simple,blur-border)
|
UI Step |
---|
Download and then open one of the following preconfigured Incident Analytics workbooks for Tableau per the Database Type you selected in Step #3: NOTE: If using a Tableau version higher than 10.2, a pop-up will appear asking you to confirm upgrade to your current Tableau version. Click OK to accept this upgrade.
NOTE: If you have your own Tableau data visualizations that you want to use for ServiceNow data other than incident data, you can skip Steps #11-14.
|
UI Step |
---|
Connect Tableau to your AWS RDSLocate your AWS RDS connection information by logging into your AWS account and navigating to Services > RDS (under Database) > DB Instances (under Resources). Click the name of the stack you created in Step #3. Note your Endpoint and Port under the Connectivity & Security tab. ![](/download/attachments/9110726/screenshot_oddstrial_noteendpointandport.png?version=1&modificationDate=1559953513000&api=v2&effects=border-simple,blur-border)
Back in Tableau, enter your database Server URL (as your AWS RDS Endpoint URL) and Port number. Enter the Username and Password you received in your confirmation email from Perspectium Support in Step #6. If you didn't receive this email, contact Perspectium Support. NOTE: If you opted to use an existing RDS in Step #3, you must update or create a database user in your RDS database with the Username of admin and Password of adminadmin.
Enter this information into the appropriate fields and then click Sign In to finish connecting your Tableau workbook to your AWS RDS. Five preconfigured Tableau dashboards will then populate with the incident data that was bulk migrated from your ServiceNow instance to your AWS RDS. ![](/download/attachments/9110726/screenshot_oddstrial_tableauconnection.png?version=1&modificationDate=1559953513000&api=v2&effects=border-simple,blur-border)
NOTE: If connecting to an Oracle database, enter pspdb in the SID field.
|
UI Step |
---|
Choose Open and Resolved incident typesClick the Open and New Incidents dashboard. Then go to Incident State: Select Open States and check all options that apply to Open states for incidents per your organization's incident management process. Then, click the Resolved Incidents dashboard, go to Incident State: Select Closed States and check all options that apply to Resolved per your organization's incident management process. ![](/download/attachments/9110726/screenshot_oddstrial_tableauselectincidentstates.png?version=1&modificationDate=1559953513000&api=v2&effects=border-simple,blur-border)
|
UI Step |
---|
View Perspectium Incident Analytics dashboardsPerspectium's preconfigured Incident Analytics dashboards provide you with a variety of data visualizations for the incidents managed by your organization, including: Visualization | Description |
---|
Avg Hours to Close | Displays the time that the incidents were closed on and the average number of hours to close | Volume of incidents | Displays the volume of incidents per hour | Resolved by | Displays the magnitude of the number of incidents that a user resolved. | Category of incidents | Displays the number of incidents per category | Assigned to | Displays the number of open incidents assigned to a user. Click on a user to filter all charts by name | Age of Incident | Displays how long an incident has been open (in days) along with the category and current state |
NOTE: To learn more about each Incident Analytics data visualization, hover over the title for a visualization to see its description.
![](/download/attachments/9110726/screenshot_oddstrial_viewvisualizationdescription.png?version=1&modificationDate=1559953513000&api=v2&effects=border-simple,blur-border)
|
UI Step |
---|
Try out Perspectium On-demand DataSyncIf you are new to Perspectium, browse through other DataSync for ServiceNow topics to find out more about how to leverage the power to sync, transform, and visualize your ServiceNow data in various other data stores. |
|