Documentation

{{docApp.title}}

{{docApp.description}}

How can we help?

{{docApp.searchError}}
{{product.name}}

Searching in {{docApp.searchFilterBySpecificBookTitle}}

{{docApp.searchResultFilteredItems.length}} results for: {{docApp.currentResultsSearchText}} in {{docApp.searchFilterBySpecificBookTitle}}
Search results have been limited. There are a total of {{docApp.searchResponse.totalResultsAvailable}} matches.

You have an odd number of " characters in your search terms - each one needs closing with a matching " character!

{{docApp.libraryHomeViewProduct.title || docApp.libraryHomeViewProduct.id}}

{{docApp.libraryHomeViewProduct.description}}

  1. {{book.title}}

{{group.title || group.id}}

{{group.description}}

  1. {{book.title}}

{{group.title}}

Authentication

The Asset Relationship Import utility uses Hornbill API Keys to authorize all API calls into Hornbill instances, and KeySafe to securely store credentials for the asset data source.

API Keys

For the utility to read, create and update records via the Hornbill API, it requires an API Key to be securely stored alongside the client.

User

Every action within Hornbill must be performed in the context of a user account. The user account must possess roles for the platform and applications that you are granting access to via the import utility. The above comment about roles refers to the Hornbill Security Model when associating roles with user accounts. This security measure prevents you from inflating your session rights or granting a user more rights than you have yourself.

Important

We strongly recommend that you create a Service Account in your Hornbill instance, and API Keys against that account which can then be used to perform the required API calls back into Hornbill.

Please read the API Key documentation and best practice guide before creating API keys against your user records.

The service account that you create must be of type User (not Basic), and be granted the following roles:

  • User Role - Allows the utility to perform entity actions in the Hornbill platform.
  • Asset Management User - Allows the utility to create and update Asset Management records in Service Manager.
  • Hornbill Service Manager Integrations - Grants several privileges for access to entities and the execution of stored queries. NOTE - This role is only intended for accounts that are used for integrations or to perform data imports, and should not be applied to interactive user accounts.

API Key Rules

The Asset Relationship Imports require access to the following Hornbill Platform and application APIs, and your API Key rules should reflect those, plus additional security hardening in the form of IP rules:

This utility uses (API keys):

admin:keysafeGetKey
data:entityAddRecord
data:entityDeleteRecord
data:entityUpdateRecord
data:getRecordCount
data:queryExec
system:logMessage
apps/com.hornbill.servicemanager/Asset:linkAsset
apps/com.hornbill.servicemanager/Asset:unlinkAsset

KeySafe

For the import utility to access data from your source database, authentication credentials are required to be stored in KeySafe.

Note

We recommend that you read the KeySafe documentation before storing credentials in KeySafe.

Once the relevant key has been created, you can then lock access to it down to the API Key created against your service account. See the KeySafe documentation for more information regarding this.

Key Types

The Asset Relationship Import Utility supports a single KeySafe Key type of Database Authentication, and supports the following database technologies:

  • mssql - Microsoft SQL Server (2005 or above).
  • mysql - MySQL 4.1 or above, or any version of MariaDB.
  • mysql320 - MySQL Server v3.2.0 to v4.0.
  • odbc - ODBC driver.
  • swsql - Supportworks SQL (Core Services >= v3.x).

Key Type - Database Authentication

  • In Hornbill, navigate to Configuration > Platform Configuration > KeySafe.
  • Click + Create New Key.
  • Choose a key type of Database Authentication.
  • Give the KeySafe key a Title.
  • Optionally add a Description.
  • Populate the following fields on the form:
    • Server - The IP address or hostname of your database host.
    • Port - The port used to connect to your database.
    • Database - The database name/ID.
    • Username - The username of the account that should be used to authenticate the connection to your database.
    • Password - The password for the above account.
  • Click Create Key.
In This Document