© 2018 Capita Business Services Ltd. All rights reserved.

Capita Education Software Solutions is a trading name of Capita Business Services Ltd. Our Registered office is 30 Berners Street, London, W1T 3LR and our registered number is 02299747. Further information about Capita plc can be found in our legal statement.

Local API - Supported and Unsupported Options

Local Interfacing Options for SIMS 

SIMS 7 - Interface via standard exports
Using SIMS exports to interface to external systems

The use of SIMS .Net to export data via standard facilities such as ATF, CTF, User defined reports and standard reports is a fully supported and safe way to exchange data with SIMS.

Whilst file formats may change there is no risk to data because SIMS import routines are fully tested by ESS. Customers would expect these to ‘just work’ assuming that for import, the formats provided are correct.

SIMS security settings are fully honoured.

 

NB: Once data is outside of SIMS, the responsibility to secure the data lies with the producer. 

SIMS 7 - Command Reporter for Interfacing
SIMS 7 Interfacing via command reporter

The use of SIMS Command Reporter to automate the import and extract of data.

 

The use of these interfaces require that a copy of SIMS .Net workstation is installed on the machine

Part of SIMS and fully supported. 

 

Easily automated without knowledge of SIMS.  At its simplest, a batch file can be used to run a report and put it in to an agreed folder.  Advanced usage such as filters would benefit from training programmatic automation would be made simpler with training.

SIMS security settings are fully honoured.

 

NB: Once data is outside of SIMS, the responsibility to secure the data lies with the producer. 

SIMS 7 interface via partner business objects
Interfacing via SIMS third party interfaces

The use of SIMS Third party business objects to read / write SIMS data. 

 

The use of these interfaces require that a copy of SIMS .Net workstation is installed on the machine

Supported by the Partner Development Support team.  These business objects are designed for easier interfacing but it is still possible to do damage to SIMS data.  These cover a subset of SIMS.

 

 

SIMS security settings are fully honoured, although the concept of ‘My’ is not enforced.

 

 

SIMS 7 interfacing via partner business objects
Interfacing via SIMS Business Objects

The use of SIMS business objects to read / write SIMS data. 

 

The use of these interfaces require that a copy of SIMS .Net workstation is installed on the machine.

Supported by the Partner Development Support team.  These business objects are the ones used by the SIMS application and may or may not be easily used within the partner’s application.

 

NB: it is still possible to do damage to SIMS data.

SIMS security settings are fully honoured, although the concept of ‘My’ is not enforced.

 

 

 

SIMS 7 - Unsupported access routes
Unsupported interfaces

Direct SQL access via ADO or other mechanisms are not supported and cannot be accredited as interfaces to SIMS .Net.

We do not publish schema or make an attempt to maintain the signatures of stored procedures across calls.

SIMS security is bypassed completely.

Notes:

  • Once data is outside of SIMS, the responsibility to secure the data lies with the partner’s product and/or the user thereof.
  • We would not recommend schools use products from third parties which use any SIMS business /Partner objects unless the third party is/has a:
    • Is a Current SIMS partner
    • Has a current contract for software updates
    • Has a current contract for development support
  • Writing data back incorrectly will incur charges to schools to investigate faults caused by accredited software.   It may not be possible to correct data incorrectly updated by accredited software.  Even if it is, we reserve the right to charge the school for the work required.
  • Partners must not distribute SIMS Dlls or other ESS IPR with their applications

 

Local - SIMS On-Premise Integration RESOURCES

Related resources for Local - SIMS On-Premise Integration