ServiceNow is a SaaS that offers a large set of capabilities, such as configuration- and incident management.
With the current ServiceNow integration, you can fetch data from ServiceNow and import it as components and references into Ardoq. The possibility to perform two-way- and scheduled synchronization is also on its way.
Follow these steps to set up an integration:
1.) Navigate to the Integrations page:
2.) Click the ServiceNow logo:
3.) Create a new ServiceNow connection or select an existing one:
3a) Create a new connection:
Name: User defined name to identify your ServiceNow instance
Base URL: The URL to your ServiceNow instance
Authentication: Your ServiceNow username and password separated by a colon. At the momemt the user needs to have the following roles to be able to list the tables and columns from ServiceNow: admin and personalize_dictionary.
4.) Select the tables you want to import:
- You can use the search-input to filter the list of tables.
- Click each table you want to import, they will be added as collapsible panels for further configuration.
5.) Configure the fields you want to import for each of the tables:
- Again, you can use the search-input to filter the list of columns.
- Click each field you want to import or click the Select All button to import all fields.
6.) Click the Fetch data button on the top right corner to fetch the configured data from ServiceNow:
7.) Configure the column mapping for each of the tables.
7a) Click the Components button to state that elements in this table will create components in Ardoq. (See pt. 10 on how to create references)
8.) Click Configure for each of the tables to navigate to the column-mapping grid.
8a) Select an existing target workspace for the components or define a new one.
8b) Select the correct column configuration to map values to the correct places in Ardoq.
9.) Click the Test Run button to get a summary of what the import will result in.
10.) Finally, click the Import All button to execute the actual import.
When you select a reference-field in step 5, the importer will import both the value and the display value of that particular field from ServiceNow. That means you will get both the sys_id and the display value for the referenced field. A user reference for instance, will import both the unique user sys_id and the user name. This will allow you to create reference based on either the id or the name.
1.) Create a reference based on the sys_id:
Colum type: To create a reference, select the Reference type.
Workspace: This is the source workspace where the referenced component exists or will exist after import.
Type: This is the reference type, for instance, Uses, Implicit etc.
Format: Select Custom ID to create a reference by sys_id.
Field name: The name of the field containing the sys_id in the source workspace.
2.) Create a reference based on the name:
Follow the same steps as above, only for Format select Component path instead. This will create references based on the name of the components in the source workspace.
Also, have a look at this video that demonstrates how to create references: