Kourier Integrator Release 2.2.6 is available.  To read about the new features and enhancements in Release 2.x 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
• 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
• 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)
• Generate maintenance-free SSIS SQL Packages
• Supports SQL Server 2000, 2005, and 2008
• 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

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.

Maintaining a SQL data warehouse using Kourier Integrator for U2 and SQL Accelerator

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.

Example of Generate SSIS Packages Page

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!