Integration Hub

A simple and powerful way to manage your data.

The Integration Hub is an online platform for extracting, processing and delivering data. Quickly connect to data stored in databases, text files, API's, run analytics and other transformations on the data, then deliver or visualize the results.

Why Information Hub?

Database Integration

Integration with virtually any data provider. Includes build in support for most popular Sql databases, NoSql databases, file types, and third party API's.

Data Security

You decide how and where to store your data. Whether secured on internal networks or published to the cloud, the integration hub will ensure you keep your data safe.

Analytics

Built into the platform are over 400 built in functions covering machine learning, financial, statistics, geometry. The platform also allows custom functions and functions for more specific needs.

Publish & Share

Easily publish and share your data, charts and dashboards with other users of the platform.

Scale from small to huge

Using intelligent remote agents, the central hub can manage huge data volumes without impacting the performance for other jobs.

Powerful Data Management

Data can be merged, transformed, cleaned, and profiled in many ways. Data can populate a data warehouse, integrate systems, or be published to users.

Features at a glance

Cloud
  • Single central metadata store
  • Physical data stored and accessed anywhere
  • Easy to scale
Sql Database Connectivity
  • Postgres (including Amazon Aurora)
  • Microsoft Sql Server
  • MySql
  • Oracle
  • DB2
  • IBM DB2
(NoSql) Databases Connectivity
  • MongoDB
  • Azure Storage Tables
File Types
  • Sqlite
  • Microsoft Excel
  • Delimited Files (such as CSV)
  • Json Files
  • Xml Files
File Connectivity
  • REST based API's
  • Local File Systems
  • FTP
  • SFTP
  • Azure Storage
Data Loading
  • Bulk Load (for speed)
  • Transactional Load (for data integrity)
  • Target based change detection
  • Source based change detection
  • Update target tables or preserve change history (Type 2 Slowly changing)
Transforms
  • Sql like transforms (map, filter, group, join, union)
  • Analytical aggregations (such as moving average)
  • Join flat tables to structured datasets (such as JSON)
  • Series transform to aggregate and even out time series.
  • Row generation transform to pivot data.
Functions
  • Hundreds of built in functions
  • Machine Learning - Regression, Sentiment, Recommendation, Clustering, Anomaly detection
  • Statistical - Curve fitting, Matrix, Distribution
  • Financial - Interest rate, Yield, Discount etc.
  • Live data - Weather, Stocks, Currency
Data Validation
  • Leverage any built in function
  • Custom reusable data validations
  • Validate via white lists or black lists
  • Validate against lookups (e.g. value exists in other table)
  • Invalid data can be rejected or stop processing
Data Profiling
  • Built in profiling functions
  • Data type profiling
  • Pattern profiling
  • Capture profile data with any data processing
Scheduling
  • Order data processing into dependency chains
  • Trigger based on schedule (once off or recurring)
  • Trigger based on file event
Views and Dashboards
  • Custom data views
  • Chart data (bar, pie, line, scatter etc.)
  • Trigger based on file event
  • User configurable dashboards which group views and charts into layout
Publishing & Sharing
  • Publish tables/views/dashboard for private/public groups
  • Create REST/JSON Api for external processes
Security Features
  • Strong encryption on passwords and marked sensitive fields.
  • Encryption keys decentralized (i.e. cannot be access by Data Experts staff)
  • Automatic SSL key generation to encrypt all data in transit
  • Local network isolation option which ensures data never leaves local network.
  • IP address whitelisting for remote processing agents.
Developers
  • Completely open source
  • Data connectivity plugin (through Microsoft .Net Core)
  • Function plugins (through Microsoft .Net Core)