Kourier Integrator for U2

Detailed Features Listing

General Product Features

Easy-to-use Web-based interface Provides Extract, Transform, Load (ETL) capabilities Provides Enterprise Application Integration (EAI) capabilities Integrated development environment for SQL Server projects Full Refresh and Net Change database updates Data aggregation from multiple U2 accounts Fast data extraction uses native database access (not ODBC) Message-based architecture guarantees data delivery Data Export and Import Statistics Tracked to Support Data Reconciliation 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 Quick Start tools accelerate implementation Custom code interface XML-based transaction import Extensive online user guide

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)

Net Change Features

Net Change enables near real time integration Automatically tracks all changes to a U2 file-- regardless of update method Implemented at operating system level for speed and efficiency Does not require changes to 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

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 or selected data exports Generated packages use data export specification to determine primary keys, column name, types, etc. 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

Quick Start / Developer Tools

File analyzer 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 change schema information Generate Export Specifications and related Services from schema to create normalized SQL table structure Builds the SQL DDL for one or more data export specifications Export and Import "suitcase" files containing integration information

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