Why Choose Talend Solutions?

 

Next Steps

Tell us about your requirements:

+44 (0) 1494 616134

sales@talendsolutions.com

Cognita Schools on Twitter: "With colleagues and family members affected by  the tragic situation in India, we're encouraging our schools to join the  fundraising effort for the @britishasiantst's #OxygenforIndia Appeal. We  will

 

Talend Solutions has partnered with Cognita for over two years and delivered numerous data migrations and data integrations into over 40 schools:

 

E2C Data Migration

 

The E2C Programme (Enquiry to Classroom) implemented Microsoft Dynamics CRM 365 Online (D365) to support marketing and admissions business processes at Cognita. The D365 implementation replaced a variety of legacy admissions applications currently in use within Cognita schools. The E2C Programme had a requirement to migrate historic and in-progress admissions data from the legacy admissions applications to D365.

 

Talend Solutions was responsible for the design of a single common meta-data driven data migration framework, to support independent data migrations for over 70 schools using multiple different legacy admission application types to the single new D365 admissions application. One of the principal objectives was to minimise the amount of development effort required for each new legacy admissions application type and/or each new school.

 

The framework supported: data acquisition; data masking and obfuscation; data cleansing; augmentation; reference data mapping; schema validation; business rule validation; de-duplication; integrity validation; transformation; load.  The framework was designed to identify and resolve data quality and integrity issues where possible.  Full accountability, traceability, auditability and reconciliation was built in.

 

Talend Solutions designed, specified, built, configured, tested and executed the data migrations for 40 schools across the world in the first phase of the E2C programme.

 

Data Integration

 

Talend Solutions drove the analysis, design and implementation of a variety of data integrations for Cognita:

 

  • Human Resources Integration

Cornerstone On Demand (CSOD) is a cloud based HR system used by Cognita to store the golden record for Human Resources (HR).  The CSOD Interface implements integrations into and out of the CSOD system.

 

Talend Solutions decoupled these integrations by extracting the data from the relevant systems to a set of dedicated system ActiveMQ message queues (MQ), which are then read by any subscribing receiving systems.

 

  • SCR Tracker Integration

The single central record, or register, is a store of information where schools record details of staff pre-employment checks in order to comply with Department of Education recruitment standards.  The Single Central Record Tracker (SCR Tracker) is acloud-based application allowing schools to meet these requirements. The SCR Tracker interface implements integrations into and out of the SCR Tracker system.

 

Talend Solutions decoupled these integrations by extracting the data from the relevant systems to a dedicated system ActiveMQ message queue (MQ), which is then read by any subscribing receiving systems.

 

  • SIMS Human Resources Integration

The School Information Management System (SIMS) software is a thick client product (from Capita) used by Cognita at 39 UK and a small number of Spanish schools.  It is primarily installed as an on-premise solution at each school, although there is a hosted version available.

 

Talend Solutions designed, specified, built, tested and deployed an integration to synchronise staff data updates made in the Enterprise HR system, Cornerstone On Demand (CSOD), into each discrete SIMS instance.

 

  • Web Enquiry Form to Admissions Integration

Each Cognita school has its own CMS (web site or portal) and enquiry forms to capture admissions enquiries.  The Web Enquiry Form integration allows schools to submit captured form data into the new E2C Admissions application (D365).


Talend Solutions designed, specified, built, tested and deployed a solution using API services and Active MQ message queues for resilience.

 

  • School MIS to Admissions Integrations

Each Cognita school has its own school MIS, which is used to manage student data after enrolment. A variety of around 8 different MIS types are used across the schools. The new E2C Admissions application (D365) was required to be integrated with the school MIS applications to automate and synchronise student data between the systems.

 

Talend Solutions designed, specified, built, tested and deployed a meta-data driven integration framework enabling a common approach for all MIS application types and all schools in all regions. The solution used API services, Active MQ message queues for resilience and Talend jobs to validate, cleanse and transform data.

 

Talend Solutions analysed and specified the requirements to implement the framework for SIMS and PowerSchool MIS application types and successfully built, configured, tested and deployed the solution for the first schools in the E2C Programme.