Pamlico ETL (Extract, Transformation & Load)

Pamlico ETL is an extract, transformation and load solution based on SQL Server Integration Services for implementing robust, enterprise-class ETL processes while supporting the auditing, control, and reporting required for the ongoing care and maintenance of ETL  ETL often accounts for 70-80% of the data warehouse development effort. Pamlico ETL reduces the construction effort for the ETL process by 25-50% through standard patterns for common DW scenarios, automated tools for producing standard code, and components that simplify complex scenarios.  Specific benefits include:

Streamline Development

• Control flow tasks for tracking ETL progress and metrics for data movement

• Data flow components for logging data-related errors and handling business rules

• Templates for common ETL scenarios (data extraction, transformation for slowly changing dimensions, transactional and periodic fact tables)

• Generation tools for building packages based on existing databases and common extract and load needs

Enhanced Monitoring and Reporting

• Metadata and log information extraction from SSIS packages and ETL processes

• Populated reporting database, canned reports and OLAP cubes for easier ETL reporting and analyses

• Web-based console for monitoring ETL processes

• Impact Analysis to determine affected packages when source and target systems change

Ease of Administration

• Web-based console interface for common maintenance tasks (error checking, executing one-off ETL runs, etc.)

• Installation wizards for quickly and easily installing developer and server component

For more info email pamlico@mariner-usa.com