Data Discovery

Source Data is sometimes hard to understand. Halo Source makes this process easy with its Data Discovery Features.

Here is an overview on some of these Features:

In a real wold System you often have literally hundreds of Fields with more or less meaningless names. The integrated Data Profiling allows you to sneak peek into your data and shows you for every field

  • if it is populated
  • the percentage of empy values
  • how many Differnt Values you have
  • The Top 5 ,Bottom 5  Values and the most common 5 Values

this makes it much easier to identify the right column. You literally see the values you are looking for immediately.

To get a deeper understanding of your Data you can see Data distribution  (how often every value occurs). Gaps and Island Analysis is also available to show you if you have gaps in your Invoice Numbers.

To make sure your data looks as you expect it you can do a Pattern analysis showing you how digits, characters and Special characters are distributed.

You can store all profiling results in a database and monitor changes over time. This way you can easily identify unexpected Values and other Data Issues. Data Quality can be monitored over time. Halo Source keeps track about every field you used in the whole Data Transformation process. In the Global Table / Field Search you can identify every reference to a specific Field.
Here you see the global search showing all references to a Customer Code. No matter if it’s used in the Extract or a transformation – all of them are immediately accessible.

This makes it easy to see if you already extracted the needed information from the source system. If this information is available in your Source System, Halo Source can identidy how to link tables and allow you to add referenced Tables to your Project.

Data Integration:Saving 90%-95% Time and Effort

Save 90%-95% time and Effort in Data Integration

We developed Halo Source to speed up development of Data Integration Solutions. We make maintenance as simple as possible.

In a Real World Projects a lot can go wrong.  Unexpected source system changes can cause weeks of work fixing the Data Integration. Employees who know all the details leave the company and nobody knows how to maintain their projects. Often there is no (or outdated) documentation. Requirements are often specified only on a very high level.

Halo Source addresses all of these issues. It reduces the the complexity of Data Integration Projects. Halo Source is accessible for non experts users. It empowers your team to work with agile methods.

This literally saves 90% time and effort and more compared to native Database Tools.

Here are some Areas where Halo Source helps a lot:

  • Difficult Data discovery
  • Source System changes
  • People who designed Data Integration left the Company
  • Special Skills needed to Maintain Data Integration
  • Lack of Documentation
  • Limited Expert Availability
  • Changing Requirements
  • Incomplete Requirements

How we save Time and Effort in Detail