The new release of Kourier Integrator for U2 focuses on streamlining the process of creating a SQL data warehouse from a U2 database from start to finish while making it even faster and easier than before.

The most significant feature in this release is the new data warehouse Quick Start Workbench. This new workbench encapsulates all the tools and tasks necessary for building a Microsoft SQL Server data warehouse from U2 files into one easy-to-use interface. Users can analyze files, review data profiling information, revise file schema, and generate all of the data exports, services, and SSIS loading packages necessary to build and maintain a normalized SQL data warehouse.

 

New Features & Improvements Summary

 

Data Warehouse Quick Start Workbench

• Accelerates the process of creating a Microsoft SQL data warehouse from a U2 database from start to finish
• New easy-to-use interface encapsulates all the tools and tasks necessary for building a SQL Server data warehouse
• Analyze files, review data profiling information, and revise file schema
• Generate all data exports, services, and SSIS loading packages for a normalized SQL data warehouse
• Configuration options provide customization and dynamic character and word substitution

Unified Scheduling
 

• Streamlines U2 data extraction, transformation, and SQL Server data loading into a single scheduled process
• Option to automatically run SSIS data loading packages immediately after data extraction
• Individual SSIS packages can be scheduled independent of data extraction for complete flexibility
• Option to run interdependent SSIS packages asynchronously or synchronously

File Compression
 

• Option to use file compression and extraction when using ftp data transfers
• Increases data transfer performance and reduces network traffic

Multiple SSIS Package Generation Options
 

• Users have multiple methods for generating SSIS packages:
  • By File
  • By Export
  • By Service
• The By Service option generates SSIS packages for all files related to a service

Predefined Operational Data Stores (ODS)
 

Additional Information

 

• Click here For a comprehensive Product Feature list.

Learn More

If you would like more information regarding Kourier Integrator and how it can help you quickly create a Microsoft SQL Server data warehouse with information from U2 and/or other data sources, or integrate with other applications please contact your Kore Technologies representative, call us at 866-763-5673.

MultiValue integration solutions that breathe new life into your enterprise applications. Contact Kore Technologies and let us know how we can serve you!