Follow these steps to set up an integration:

1. Navigate to the Integrations page:

Ardoq azure integrations set up

2. Click the Azure logo:

Ardoq Azure import and integrations

3. Add Ardoq "app" to your Tenant (prerequisite)

1. Open console (powershell for Windows) and log in (should redirect to the browser)

> az login

2. Create service principal for Ardoq application (NB! Use Ardoq app ID which can be found in step 4) and remember output (principal object ID):

> az ad sp create --id d5b22d16-feeb-447d-a3ee-32b0dae7f29a

> ee75834e-756b-4df5-a961-8b636fff598b

3. Assign role (for example Reader=acdd72a7-3385-48ef-bd42-f606fba81ae7) for the service principal:

> az role assignment create --assignee-object-id ee75834e-756b-4df5-a961-8b636fff598b --role acdd72a7-3385-48ef-bd42-f606fba81ae7

4. To find the application go to 'Enterprise Applications' in Azure. In the dropdown 'Application type', choose 'All applications' and search for Ardoq. Assign role accordingly on for example the subscriptions you would like to load resources from.

4. Enter your Azure-credentials and optionally narrow down the context to fetch data from:

Ardoq Azure cloud import

The resources you can choose to import are:

  • Analysis service servers

  • App Service Plans

  • Availability sets

  • Disks

  • Hybrid machines

  • Load balancers

  • Locations

  • Managed clusters

  • Management groups

  • Microsoft SQL databases

  • Microsoft SQL managed databases

  • Microsoft SQL managed instances

  • Microsoft SQL servers

  • Network security groups

  • Network security rules

  • Resource groups

  • SQL databases

  • SQL servers

  • SQL virtual clusters

  • SQL virtual machines

  • Subscriptions

  • Tag values

  • Tags

  • Virtual machine extensions

  • Virtual machines

  • Virtual network subnets

  • Virtual networks

  • Zones

Note: It is recommended to select only the resource types that you will be using as it will be much faster to load.

5. Click on the Fetch data button in the top right corner of the page.

6. Select a table to configure its columns, and navigate to Components. Although all Azure tables contain components, references can be created using column configurations. See the 'Create references' section below for a step-by-step guide on how to create references.

7. Select the Ardoq workspace to import the table into. You can either select an existing workspace or type a name to create a new one.

8. Configure the columns to map the values to the correct Ardoq concepts.

Ardoq configure Azure columns.

9. Click the Test Import button to get a summary of what the import result will be.

Ardoq ServiceNow test import

10. Finally, click the Import All button to execute the actual import.

Create references

A) Create a reference based on the Sys ID

Ardoq ServiceNow create a reference
  • Column type: To create a reference, select the Reference type.

  • Workspace: This is the 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 reference by the target components' sys_id field.

  • Field name: The name of the field on the target components which contains its sys_id.

B) Create a reference based on the component name

Ardoq ServiceNow create reference

Follow the same steps as above, only that for Format select Component path instead. This will create references based on the name of the targeted components.

FAQ

Why does the Resource Groups preview show all resource groups even though I have selected only a single resource group?

The Resource Group type is considered a special case as it will list all resource groups that the role has access to regardless of which you have selected.

Did this answer your question?