Pitney Bowes: Group 1 Sagent Data Flow Solutions

Group 1 Sagent Data Flow Solution Engineering the flow of communication Preface The following overview of Sagent Data Flow Solution was compiled to help evaluate ETL (Extraction, Transformation, Loading) efforts. The document is categorized in various areas that should help you within your evaluation process and to address your ETL requirements. Sagent Data Flow Solution is an integrated high-performance environment that provides tools for extracting information from multiple sources, optimizing information for decision support and delivering it to users in formats that meet their business needs. With the Sagent Data Flow Solution, user access is provided over the Web as well as through client applications. In summary, Sagent Data Flow Solution offers: · A pipelined, parallel architecture for scalability and performance · Native connectivity to most relational and flat file sources/targets · One, graphical look-and-feel for ease-of-use · A unified approach for rapid development · An advanced, extensible library of data transformation objects · An integrated, dependency-based scheduling engine · An open, relational metadata repository · A single point of administration for multiple servers, repositories, and clients 01 Group 1 Software, Group 1 Sagent Data Flow ETL Solution, 2007 Table of Content About Data Warehouses and Data Marts ..............................................3 Programming Features ..................................................................................20 Data Mart Population ..........................................................................................3 Sagent Software Developer’s Kit (SDK) ..................................................20 VBScript ......................................................................................................................20 About the Sagent Data Flow Solution ....................................................4 Extract, Transform and Load ..........................................................................4 Sagent Admin Details .................................................................................... 21 Graphical Design Tools ........................................................................................4 Managing Repositories ....................................................................................21 Pipeline Processing .............................................................................................. 4 Monitoring Object Properties ......................................................................21 Many Data Formats Supported ......................................................................4 Managing Sagent Servers and Services ....................................................22 An End-To-End Solution .................................................................................. 5 Managing Users and Security ..........................................................................22 Sagent Solution Modules & Overview .................................................... 6 Sagent Automation Details ........................................................................ 23 Sagent Data Flow Server ....................................................................................7 Advanced Plan Scheduling............................................................................23 Database Connectivity and Support ..........................................................7 Dependency Scenarios .................................................................................... 23 Sagent Design Studio .......................................................................................... 8 Service and File System Integration ...................................................... 23 Sagent Admin ............................................................................................................9 Sagent Automation ............................................................................................10 Sagent Reports ....................................................................................................24 Sagent WebLink ....................................................................................................11 Accelerated Enterprise Reporting ............................................................ 24 Sagent Information Studio............................................................................11 Columnar and Form Reports ...................................................................... 24 Sagent Reports ......................................................................................................12 Multi-level Grouping ........................................................................................24 Sagent Analysis .................................................................................................... 13 Export results to HTML, Delimited Text File format or PDF .... 25 Web Browser Support ......................................................................................25 Data Flow Plans and Transforms ............................................................14 Central Administration ....................................................................................25 Financial Reports ................................................................................................25 Sagent Data Flow Solution Repository ................................................16 Sharing and Distributing Plans ..................................................................16 Overview of Sagent Analysis ......................................................................26 Aggregate Navigation ........................................................................................16 Crosstabs ....................................................................................................................26 BaseViews ................................................................................................................ 17 Charting ......................................................................................................................26 MetaViews ................................................................................................................17 Pivoting, Drilling Down and Rolling Up ..............................................26 MetaLens....................................................................................................................18 Central Administration ....................................................................................26 Analysis Concepts ................................................................................................26 High-performance Architecture ..............................................................19 Multithreaded ........................................................................................................19 SQL Optimization and Extensibility ........................................................19 Scheduling................................................................................................................19 Caching ...................................................................................................................... 19 Search Engine ........................................................................................................19 02 Group 1 Software, Group 1 Sagent Data Flow ETL Solution, 2007 About Data Warehouses and Data Marts Corporate data is entered and collected in operational Data Mart Population databases using a method known as online transaction Whether your company has implemented a data warehouse processing (OLTP). OLTP databases are optimized for inserting, or is gathering information from diverse sources, the Sagent updating and deleting records, but not for complex, ad hoc Data Flow Solution provides the tools you need to move queries.