Difference between revisions of "Hornbill Open Integration Tools"

Latest revision as of 16:48, 10 November 2023

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.

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)

@@ Line 7: / Line 7: @@
 |style="width:73%"|
 ==Introduction==
-We provide an ever expanding list of open-source tools for integrating and extending the Hornbill platform. We release these tools as open source tools under a very liberal open source licence (shown below). 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.
+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.
 |style="width:5%"|
 |
@@ Line 25: / Line 25: @@
 ==Import Utilities==
 ===User Import===
-* [[LDAP_User_Import|LDAP User Import Tool]] - Used for one-off or scheduled imports of user data into your Hornbill instance ([https://github.com/hornbill/goLDAPUserImport Source Code])
+* [[LDAP_User_Import|LDAP User Import Tool]] - Used for one-off or scheduled imports of user data into your Hornbill instance
-* [[SQL_User_Import|SQL User Import Tool]] - Used for one-off or scheduled imports of user data into your Hornbill instance ([https://github.com/hornbill/goDb2HUserImport Source Code])
+* [[SQL_User_Import|SQL User Import Tool]] - Used for one-off or scheduled imports of user data into your Hornbill instance
-* [[Azure_User_Import|Azure User Import Tool]] - Used for one-off or scheduled imports of user data into your Hornbill instance ([https://github.com/hornbill/goAzure2HUserImport Source Code])
+* [[Azure_User_Import|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|SQL Contact Import Tool]] - Used for one-off or scheduled imports of contact data into your Hornbill instance ([https://github.com/hornbill/goDb2HcontactImport Source Code])
+* [[SQL_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|Document Import Tool]] - Used for one-off or scheduled imports of documents into Document Manager on your Hornbill instance ([https://github.com/hornbill/goHornbillDocumentImport Source Code])
+* [[Document_Import_Tool|Document Import Tool]] - Used for one-off or scheduled imports of documents into Document Manager on your Hornbill instance
 ===Organisation Import===
-* [[SQL_Organisation_Import|SQL Organisation Import Tool]] - Used for one-off or scheduled imports of organisation data into your Hornbill instance ([https://github.com/hornbill/goHornbillOrgImport Source Code])
+* [[SQL_Organisation_Import|SQL Organisation Import Tool]] - Used for one-off or scheduled imports of organisation data into your Hornbill instance
 ===Request Import===
-* [[Supportworks_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 ([https://github.com/hornbill/goSWRequestImport Source Code])
+* [[Supportworks_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_Import|ServiceNow Request Data Migration Tool]] - Used to migrate historic and active call/ticket/request data from ServiceNow to Hornbill Service Manager ([https://github.com/hornbill/goServiceNowRequestImporter Source Code])
+* [[ServiceNow_Request_Import|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|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 in to Hornbill Service Manager ([https://github.com/hornbill/goHornbillRequestImport Source Code])
+* [[Service_Manager_Request_Import_Utility|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===
-* [[Database_Asset_Import|Asset Data Import Tool]] - Used to import and update asset data from common IT Asset tools such as Microsoft SCCM, Lansweeper, Cetero and many others ([https://github.com/hornbill/goDBAssetImport Source Code])
+* [[Asset_Data_Import_Tool|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
-* [[CSV_Asset_Import|CSV Asset Import Tool]] - DEPRECATED Used to import and update asset data from csv files ([https://github.com/hornbill/goCSVAssetImport Source Code])
+** [[Importing_Assets_From_Supportworks|See this page if importing asset data from Supportworks]]
-* [[Snow_License_Manager_Cloud_Asset_Import|Snow License Manager Cloud Asset Import]] - Used to import and update asset data from Snow License Manager in the Cloud ([https://github.com/hornbill/goSnowCloudAssetImport/ Source Code])
+* [[CSV_Asset_Import|CSV Asset Import Tool]] - DEPRECATED Used to import and update asset data from csv files
-* [[Database_Asset_Relationship_Import|Asset Relationship Import Tool]] - Used to import and update asset relationship data from an external data source ([https://github.com/hornbill/goDBAssetRelationships Source Code])
+* [[Snow_License_Manager_Cloud_Asset_Import|Snow License Manager Cloud Asset Import]] - Used to import and update asset data from Snow License Manager in the Cloud
-* [[Meridian_Import|Hornbill Meridian Asset Tag Import]] - Used to Hornbill asset records with Aruba Meridian hardware asset tag information ([https://github.com/hornbill/goHornbillMeridianTagImport Source Code])
+* [[Database_Asset_Relationship_Import|Asset Relationship Import Tool]] - Used to import and update asset relationship data from an external data source
+* [[Meridian_Import|Hornbill Meridian Asset Tag Import]] - Used to Hornbill asset records with Aruba Meridian hardware asset tag information
+===Other===
+* [[Hornbill_Role_Finder|Role Finder]] - Used to find roles on an instance for a given right.
+* [[Google_Forms|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==
@@ Line 69: / Line 75: @@
 * [[Request Attachment Archiver]] - This utility allows for the archiving of file attachments to Hornbill Service Manager Requests. ([https://github.com/hornbill/goRequestAttachmentArchiver Source Code])
 * [[Email Archiver]] - This utility allows for the archiving of emails from within Hornbill. ([https://github.com/hornbill/goEmailArchiver Source Code])
-* [[User Role Removal Utility]] - This utility allows for the removal of ALL roles for a list of users (given in CSV file). ([https://github.com/hornbill/goHUserRoleRemover Source Code])
 ===Miscellany===