Integration

Overview

xAssets solutions include powerful middleware enabling connection into any other application, file or database. It works with cloud services and with on-premise systems. Simple integrations can be assembled and tested in minutes. Complex integrations which include data cleansing, data recognition, multiple data sources and specialised business rules can be usually developed within a few hours to a few days.

"Out of the box" integrations

All solutions include pre-built integrations to the following software:

Data flows from the integrations, to your xAssets Instance, and then to user reporting and apps which consume asset-centric data.

In addition we have pre-developed integrations to common enterprise systems that can be copied into any implementation if required.

Date Sources and Destinations

All xAssets Implementations include one of the most powerful integration toolsets available. Data can be passed from one data source to another. Data Sources include:

• OLEDB and ODBC Databases
• CSV, Tab Separated, Fixed Width and XML Files
• Sql Server Tables
• Active Directory, Azure, Intune, JAMF, JIRA, Meraki, SCCM and other Applications
• Web Services and Files Published on Web Sites
• xAssets Data Tables and Sql Statements
• Queries
• Scripts which Generate Data
• Programs written by the customers developers

Data Destinations include:

• OLEDB and ODBC Databases
• CSV, Tab Separated, Fixed Width and XML Files
• Sql Server Tables
• Active Directory, Intune / SCCM and other Applications
• Web Services and Files Published on Web Sites
• xAssets Data Tables
• Reports
• Emails and Mail Merges

Each transformation run by the integration toolset can specify a mapping between the source data and the target data.

The transformation engine also incorporates its own scripting language called AMSX. This powerful language allows configuration of complex data manipulation and data communication scenarios including:

• Data Recognition
• Data Communication using HTTPGET and HTTPPOST
• Manipulation of in-memory buffers for String data and XML Data
• User written scripts
• Generation of PDF, HTM, CSV and XLS reports and emails
• Execution of further scripts

Configuration Options

Learn more about the functions and features available within our IT Asset Management, and Fixed Asset Management solutions