|
Microsoft SQL Server Integration
SQL Accelerator (an
optional component for Kourier Integrator) provides seamless integration between IBM U2 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. |