The Easiest Way to Integrate with Microsoft SQL Server
Fast, Seamless and ScalableSQL Accelerator is the key component of Kourier Integrator that provides for fast, seamless and scalable integration between UniData/UniVerse (U2) plus other external data sources and Microsoft's SQL Server database.
SQL Accelerator is ideal for building data warehouses and business intelligence solutions from your U2 database and other data sources (e.g., operational data stores, data marts, decision support systems). SQL Accelerator can also be used for data integration with other Microsoft SQL Server applications. For example, it's very easy to load data used by a SQL-based CRM system with data extracted from a U2 database or another system.
Once the data is in SQL Server, you use any of the available powerful reporting tools that are available (including Excel and SQL Server Reporting Services (SSRS), PowerBI, etc.) for creating reports for decision support systems or creating rich graphical content for executive dashboards. By eliminating the manual creation and manipulation of SSIS packages, SQL Accelerator makes SQL Server-based capabilities a practical enhancement to your enterprise application environment.
Maintenance-Free SSIS PackagesSQL Accelerator saves you time and effort because it automatically generates the SQL Server Integration Services (SSIS) packages that enable the seamless integration between disparate databases and Microsoft SQL Server databases.
The maintenance-free packages follow Microsoft's best practices, are efficient and include everything to update the SQL Server database which includes: automatically mapping source file (table) fields (columns) to SQL Server columns, insert-update-delete logic, managing database rule validation and exception handling, sending email notifications, and more.
Package Execution Manager (PEM)
The PEM improves the overall performance, execution and transparency of Kourier generated Microsoft SSIS packages, and provides a stable and fault tolerant environment in which to run them. This ensures that all packages are run in a timely manner while minimizing overloading of system resources within the available constraints of the server.
Included with the PEM is the SSIS Package Queue which provides a dashboard summarizing the operational status (pending, running, completed and failed) of all SSIS packages by server and account. A drill-down into each category provides a detailed list of packages with individual performance metrics (submit time, start time, wait time, processing time, retries). This list can be filtered and sorted making it very easy to focus on specific data and one can also view the actual SSIS package output results to futher diagnose package run-time errors.
Near-Real Time SQL Database UpdatesTo be the most effective, your enterprise data warehouse or integrated solution must have the most accurate and up-to-date information that is available. SQL Accelerator provides near real-time SQL Server database updates using Kourier Integrator's and SQL Accelerator's "Net Change" technology and scheduling agents. You decide how frequently your data is updated and Kourier monitors changes to the source database, then optimizes SQL Server database updates via SSIS with only the data that has changed since the last update. This provides high performance and scalability with guaranteed data delivery.
Features and BenefitsSQL Accelerator has advanced features to support integration and enterprise data warehousing requirements. SQL Accelerator is an optional component for Kourier Integrator and supports Microsoft SQL Server databases (2012, 2014, 2016, 2017 and 2019. Currently supported non-U2 data sources include: Oracle, MySQL, Microsoft Access, Microsoft SQL Server, Apache Derby, PostgreSQL, MariaDB, Microsoft Excel and text files.
- Integrated with Kourier Integrator Web interface
- Generates efficient, maintenance-free SSIS packages
- SSIS Packages follow Microsoft's best practices
- Supports full refresh or Net Change database updates
- Create SSIS packages individually or from a file list
- Generates SQL DDL for associated data exports
- Automatically maps U2 dictionaries to SQL columns
- Automatically maps ODBC fields to SQL columns
- "Delete and Insert" updates supported
- Automatically run package after data extraction
- Optionally schedule using SQL Server agent
- Configurable error thresholds
- Email notification of exceptions
- Detailed processing & event logs facilitate troubleshooting
- Message-based architecture guarantees data delivery
Pre-Defined Operational Data Stores (ODS)Kourier Integrator and SQL Accelerator have been used to implement Microsoft SQL Server data warehouse, business intelligence and other integrated solutions for Clients using homegrown, bespoke, and commercial U2 applications such as Ellucian Colleague, Epicor DataFlo, Epicor Eclipse, Epicor Prelude, IDS Astra and many others. Pre-defined Operational Data Stores (ODS) are also available for many of these systems.
Rapid Return on Investment - Guaranteed ImplementationKourier Integrator solutions have a rapid and guaranteed implementation. Using our data warehouse Quick Start Workbench (or pre-configured Operational Data Stores) 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 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, call Kore for details.