External Information Systems Gateway  

WebTutor has a component that lets you customize the system to import/export information to and from an external information systems and databases. The gateway allows you to upload data into the system for any body of information (staff, training, tests, training organizations, etc.). After setting the import/export parameters, they are saved in a system database and can be used repeatedly (or in automatic mode on a scheduled basis).

Fig. 1 - Setting database export parameters

Main features:

  • Ability to download data using: XML, Excel, CSV, and tab-delimited files
  • Simplified user interface to import employees from MS Excel
  • Download data from relational databases through ODBC
  • Download from a Lotus Domino databases
  • Download data from Active Directory, LDAP directory
  • Supports data exchange with external applications using the web services' technology
  • Flexibility to schedule frequency of up/downloads: weekly, daily, by hour, etc.
  • Logs all operations for importing / exporting data