Print    Email  Retweet  Share  Share 

 Feature Story

Data Profiling in SQL Server

By Oscar Li, Data Quality Sales Engineer/Channel Manager
Data Quality Insider - Feature Story

Melissa Data is proud to introduce our new Profiler component in Data Quality Components for SQL Server Integration Services (SSIS). The addition of this new Profiler component allows users to quickly profile their data set for analysis in an easy-to-use GUI-based ETL environment.

Simply map in the columns that you want to be profiled and set the options for profiling. The Profiler component will output different types of data analysis and also output a complete PRF file which can be analyzed in a SQL-Lite browser.

Here is a preview of the interface for the new Profiler component for SSIS.

Input tab:

<screenshot of Profiler's Input tab

Analysis options tab:

<screenshot of Profiler's Analysis options tab

Output settings tab:

<screenshot of Profiler's Output settings tab

Sample SQL-Lite Analysis DB Generated by Profiler Component:

<screenshot of a Sample SQL-Lite Analysis DB Generated by Profiler Component



Melissa Data Corporation BBB Business Review

Melissa Data SOC 2 Type 1

Melissa Data Google+ Melissa Data Facebook Melissa Data is on Twitter  The Data Quality Authority Blog  Melissa Data LinkedIn  Melissa Data - YouTube

Data Quality
Cloud Services
Reference Data

Direct Mail
Mailing Lists
Mailing Products
Cloud Services
Popular Services
Data Enhancements
Data Hygiene

Data Quality Authority
Direct Marketing Authority

Customer and Events
Read Customer Stories
Press Releases
Training & Certification
Become a Partner

Contact Us |  Partners |  Site Map |  Privacy |  Trademarks |  Terms of use

© Copyright 2018 by Melissa DATA Corp. All trademarks are used as property of their owners.

Melissa Data
The leading international provider of data quality and address verification software. Melissa Data's affordable, easy-to-use solutions for data cleaning and deduplication can be used separately or together to provide full global data quality. Melissa Data specializes in Microsoft .NET and SQL Server Integration Services, IBM, Java and Oracle environments with APIs, Web services and enterprise plugins that empower batch and real-time applications. Melissa Data also provides a full line of direct marketing solutions including mailing software, list hygiene and data append services, and a comprehensive line of mailing lists and sales leads.