Difference between revisions of "Hornbill Open Integration Tools"

Revision as of 15:25, 5 January 2022

Home > Integration > Hornbill Open Integration Tools

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.

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 (Source Code)
SQL User Import Tool - Used for one-off or scheduled imports of user data into your Hornbill instance (Source Code)
Azure User Import Tool - Used for one-off or scheduled imports of user data into your Hornbill instance (Source Code)

Contact Import

SQL Contact Import Tool - Used for one-off or scheduled imports of contact data into your Hornbill instance (Source Code)

Document Import

Document Import Tool - Used for one-off or scheduled imports of documents into Document Manager on your Hornbill instance (Source Code)

Organisation Import

SQL Organisation Import Tool - Used for one-off or scheduled imports of organisation data into your Hornbill instance (Source Code)

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 (Source Code)
ServiceNow Request Data Migration Tool - Used to migrate historic and active call/ticket/request data from ServiceNow to Hornbill Service Manager (Source Code)
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 (Source Code)

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 (Source Code)
CSV Asset Import Tool - DEPRECATED Used to import and update asset data from csv files (Source Code)
Snow License Manager Cloud Asset Import - Used to import and update asset data from Snow License Manager in the Cloud (Source Code)
Asset Relationship Import Tool - Used to import and update asset relationship data from an external data source (Source Code)
Hornbill Meridian Asset Tag Import - Used to Hornbill asset records with Aruba Meridian hardware asset tag information (Source Code)

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)
User Role Removal Utility - This utility allows for the removal of ALL roles for a list of users (given in CSV file). (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 23: / Line 23: @@
 [https://github.com/hornbill/ Hornbill GitHub Repository]
-===Utilities===
+==Import Utilities==
-* [[Hornbill_Clean_Utility|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 ([https://github.com/hornbill/goHornbillCleaner Source Code])
-* [[Hornbill_Report_Runner|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 ([https://github.com/hornbill/goHornbillReportRunner Source Code])
-* [[Hornbill_Data_Export|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 ([https://github.com/hornbill/goHornbillDataExport Source Code])
-* [[API_Scheduler|Hornbill API Scheduler]] - The utility provides a quick and easy way to schedule the running of Hornbill API’s ([https://github.com/hornbill/goApiScheduler Source Code])
-* [[Simple List Import Utility]] - This utility allows for the population of Simple Lists which can thus be a scheduled activity. ([https://github.com/hornbill/goSimpleListImport Source Code])
-* [[Task Cancelation Utility]] - This utility allows for the removal of Hornbill Tasks. ([https://github.com/hornbill/goHornbillTaskCanceller Source Code])
 ===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])
@@ Line 36: / Line 29: @@
 * [[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])
-===Contact Import ===
+===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])
@@ Line 52: / Line 45: @@
 ===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])
-* [[CSV_Asset_Import|CSV Asset Import Tool]] - Used to import and update asset data from csv files ([https://github.com/hornbill/goCSVAssetImport Source Code])
+* [[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])
 * [[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])
 * [[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])
 * [[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])
-===Power BI Reporting ===
+==Orchestration and Automation==
-* [[PowerBI_Reporting|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 ([https://github.com/hornbill/rPowerBIHornbillDataSources R Scripts] and [https://github.com/hornbill/pythonPowerBIHornbillDataSources Python Scripts])
+* [[HP_Operations_Orchestration_Integration|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|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_OMS_Integration|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==
+* [[Teams_Power_Virtual_Agent|Hornbill Power Virtual Agent]] - A Power Virtual Agent (chatbot) that runs in MIcrosoft Teams and/or other chatbot channels ([https://github.com/hornbill/hornbillPowerVirtualAgent Solution])
+==Utilities==
+===Data Extraction===
+* '''[[PowerBI_Reporting|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 ([https://github.com/hornbill/rPowerBIHornbillDataSources R Scripts] and [https://github.com/hornbill/pythonPowerBIHornbillDataSources Python Scripts])
+* [[Hornbill_Report_Runner|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 ([https://github.com/hornbill/goHornbillReportRunner Source Code])
+* [[Hornbill_Data_Export|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 ([https://github.com/hornbill/goHornbillDataExport Source Code])
+===Data Removal===
+* [[Hornbill_Clean_Utility|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 ([https://github.com/hornbill/goHornbillCleaner 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])
+* [[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===
+* [[API_Scheduler|Hornbill API Scheduler]] - The utility provides a quick and easy way to schedule the running of Hornbill API’s ([https://github.com/hornbill/goApiScheduler Source Code])
+* [[Simple List Import Utility]] - This utility allows for the population of Simple Lists which can thus be a scheduled activity. ([https://github.com/hornbill/goSimpleListImport Source Code])
+* [[Task Cancelation Utility]] - This utility allows for the removal of Hornbill Tasks. ([https://github.com/hornbill/goHornbillTaskCanceller Source Code])
+* [[Service Translation Tool]] - This utility allows for the bulk translation of Hornbill Service Manager Services and associated records. ([https://github.com/hornbill/goHornbillTranslateServices Source Code])
-===Orchestration and Automation===
-* '''[[HP_Operations_Orchestration_Integration|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|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_OMS_Integration|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.
 [[Category:Integration]]