The Fast Track to Better Colleague Reporting
Operational Data Store Powered by Kourier Integrator and SQL Accelerator

The Fastest, Easiest Way to Integrate Colleague with Microsoft SQL Server

It opened up avenues to be able to use the data across campus in ways that, at the time, we didn’t envision."
-- Sam Howard, Director of Enterprise Software and Portal Systems, Wittenberg University

Want to Unleash Your Ellucian Colleague Data?

Kourier Integrator with SQL Accelerator will put you on the fast track to better Colleague reporting and business intelligence.

Kourier Integrator is the easiest, most flexible, and reliable technology for integrating your Colleague data with Microsoft SQL Server. Everything you need to quickly define and manage a SQL Server data warehouse is included, starting with a pre-configured Operational Data Store (ODS).

Kore's ODS for Colleague has pre-defined data mappings for many commonly used Colleague files. And by using Kore's Net Change Technology, your data warehouse is updated in near real-time, enabling you to create time sensitive reports and dashboards for your business critical data.

Kourier Integrator is a fast, effective, and reliable integration solution. In most cases your data warehouse can be up and running in less than a week using Kore's Fast Track Implementation program!

Many colleges are already using Kourier Integrator and SQL Accelerator to build and maintain their Colleague SQL data warehouse for improved data access, easier reporting and better business intelligence. Contact us to find out about our trial program and try it for yourself.

Key Benefits and Features

  • Rapid Implementation and ROI
  • Low Ongoing and Total Cost of Ownership
  • Near Real-time updates from Colleague to SQL
  • High Performance and Scalable
  • Pre-defined Colleague Operational Data Store
  • Data Warehouse Quick Start Workbench
  • Customizable and Extensible ODS
  • Supports Custom Colleague files and fields
  • Uses Reliable Microsoft SSIS Technology
  • Data Aggregation from Multiple Accounts & Files
  • Fault Tolerant Design
  • Data Auditing & Reconciliation
  • Excellent Customer Support and Service
For a Personal Colleague-to-SQL Product Demonstration See Kourier Integrator in Action!
Kore offers value and low total cost of ownership for their product. In today's economy, with the community college system cutting our budget, this was a real value for us.
- Ron Smith - IT Director, West Valley-Mission Community College District
Read West Valley-Mission's Colleague-to-SQL Success Story
Read More SQL Integration Client Success Stories
Colleague Operational Data Store (ODS)

Why use an ODS? Because you will have faster, easier access to your Colleague data when it's in a normalized Microsoft SQL Server data base. You will also have far more choices for your reporting and business intelligence software too, including: Rocket Software CorVu, IBM Cognos, Microsoft Excel, Microsoft Reporting Services, and SAP Crystal Reports.

Kore's pre-defined Operational Data Store (ODS) for Colleague provides the fastest and easiest way to get started with data warehousing for your Ellucian (Datatel) system. Included in the Colleague ODS are pre-configured data mappings for about 200 key Colleague files representing over 550 normalized SQL tables. The ODS can be used as the basis for developing custom reports and dashboards or as the foundation for an enterprise business intelligence system.

Information for these areas is included from key Colleague files in the ODS:

  • Applications
  • AR Invoices
  • Budgets
  • Buildings
  • Credentials
  • Courses
  • Course Sections
  • Divisions
  • Financial Aid
  • General Ledger
  • Grades
  • Grants
  • Persons
  • Staff
  • Students
  • Student Academics
  • Wait List
  • and more...

The Colleague ODS is ready to use and includes everything you need to create and maintain a Microsoft SQL Server data warehouse, and it's customizable and extensible to meet your needs.

Your Colleague ODS is always up-to-date because Kore's "Net Change" technology constantly monitors the Colleague database for any changes, and then performs optimized, near real-time updates to the SQL database using Microsoft SSIS technology.

The result: high performance and scalability with guaranteed data delivery.

Contact Kore for a Colleague-to-SQL Product Demonstration or Call Us at 866.763.KORE