A data management tool
for the rest of us

A data management tool for the rest of us

Get started

about

InfoLite is a simple, all-encompassing data management solution that is built for business users with limited or no technical background. It is designed to be at the epicentre of any organization’s data, enabling non-technical end-users to support data management and data governance with simplicity and speed.

InfoLite provides an easy-to-navigate self-service capability to enable business end-users to load, manage, and publish data easily and quickly. Its user-centric architecture and design streamlines data management, providing out-of-the-box data dictionary and data governance features for common naming and standardization across multiple data sources.

Key features

Load Data

Allows a user to easily load file-based datasets (Excel, CSV, JSON, or Web API data) or existing database data into a new or existing database table.

Scheduling

Allows a user to schedule job sequences to run at predetermined times.

Publishing

Allows a user to publish data to an API endpoint using REST.

Manage Data

Allows a user to access and manage existing data in a database using a simple web-based grid interface.

Data Dictionary

Allows a user to easily define and maintain information describing the contents, format, and structure of a database table and its columns.

Glossaries

Allows a user to create technical or business glossaries to help with improving consistency and use of terms across an organization.

Reference Data

Allows a user to easily define, maintain and control reference data centrally in a structured and governed manner, while preserving change history.

Data Sources

Current support includes: CSV, MS Excel, API, JSON, Oracle, MS SQL Server, MySQL

Portability

Scripts and data can be downloaded for offline use with a simple click.

FAQs

InfoLite is currently a beta product and is available for free.

InfoLite is a web-based Softwares as a Service (SaaS) product, therefore access to the product is granted after completing the simple sign-up process. Click on the Sign Up button at the top of this page to get started.

Yes, InfoLite currently supports the use of advanced job tasks, allowing compliant database scripting to be used. For example, you can create an advanced query to source data, or can write a specific query to update a table based on custom filters.

The current version of the product allows connections to be made to SQL Server, Oracle, and MySQL. As long as your server is accessible over the Internet, it can be seen and accessed by InfoLite. If you have trouble connecting to your database, check to ensure that the necessary inbound ports are accessible from the public Internet.For increased security, it is recommended that your database server only accept connections from specific services such as InfoLite.

Most tools are tailored for technical IT type users, requiring an understanding of various scripting and/or programming languages. InfoLite is designed for business users with limited or no technical background, making it easy to perform tasks such as loading Excel data into a database table, updating a master reference table, or maintaining an organizational data glossary.

InfoLite was architected and designed with security in mind. All communication to and from the service is encrypted. All connections to a database are private and objects created are only visible to you, the user. If you are part of a company, you can optionally share objects you create with other people in your company.

The data dictionary feature is a type of glossary that allows common business terms to be defined and maintained. It also connects the data dictionary to technical artifacts in a database system and provides some form of lineage to the original source data. This feature is highly secure and can be configured for individuals or entire organizations with varying levels of privileges in line with desired governance.

This feature allows any non-technical user to manage something called Reference Data, which is organizational data that is centralized. For example, an organization should only have one definition and list of the employees - using this feature/tool, they can manage the employee list in a structured and governed manner, restricting the types of changes to data and how much history is preserved. History can be configured using industry standard Type 1, Type 2, and Type 3 slowly changing dimensions (SCD), depending on your needs.