Kourier Integrator for U2

Detailed Features Listing

General Product Features

Easy-to-use Web-based interface Net Change and Full Refresh database updates Provides Extract, Transform, Load (ETL) capabilities Provides Enterprise Application Integration (EAI) capabilities Quick Start Workbench accelerates SQL data warehouse implementation Integrated development environment for SQL Server projects Data aggregation from multiple U2 accounts Fast data extraction uses native database access (not ODBC) Option to use file compression and extraction when using ftp data transfers Message-based architecture guarantees data delivery Data Export and Import Statistics Tracked to Support Data Reconciliation Unified scheduling streamlines U2 to SQL updates with a single scheduled process Independent scheduling agent Extensive event logging and audit files Event-based notification and exception management User-defined e-mail notification templates Dynamic data via powerful Substitution Processor Integration properties, lookup tables, and system literals Supports International date formats according to localized settings Custom code interface XML-based transaction import Extensive online user guide Supports 64-bit SQL Server and Windows environments

Net Change Features

Near real time integration via Net Change Uses Kore's proprietary change data capture technology Automatically tracks all changes to a U2 file-- regardless of update method Implemented at the U2 database level for speed and efficiency Does not require changes to the host U2 application Compatible with existing triggers or indexes Negligible performance impact on host U2 application Provides ability to deal with very large data sets Multiple Net Change modes available: Standard Net Change Net Change with Checksum Net Change with Deletes Supports UniData dynamic Files Supports UniVerse distributed files Automatic setup and activation API for programmatic implementation Administrator analysis and auditing tools

Data Warehouse Quick Start Workbench

Easy-to-use user interface encapsulates all the tools and tasks necessary for building a SQL Server data warehouse Accelerates the process of creating a Microsoft SQL data warehouse from a U2 database from start to finish Analyze files, review data profiling information, and revise file schema File analyzer and data profiling tool compares U2 file data to defined data structure Generates Schema information highlighting data / structure inconsistencies or omissions: Data types and lengths MultiValue type (single or multi-value) Multi-value associations Provides ability to view and edit schema information Generate all Export Specifications. Services, SQL DDL, and SSIS loading packages to create a normalized SQL data warehouse Configuration options provide customization and dynamic character and word substitution Export and Import "suitcase" files containing integration information

Data Export Specification Features

Template-based export specification design Manage exports from multiple "related files" (e.g., comma files) with only one export Use existing dictionaries or reference attribute position Normalizes multi-value and sub-value data automatically Integrated testing workbench expedites export design Select sample number of records or specific item-ids to process Displays all data after processing all conversion, formulas, substitutions, etc. Option to display data in native format, showing all delimiters (i.e., multi-value, sub-value) User-defined formulas for data export fields use BASIC syntax and commands Many additional U2 data conversion extensions (e.g., date and number formatting) User comments for each data export field Multiple export formats (XML, Tab-delimited, fixed length, HTML, Pipe, ASCII, Tilde, CSV) Multiple Transport Protocols Available: FTP, FTPS HTTP Get, HTTP Post, HTTPS Get, HTTPS Post, SMTP OS File in Directory RDBMS Data File Socket Save As feature to quickly create new export specifications from existing export specifications Select filter provides ability to limit data processed Supports using a different dictionary than primary data file (Using File) Maintains runtime statistics for each export (export mode, elapsed time, number of rows, number of records, number of bytes)

SQL Accelerator Features

Integrated with Kourier Integrator Web Interface Supports MS SQL Server 2000, 2005, and 2008 Build SSIS packages while creating the Data Export Specification Automatic creation of SQL DDL for all data exports Creates maintenance-free SSIS packages Creates maintenance-free DTS packages (stand-alone version only, for SQL 2000) Quickly Generate all SSIS packages for an integration, selected data files, or a specific service Generated packages use data export specification to determine primary keys, column name, types, etc. Automatically run SSIS data loading packages immediately after data extraction Run interdependent SSIS packages asynchronously or synchronously Packages support multiple SQL database update methods: Full Refresh, Net Change, Net Change with Deletes Packages support SQL table names with Schema designations Save packages to SQL Server repository or the file system SQL database updates support Windows or SQL Server authentication User editable package configuration files E-mail notification for import exceptions Data Import and run time statistics recorded for each SSIS Package and SQL table processed (the number of rows imported, number of errors) Configurable error thresholds Detailed SSIS processing and error logs assist with error diagnosis Recurring schedule using SQL Server agent

Other product names used herein may be trademarks or registered trademarks of their respective owners.