Cloudaware Application in ServiceNow

Prerequisites

1. Ensure you have the license for ServiceNow IntegrationHub Enterprise Pack.

2. Ensure you have the license for ServiceNow Workflow Studio.

3. Сontact support@cloudaware.com to get credentials required for this integration (Service Account private key & password, the .p12 certificate file, Import Project Id, and Import Dataset Id).

4. Download the .xml file for application installation.

Configure Cloudaware application in ServiceNow

Cloudaware provides credentials for setting up ServiceNow-to-Google integration. This integration is required for authorization based on JWT. JWT Provider will be used as Connection when configuring the data update workflow.

Set up ServiceNow-to-Google integration

1. Set up JWT key(a) and JWT certificate(b):

a) Go to All → System OAuth → JWT Keys.

Click New and fill out the form:

WHERE
Name: set up a meaningful name, e.g. Google JWT Key
Signing Key: insert the password provided by Cloudaware
Signing Keystore: click the magnifier icon (Lookup using list) to create a new signing keystore - see the point b) below

b) In a pop-up window, click New to create a JWT certificate that will serve as a signing keystore:

WHERE
Name: set up a meaningful name, e.g. Google JWT Certificate
Type: select 'Java Key Store' from the list
Key store password: insert the password provided by Cloudaware

Click the paper clip icon (Manage attachments):

Click Choose file to attach the .p12 certificate file provided by Cloudaware. Click Submit.

c) Go back to setting up the JWT key. In Signing Keystore, click the magnifier icon (Lookup using list) and click the certificate name Google JWT Certificate in the pop-up window.

Click Submit.

2. Сreate JWT Provider.

Go to All → System OAuth → JWT Providers:

Click New and fill out the form:

WHERE
Name: set up a meaningful name, e.g. Google JWT Provider
Signing Configuration: click the magnifier icon (Lookup using list) and select the created key from the list (in this example, Google JWT Key)

Click the name of the JWT provider (in this example, Google JWT Provider). Select the tab 'Standard Claims'. Add the following claims:
iss - string - Service Account email address provided by Cloudaware
sub - string - Service Account email address provided by Cloudaware
aud - string - https://oauth2.googleapis.com/token

Click Update.

3. Сreate Application Registry:

Go to All → System OAuth → Application Registry.

Click New → select 'Connect to a third party OAuth Provider' from the list.

<…>

WHERE

Name: set up a meaningful name, e.g. …
Client ID: set up as notneeded
Client secret: set up as notneeded
Token: click the lock icon to insert https://oauth2.googleapis.com/token → click the lock icon again to save.
Default grant type: select 'JWT Bearer' from the list
Click Submit.

Click the name of OAuth Entity Profile (in this example, Google JWT default_profile).

<…>

In JWT Provider, click the magnifier icon (Lookup using list) and select 'Google JWT Provider' from the list.
<…>

Click Update.

4. Go back to JWT Providers. Select the configured Google JWT Provider from the list.

Select the tab 'Custom Claims'. Add a new claim: scope - string - https://www.googleapis.com/auth/bigquery

Click Update.

5. Create Connection:

Go to All → Connections & Credentials → Credentials. Click New.

<…>
Select 'Auth 2.0 Credentials' from the list. For the oAuth Entity Profile, select 'Google JWT Profile' that was created earlier. Using the right-click on the upper part of the page, select Save.
<…>

Click Get OAuth Token to test the connection.

Go to All → Connections & Credentials Aliases. Click New.

Set the name as 'Google JWT' and save. In the table below, click New to create a HTTP(s) Connection.

For Credential, select JWT Credentials record created earlier.
Check the box URL builder - in Host input the link http://bigquery.googleapis.com; in Base path input the link  - /bigquery/v2/
Save.

Install the Cloudaware application

1. Go to All → Retrieved Update Sets:

2. Click the link Import Update Set from XML.

3. Choose the .xml file downloaded before. Click Upload.

4. Select the created application.

5. Click Preview Update Set.

6. Click Commit Update Set to install the application.

Configure the workflow

1. Go to All → Workflow Studio:

2. Open 'Flows'. Select the flow Initial Filling Of The Mapping Data Table.

Click Test → Run test*:

3. Go back to all flows. Set descending order in the column 'Updated' for quicker search. Select the flow Import All data from Cloudaware from the list.

4. Schedule a trigger. Select Scheduled → Daily* → set the time:

Click Done.

5. Set Flow Variables:

WHERE

Manage Imports Table - the value is auto-populated as this is a system table

Connection - select the JWT Provider configured in the section 'Set up Cloudaware application in ServiceNow' (point 1)

Mapping Table - the value is auto-populated as this is a system table

Import Project Id - use the Import Project Id provided by Cloudaware

Import Dataset Id - use the Import Dataset Id provided by Cloudaware

Click Done.

6. Save and activate the workflow.

Tables

As a result, the following tables will be created in ServiceNow:

System tables

Application tables

Data upload status check

To check the data upload status, append /x_gigwa_cloudawa_2_list_of_imported_tables_list.do to the current URL in your web browser.

The full URL should be in the format https://YOURINSTANCE.service-now.com/x_gigwa_cloudawa_2_list_of_imported_tables_list.do, where 'YOURINSTANCE' is a placeholder for your ServiceNow instance ID.