Ardoq’s ServiceNow integration is a two-way integration that allows you to:
Import your ServiceNow data as components and references in Ardoq so you can visualize the dependencies that exist between them and other components in your architecture such as applications, departments, people, etc.
Export your modified ServiceNow data from Ardoq to ServiceNow to to maintain your data up to date at all times.
In this article, we’ll cover how to export your Ardoq data to ServiceNow. To learn how to import your ServiceNow data to Ardoq, refer to this KB article.
Table of Contents:
Before Getting Started
Know that:
New components and references created in Ardoq will be exported to ServiceNow.
Existing components and references that are not modified will not be exported to ServiceNow.
You need to have an existing ServiceNow connection. If you have none, set up your ServiceNow account first. Next, create a new connection by navigating to “Home > Import & Integrations > ServiceNow” and fill in the following details:
Name: The name of this ServiceNow connection, so it can be identified in the list
Base URL: The URL to your ServiceNow instance
Username and Password: Your ServiceNow username and password
Note: Please make sure the Base URL doesn't contain /login.do at the end.
How To Export Your Data From Ardoq To ServiceNow
This guide shows you how to import your server data from ServiceNow to Ardoq. We'll cover the process step-by-step.
To export your data, first do the same steps as in the import flow how-to guide and then come back here. Once you reach the “Configure” step where you map your data to Ardoq’s column types (step 8), you will be able to export your data.
1. Navigate to “Home > Import & Integrations” and select ServiceNow.
2. Select a ServiceNow connection by clicking on the name of the connection.
3. Search for the cmdb_ci_server and any other server table(s) to get a summary of their current state. Please note that the list is filtered based on the provided user's access rights. Depending on your user's roles, that might take some time.
4. Click on the name of your table from the sidebar or in the table to navigate straight to that table's field selector.
5. For each table, select the fields you want to view their value. Next, click the "Fetch Data" button in the top right corner to get your data from ServiceNow.
You can use the “Search” input to filter the list of fields.
Select each field you want to fetch or click the “Select All” button to select all fields.
Reference fields will show two entries in the field list: the label of the reference, and the ServiceNow sys-id of the referenced record. This allows you to create references based on either the ID or name.
6. Select a table to configure its columns.
7. Navigate to “Components” and select any workspace.
8. Next, configure the columns so that the values match your workspace metamodel structure. Here, you can also define the references you wish to export by selecting “Reference” in a column configuration. See the “Create references” KB article for a step-by-step guide on how to create references for ServiceNow data.
9. Click on the ‘Test export” button to perform a test run and get a summary of what would change in ServiceNow.
10. Click on ‘Export all’ to apply the changes in your ServiceNow instance. Make sure to map the "Sys Id" column as a "Custom Id" during column mapping. This way, the exporter is able to match Ardoq elements with ServiceNow elements.
FAQ: Exporting Specific Component Types from Ardoq to ServiceNow
When Exporting data from Ardoq into ServiceNow, it's common to encounter a scenario where a single Ardoq workspace contains multiple component types. By default, all component data within this workspace might get transferred to ServiceNow tables. To refine this process and export only specific component types, follow the steps below:
1. Set Up a Calculated URL Field in Ardoq: Implement a calculated URL field. Utilize the following query, ensuring it's applied exclusively to the component type intended for export to ServiceNow
g.V(ids).
project('id', 'name', 'value').
by(id).
by('name').
by(label)
2. In the ServiceNow table, Either create a new column of type 'string' or identify an existing column within the ServiceNow table designated for this data integration. Please ensure that this selected column contains only dummy data. Ex: Short Description.
3. Connect the previously specified ServiceNow column to the Ardoq field(Calculated field Application URL Export). In the export configuration step, apply a filter with a condition to check if the column data "Is not Empty".
4. . Execute the Export. Once you've initiated the export process, Ardoq will selectively transfer data based only on the specified component types. By following these steps, you can ensure a targeted and efficient data integration from Ardoq to ServiceNow.
Note: In order for this work around to function as intended, it's essential that both fields are present in both Ardoq and ServiceNow. The filter will exclusively be applied to Ardoq components if the field exists in both systems. In such cases, we recommend using the 'class' column as the ServiceNow field, which consistently exists and aligns with the same concept as the Ardoq type.
Please refer to ServiceNow Integration Permissions Overview for setting up permissions for Service now Export.
Troubleshooting The Export
If your ServiceNow data remains unchanged after a successful export in Ardoq, double check your user has write access on the ServiceNow tables in question.
If the issue persists, please contact us at support@ardoq.com or via the in-app chat.