CamSIS Connect is a software utility which is provided free of charge to Colleges and Departments. The utility is designed to maintain a copy of the CamSIS Outbound Interface (OBI) data in a local database within the College or Department.
The first time that CamSIS Connect runs, it will copy all information for the particular College and Department into the local database. Subsequently, the utility will download only the incremental changes.
At present, CamSIS Connect has been developed and tested on SQL Server 2015, SQL Server Express 2015, Oracle9i, Oracle 12c, Oracle 11g and MySQL 5.7 databases.
However, the Connect utility has been written using the Hibernate persistence framework (http://www.hibernate.org) and therefore there is the potential to support the other database platforms detailed at http://www.hibernate.org/80.html.
If you have a requirement to use a database which is supported by Hibernate, but for which CamSIS Connect has yet to be tested please contact the CamSIS Helpdesk (firstname.lastname@example.org) with your request.
The CamSIS project offers two methods of installation. If required, a member of the CamSIS project team can visit your College or Department to install CamSIS Connect.
Alternatively, the College or Department can opt to install the utility themselves by downloading the program from our servers and following the associated documentation.
Whichever option is chosen, you will need to follow the Pre-Installation instructions detailed below.
- Obtain a username and password for the CamSIS Outbound Interface (OBI) by contacting the CamSIS Helpdesk (email@example.com)
- Verify connectivity to the OBI - follow the instructions on https://www.camsis.cam.ac.uk/cam-only/current_users/obi/ to ensure that you can successfully open a connection.
- Follow the instructions in this document Pre-Installation Instructions to ensure that Java is installed and other system requirements are met.
Note: The download page is protected by Raven, and you will need to send a request to the CamSIS Helpdesk (firstname.lastname@example.org) to be added to the list of permitted users before you can access the page.
CamSIS Connect can be downloaded from http://www.admin.cam.ac.uk/offices/misd/services/web/download/
If you are undertaking the installation of CamSIS Connect, or wish to refer to the installation instructions, they can be obtained from:
On the command line, navigate to the directory where CSConnect is installed, then type one of the following commands:
- csconnect setup ( This will create all the tables )
- csconnect flush ( This will delete all existing data and reload )
- csconnect immediate ( This loads changes since the last update )
- csconnect prompts ( This loads all the prompt tables )
- csconnect inbound ( This loads DORM addresses into PS_UC_CLG_INBND_RM ready for the Inbound Interface Program )
Immediate mode send emails. To turn this off you will need to modify the csconnect.bat file by adding -Q to the end. e.g. -Mimmediate –Q
Debug switch can be set for any mode to provide better error logging. Modify the csconnect.bat file by adding -D to the end e.g. -Mimmediate –D
CURRENT_STUDENTS – single row for all active students and academic details
CONTACT_DETAILS – single row for student phone and email details
MySQL users may see a warning message regarding SSL. This can be resolved by adding “?useSSL=false” to the end of your local url connection string within the parameter file.
CamSIS Connect is still being developed and tested. If you uncover any issues, or have suggestions for improvements, please sent these to the CamSIS Helpdesk: email@example.com.
|Version||Release Date||Status||Enhancements made / Issues resolved|
|1.18||28 March 2017||Current||Added AS_CPP_P for academic structure mapping|
|1.17||2 January 2017||Previous||Support for MYSQL version 5.7, Record UIEX – Field UC_EBLRESULT value altered, New Contact Details table|
|1.16||15 December 2016||Previous||Altered table: PERS|
|1.15||September 2015||Previous||Source of Fee alterations to FIN,STFE and MST_CD_P|
|1.14||March 2015||Previous||Student Financial table changes|
|1.13||8th December 2014||Previous|
|1.12||3rd July 2013||Previous|
|1.11||20th Jan 2012||Previous|
|1.10||1st Nov 2011||Previous|
|1.09||14th Jun 2011||Previous|
|1.08||15th Mar 2011||Previous|
|1.06||08th Dec 2010||Previous|
|1.05||20th Sept 2010||Previous|
|1.04||16th Aug 2010||Previous|
|1.03||16th Mar 2009||Previous|
|1.02||16th Mar 2009||Previous|
|1.01||5 Nov 2009||Previous|
|1.00||5 Jun 2009||Previous|