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
Products
Cloud Services
Plugins
Reference Data
Solutions
Technologies

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

Communities
Data Quality Authority
Direct Marketing Authority
MVPs


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


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

© Copyright 2017 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.