provided the same exceptional value as Datiris."
We purchased Datiris as a profiling tool for the ongoing development work
in the creation of our Data Warehouse. Profiling is now considered a very
important component of any Data Warehousing methodology, and it certainly
assists us by shortening the development process.
Understanding the very nature and structure of the data originating in
source systems helps to avoid working on assumptions and costly re-development
at a later stage. Even if you're doing profiling manually, as we used
to do, Datiris can greatly reduce the amount of work and time required.
We investigated some other data profiling tools (including the one provided
by our current ETL vendor), but none provided the same exceptional value
Data Warehouse Manager
Educational Institution (University)
"Datiris Profiler has brought peace of mind to our clients..."
We are using Datiris Profiler to help manage our data conversion projects.
The tool provides straightforward results at the fraction of the cost
of well-known data profiling tools. In conversion projects when you are
dealing with million of rows and thousands of attributes to convert, discovering
and managing data cleansing continues to be the challenge. The tool provides
you with a simple but highly effective way that you can walk through data
cleansing issues with your client while drilling down on their real data.
These issues can then be tracked through resolution by using the "tags"
feature of the tool.
Datiris Profiler has brought peace of mind to our clients because they
finally have a product that is easy to use that gives them the ability
to pull back the covers and see the true state and quality of their data.
Gibbons St. Paul
Major Management & Technology Consulting Firm
"The whole analysis process went a lot faster..."
We are using Datiris Profiler as an aid during data loads. We load a client's
data into an Oracle schema and then run Datiris Profiler against that
schema. We found that by using the information in the profiles during
data analysis sessions with the client we were able to identify many things
about the data, such as:
• Is a field consistently null?
• Does the field have malformed or "dirty" data, e.g.
short telephone numbers, SSNs with alphas, etc.?
• What type of data is in the field? This was my favorite. There
were many times during out data analysis portion that the client thought
a certain field held a certain kind of data, but the tool demonstrated
that there was a completely different sort of data in that field.
The whole analysis process went a lot faster because we were able to quickly
step through each of Datiris Profiler's screens to show them either the
format or the specific data for each field. The plan is to continue use
Datiris Profiler throughout the development of the data load routines
to make sure nothing slips into the client data that we don't expect.
Earl D. Culpepper, II
"...start the process of sorting out sticky data integrity issues
as soon as possible."
Each time we bring a new client on board, we essentially load all their
historical customer, product and transaction data onto our platform. Datiris
Profiler allows us to quickly get some basic information about the data
we receive, share that with the clients' IT people, and head off any problems
with missing data or unexpected values before the development process
This is where metadata and actual data collide! Invariably, what they
think they are sending us, and what they have actually sent us do not
match up. Datiris Profiler lets us figure this out pretty quickly and
start the process of sorting out sticky data integrity issues as soon
Services Integration Director