Data Integrations

I have been involved with integrating many applications to various Systems. I have worked with and created

  • data views
  • comma delimited, tab delimited and fixed width files
  • complex XML files (including delta mode)
  • writing directly into the system database
  • creating web-services


Internet Banking Payment System
Wrote the CRN algorythm (with check digit) and integrated into the invoicing system. Wrote an automated cronjob that reads and loads the BPay transactions back into the finance system.


ePortfolio System
Relevant data from Banner was collated into a series of XML data files and sent to the ePortfolio server.


Student Placement Software
There were approximately 15 XML files - all in delta mode for which I had to build the capability into the extract to accomplish.


Student ID Cards
A single view from the Student Information System was built that provided all the information necessary for the production of ID cards. I also implemented a barcode algorythm for the ID cards that was seamlessly integrated into the library system.


Research Master
I wrote a sophisticated routine to extract research data and upload the relevant information into the University's Academic Workload Planning System for each staff member.


Timetabling and examination scheduling software
Data views were provided for the timetabling, a web service connection via Moodle for examinations and my very own DE Application wrote data directly to the exam scheduler database for deferred exams.


Learning Management System
I built an easy to use secure web-service that allowed the Moodle integrators to access the required data from Oracle and SQL-Server using standard SQL statements.


Appointment Booking Software
I built a couple of views that the SARS-Grid application could connect to and extract the necessary data.


Library System
I built XML data extracts from Banner and a cronjob would ftp the files to the library system (Unilinc).


Timetabling and self allocation software
I built a series of views and flat file exports with an additional table that the vendor could update to control the semester codes that the views related to.

Comments

Add new comment

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
By submitting this form, you accept the Mollom privacy policy.