sign in


 

Data Sheet

 

Success Stories

Experience Our
SQL Server Integration Solution Demo!


Contact Us Now
1-866-763-KORE

 

Kourier Integrator for U2


Detailed Features Listing

This is a detailed list of the product features in Kourier Integrator and SQL Accelerator as of Release 2.2.6.
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. 


  Home  | About Kore  |  Kore News  |  Products  |  Services  |  DataFlo  |  Contact Us  |  Careers Facebook

Copyright © 2010 Kore Technologies. All rights reserved.
Call 1-866-700-KORE (5673)   E-Mail
Legal Disclaimer