|

|
Data Sheet |
|
Success Stories |
Experience Our
SQL Server Integration Solution Demo!

Contact Us Now
1-866-763-KORE |

|
Kourier Integrator
Business-to-Business Connectivity and Best-in-Class
MultiValue Integration Solution
Kourier
Integrator can help you extend the value and functionality of your
MultiValue enterprise application through business-to-business connectivity
and best-in-class MultiValue product integration. More and more companies
are implementing stand-alone software applications and enterprise data
warehouses to supplement their MultiValue application and improve specific
areas of the business. With Kourier Integrator these applications can
function as though they were an integral part of your MultiValue
application, ensuring data consistency while eliminating costly and
redundant data entry. Kourier Integrator was written specifically for the
UniData/UniVerse (U2) extended relational databases (from Rocket
Software), and makes MultiValue integration very easy. With Kourier
Integrator, your MultiValue application will be able to connect and exchange
data with virtually any computer and database available.
|

Kourier Integrator Release 3 is available, read
the announcement. To
read about the new features and enhancements in
Release 3
click here.
Before you spend a fortune implementing a new enterprise
application with the latest and greatest technology, let
us show you how you can breathe new life into your
current enterprise application for a fraction of the
cost.
|
|
Key Benefits
- Near real time data updates using Kore's
Net Change
- Quickly build SQL data warehouse from a
U2 database
- Guaranteed data delivery
- Automates integration to MS SQL Server
- Simplifies data exchange with other
databases
- Easy to learn and use, thin client Web
Interface
- No metadata to setup, no programming
required
- Minimal overhead and impact on U2
application
- No additional U2 licenses to purchase
- Compatible with virtually any U2
Application
- Does not require application changes
- Rapid implementation cycle
Key Features
- Net Change tracking and Full Refresh
database updates
- Data warehouse Quick Start Workbench
- Template-based, dictionary-driven export
specifications
- Normalizes MultiValue and SubValue data
automatically
- Data aggregation from multiple U2
accounts
- Related Files are easily managed with
one export specification
- Fast data extraction uses native access
(not ODBC)
- File compression and extraction during
ftp transfers
- Generate maintenance-free SSIS SQL
Packages
- Supports SQL Server 2000, 2005, and 2008
- Supports 64-bit SQL and Windows
environments
- Unified scheduling streamlines U2 to SQL
updates
- Message-based architecture guarantees
data delivery
- Integrated testing workbench expedites
export design
- Data export/import auditing and
statistics logs
- Independent scheduling agent
- User-defined formulas for data export
fields
- 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
- Multiple export formats and transport
protocols
- Net Change supports distributed files on
UniVerse
- Quick Start tools accelerate
implementation
- See
detailed feature list for more
information
|
Example of Kourier Integrator Export
Specification

|
U2 Application Compatibility
|
Kore has used Kourier Integrator to
implement Microsoft SQL Server data
warehouse, business intelligence, and
other integrated solutions for Clients
using homegrown, bespoke, and commercial
U2 applications such as these:
 |
Activant Prelude and
Eclipse |
 |
Campana AXIS |
 |
Comcast-Spectacor
Paciolan |
 |
Datatel Colleague |
 |
Epicor Avanté,
DataFlo and Manage2000 |
 |
IDS Astra |
 |
Jenkon Summit V
|
 |
P2 Energy Solutions
Excalibur |
 |
RBS RATEX |
 |
Rescot Systems |
 |
Software21 FlexGen4 |
 |
Wellpoint Systems
BOLO |
 |
and others... |
|
Please call us to learn more
about Kourier Integrator and SQL
Accelerator.
|
|
Predefined Operational Data Stores
|
Predefined Operational Data Store (ODS)
solutions provide the fastest way to get
started with data warehousing for the U2
applications listed below. These ODS
solutions are ready to use and include
everything needed to create and maintain
a SQL Server data warehouse. Each ODS is
customizable to meet your needs.
 |
Activant Eclipse |
 |
Activant Prelude
|
 |
Comcast-Spectacor
Paciolan |
 |
Datatel Colleague |
|
Contact Kore for updates or for more
information
|
|
|
|
|
Microsoft SQL
Server Integration
SQL Accelerator (an optional component for
Kourier Integrator) provides seamless integration
between UniData/UniVerse and
Microsoft's SQL Server database. Ideal for
application integration or building a full-blown data
warehouse, SQL Accelerator is the key component for
connecting MultiValue and MS SQL Server databases
because it automatically generates the SQL Server
Integration Services (SSIS) packages that enable the
seamless integration between the two databases. Note, if
you are interested using Data Transformation Services
(DTS), you can use the stand-alone version
SQL Accelerator.

Kourier Integrator
with
SQL Accelerator is the fast track for U2 to SQL
integration
The maintenance-free packages follow Microsoft best
practices and include everything to update the database
which includes: automatically mapping U2 dictionaries to SQL
Server columns, insert-update-delete logic, managing
database rule validation and exception handling, sending
e-mail notifications, and more.

It only
takes a few clicks to Generate SSIS Packages
Near real-time SQL database updates can be attained using
Kourier Integrator’s and SQL Accelerator’s “Net Change”
technology and scheduling agents, which monitor changes to
the MultiValue database and then optimize SQL Server
database updates to provide high performance and scalability
with guaranteed data delivery. |
|
|
Eliminate Islands of Automation
Using Kourier Integrator, you can remove “islands of
automation” resulting from non-integrated or loosely
integrated applications. Kourier Integrator allows your
MultiValue application to connect and exchange data with
many popular applications such as:
- Microsoft SQL Server Data Warehouse
- e-Commerce Web Storefronts
- Decision Support and Business
Intelligence
- Information and Marketplace Portals
- Sales Force Automation
- Customer Relationship Management
- Advanced Production Scheduling
- Help Desk and Customer Support
- Factory Data Collection
- Electronic Data Interchange
- Product Data Management
- Product Lifecycle Management
- Other Enterprise applications
|
|
|
|
Enterprise Design
The integration model used by Kourier Integrator and
SQL Accelerator has successfully moved millions and
millions of transactions and it has proven to be a very
reliable and effective integration method. There are
many other advantages to this method compared to a
stand-alone MultiValue data warehouse or direct
MultiValue database connect model (e.g., ODBC):
- Security
- Performance
- Flexibility and Extensibility
- Scalability
- Independent Operation
|
|
|
|
Kourier Express Solution
Kourier Integrator Express solutions have a
rapid and guaranteed implementation.
Using our Quick Start tools, you can have a
data warehouse or other integration project up
and running in as little as one week!
The solution pricing includes all the software
and services needed for a complete data
integration solution, and we’ll even help you
with your first project. Note that Kourier
Integrator solutions are installed on your U2
application server and Web server and must meet
certain minimum
requirements.
MultiValue integration solutions that breathe new life
into your enterprise applications.
Contact Kore Technologies and
let us know how we can serve you!
 |
|