Hornbill Open Integration Tools

Home > Integration > Hornbill Open Integration Tools

Introduction We provide an ever-expanding list of utilities for integrating and extending the Hornbill platform. Our team here at Hornbill support many of these tools via our community channels and we encourage our customers and technology partners to get involved.

Related Articles Essential Integrations Advanced Integrations API Keys

Documentation & Links

These tools and examples provide a great resource for getting started with API/WebHook level integrations with our platform. All of these tools are open source and are freely available in source code from our GitHub repository. Please also see our integration page for more details and documentation on specific tools that are in common use. Hornbill GitHub Repository

Import Utilities

User Import

• LDAP User Import Tool - Used for one-off or scheduled imports of user data into your Hornbill instance
• SQL User Import Tool - Used for one-off or scheduled imports of user data into your Hornbill instance
• Azure User Import Tool - Used for one-off or scheduled imports of user data into your Hornbill instance
• Google Workspace User Import - Used for one-off or scheduled imports of user data into your Hornbill instance

Contact Import

• SQL Contact Import Tool - Used for one-off or scheduled imports of contact data into your Hornbill instance

Document Import

• Document Import Tool - Used for one-off or scheduled imports of documents into Document Manager on your Hornbill instance

Organisation Import

• SQL Organisation Import Tool - Used for one-off or scheduled imports of organisation data into your Hornbill instance

Request Import

• Supportworks Request Data Migration Tool - Used to migrate historic and active call/ticket/request data from Supportworks 7.x or 8.x to Hornbill Service Manager
• ServiceNow Request Data Migration Tool - Used to migrate historic and active call/ticket/request data from ServiceNow to Hornbill Service Manager
• Service Manager Request Import Utility - A generic tool used to migrate historic and active call/ticket/request data from any MySQL, MariaDB, MSSQL or ODBC data source into Hornbill Service Manager

Asset Import

• Asset Data Import Tool - Used to import and update asset data from common IT Asset tools such as Microsoft SCCM, Lansweeper, Certero and many others
  • See this page if importing asset data from Supportworks
• CSV Asset Import Tool - DEPRECATED Used to import and update asset data from csv files
• Snow License Manager Cloud Asset Import - Used to import and update asset data from Snow License Manager in the Cloud
• Asset Relationship Import Tool - Used to import and update asset relationship data from an external data source
• Hornbill Meridian Asset Tag Import - Used to Hornbill asset records with Aruba Meridian hardware asset tag information

Other

• Role Finder - Used to find roles on an instance for a given right.
• Google Forms - The Google Forms Integration allows you to interact with the Service Manager app by allowing Google forms to create new requests or update existing requests using the Google Forms questions and storing the answers back into a request's custom fields.

Orchestration and Automation

• Hewlett Packard Enterprise Operations Orchestration Integration - Used to enable HPEOO administrators to include Hornbill Collaboration and Service Manager automations in their flow orchestrations.
• Microsoft System Center Orchestrator Integration - Used to enable MS System Center Orchestrator Integration administrators to include Hornbill Collaboration and Service Manager automations in their Runbook orchestrations.
• Microsoft Azure and Operations Management Suite Integration - Used to enable MS Azure and OMS administrators to include Hornbill Collaboration and Service Manager integrations in their Azure Runbook orchestrations, OMS Alerts and OMS log management.

Virtual Agents

• Hornbill Power Virtual Agent - A Power Virtual Agent (chatbot) that runs in MIcrosoft Teams and/or other chatbot channels (Solution)

Utilities

Data Extraction

• Power BI Reporting - Used to enable Power BI administrators to use the Hornbill Reporting and Trending Engine APIs as Data Sources within Power BI reports and dashboards (R Scripts and Python Scripts)
• Hornbill Report Runner - This utility provides a quick and easy method of running reports on your Hornbill instance, and retrieving the report output files for storage locally (Source Code)
• Hornbill Data Export Tool - This utility provides a quick and easy method of running reports on your Hornbill instance, and exporting the report output into a local database (Source Code)

Data Removal

• Hornbill Cleanup Utility - Used to clear down test data, typically used before a customer go-live to get the request data into a known empty state (Source Code)
• User Role Removal Utility - This utility allows for the removal of ALL roles for a list of users (given in CSV file). (Source Code)
• Request Attachment Archiver - This utility allows for the archiving of file attachments to Hornbill Service Manager Requests. (Source Code)
• Email Archiver - This utility allows for the archiving of emails from within Hornbill. (Source Code)

Miscellany

• Hornbill API Scheduler - The utility provides a quick and easy way to schedule the running of Hornbill API’s (Source Code)
• Simple List Import Utility - This utility allows for the population of Simple Lists which can thus be a scheduled activity. (Source Code)
• Task Cancelation Utility - This utility allows for the removal of Hornbill Tasks. (Source Code)
• Service Translation Tool - This utility allows for the bulk translation of Hornbill Service Manager Services and associated records. (Source Code)